Query Folding
Using query folding, the connector can delegate the processing of certain operations to the server instead of performing them locally on the client machine. When you run a query that filters on columns for which folding is supported, the connector attempts to optimize connector performance by delegating the comparison operation to the server.
For examples of how to design queries that make use of query folding, see "Design Queries that Use Query Folding" in Best Practices.
The following columns support query folding in ServiceNow:
- AND, OR operators
- Like operators (=, != )
- Comparison operators (>, <, >=, <=, =, !=)
For a full list of operators supported by ServiceNow, see https://docs.servicenow.com/bundle/orlando-platform-user-interface/page/use/common-ui-elements/reference/r_OpAvailableFiltersQueries.html.