Specifies how the provider handles ORDER BY clauses in SELECT statements.

Data Type

bool

Default Value

false

Remarks

This property determines how the connector handles ORDER BY clauses in SELECT statements.

When FullOrderByPushDown is set to false, the connector processes ORDER BY clauses locally, except when ordering by the sys_id column:

SELECT * FROM incident ORDER BY sys_id;
SELECT * FROM incident ORDER BY sys_id DESC;

The connector defaults to local sorting to avoid issues in the ServiceNow API, which may return inconsistent results, such as duplicate or missing records when sorting by non-unique columns across paginated data.

The exact cause of these inconsistencies is not fully known, and the behavior may vary depending on the data or sorting criteria used.

Enabling this property forces the connector to push all ORDER BY operations to the ServiceNow API.

While this can improve performance, it may lead to incorrect or unstable results. If that occurs, disable this property to ensure safe and consistent behavior.