Specifies whether to disable the 5000-record limit for list filters in Microsoft SharePoint REST queries. Setting this to true attempts server-side processing beyond the limit, but may result in server errors.

Data Type

bool

Default Value

false

Remarks

Microsoft SharePoint REST APIs natively support listing up to 5000 records based on list filters. For filters with 5000 or fewer records, server-side filtering provides the fastest performance.

When set to true, the component attempts to delegate filtering to the server even when the filter exceeds 5000 records. However, this will likely result in a server error, as Microsoft SharePoint typically enforces the 5000-record limit.

When set to false, if a filter exceeds 5000 records, the component queries from the entire list and applies filtering client-side. This avoids server errors, but introduces additional processing overhead.

This property is useful for scenarios where filter sizes vary and you need to control whether filtering happens server-side or client-side based on performance or reliability requirements.

Performance Considerations

Server-side filtering provides optimal performance for filters of 5000 records or fewer. Attempting to disable the limit for larger filters can result in server errors and failed queries. Client-side filtering allows queries to succeed beyond 5000 records, but increases data transfer and processing time, potentially impacting performance for large datasets.