This article explains the OData filters to help improve OnePlan performance.
The Tasks table can be pre-filtered in the OData query, enhancing the performance of task data loading. The supported OData filter operators include:
-
eq: Exact matches
-
ne: Not equal to
-
gt: Greater than
-
lt: Less than
-
ge: Greater than or equal to
-
le: Less than or equal to
-
and: Combines multiple filters with an "and" condition
-
or: Combines multiple filters with an "or" condition
You can filter on work item types by using the operators above with the work item type ID values.
The Plans table can be pre-filtered in the OData query, enhancing the performance of plan data loading. This includes plans in plan-type specific tables. The supported OData filter operators include:
-
eq: Exact matches
-
ne: Not equal to
-
gt: Greater than
-
lt: Less than
-
ge: Greater than or equal to
-
le: Less than or equal to
-
and: Combines multiple filters with an "and" condition
-
or: Combines multiple filters with an "or" condition
The Resources table can be pre-filtered in the OData query, enhancing the performance of resource data loading. The supported OData filter operators include:
-
eq: Exact matches
-
ne: Not equal to
-
gt: Greater than
-
lt: Less than
-
ge: Greater than or equal to
-
le: Less than or equal to
-
and: Combines multiple filters with an "and" condition
-
or: Combines multiple filters with an "or" condition
You can filter on OnePlan security groups by using the operators above with the security group ID values (not the group name).
You can filter on OnePlan security groups by using the operators above with the security group ID values (instead of the group name).
Comments
0 comments
Please sign in to leave a comment.