SSIS Components for Confluence

Build 25.0.9545

FullOrderByPushDown

Specifies whether provider pushes ORDER BY operations on the server-side for datetime columns that only support second-level precision.

Data Type

bool

Default Value

false

Remarks

Some datetime columns in Confluence support ordering only at the second level, which can cause inconsistent results when milliseconds are present.

When set to false, ORDER BY for these columns is applied client-side to preserve millisecond precision.

When set to true, component pushes ORDER BY for these columns to the server and trims milliseconds to match the server's precision. Millisecond values are removed even when the query does not include ORDER BY.

This property is useful when you require server-side ordering for limited-precision datetime columns and do not need millisecond accuracy.

Copyright (c) 2026 CData Software, Inc. - All rights reserved.
Build 25.0.9545