SSIS Components for Microsoft SharePoint

Build 24.0.9175

DisableFilterLimit

Microsoft SharePoint natively supports listing up to 5000 records as they appear in your list filter. Use this property to pull more than 5000 records from the list filter at the cost of additional performance overhead. This property applies only to the REST schema.

データ型

bool

デフォルト値

false

解説

Regardless of whether this property is set to true or false, for list filters with 5000 or fewer records, server-side processing of list filter queries is supported by Microsoft SharePoint, leading to the fastest possible performance.

When this property is set to true and the list filter exceeds 5000 entries, the 本製品 will delegate the filters to the server, and they will be processed server-side. Note that trying to pull more than 5000 entries this way will likely result in a server error.

However, if this property is set to false (the default behavior) and the list filter exceeds 5000 entries, the 本製品 will query from the list itself (as opposed to the list filter) and the filtering will be done client-side, which has an extra cost to performance.

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