ADO.NET Provider for Confluence

Build 25.0.9434

FullOrderByPushDown

Enables pushing `ORDER BY` to the server for supported columns, including problematic datetime columns. For these columns, milliseconds are trimmed to align with the server's behavior. Note: When this property is enabled, millisecond precision is lost for problematic datetime columns, even if the query does not include an ORDER BY clause.

データ型

bool

デフォルト値

false

解説

Default: false – `ORDER BY` is not applied server-side for problematic datetime columns, as the server only supports ordering up to the second (ignoring milliseconds), which can cause inaccurate sorting.

When set to true, the driver applies `ORDER BY` on the server for these problematic datetime columns, trimming milliseconds to align with the server's second-level precision. As a result, millisecond precision is lost in these columns regardless of whether the query specifies an ORDER BY clause.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 25.0.9434