Expand Minimize

Assign RowLimit for SPQuery in limited range

Assign RowLimit for SPQuery within the limited range (default 1 to 2000).

CheckId SPC050250
TypeName AssignSPQueryRowLimitInLimitedRange
Severity CriticalWarning
Type Assembly

The RowLimit property is used together with the ListItemCollectionPosition property to define paging in a query. See sample below:

using (SPWeb oWebsiteRoot = SPContext.Current.Site.RootWeb)
{
   SPList oList = oWebsiteRoot.Lists["Announcements"];
   SPQuery oQuery = new SPQuery();
   oQuery.RowLimit = 2000;
   oQuery.Query = "<OrderBy Override=\"TRUE\"><FieldRef Name=\"FileLeafRef\" /></OrderBy>";
   ...
}

Name Description
MaxAllowedSPQueryRowLimit Integer with maximum allowed RowLimit for SPQuery. Default: 2000

To suppress this violation in managed code add the following attribute to the method which contains the instruction (available since SPCAF version v5.2). Learn more about SuppressMessage here.

// Important: Ensure to have #define CODE_ANALYSIS at the beginning of your .cs file
[SuppressMessage("SPCAF.Rules.BestPracticesGroup", "SPC050250:AssignSPQueryRowLimitInLimitedRange", Justification = "Provide reason for suppression here")]
Disclaimer: The views and opinions expressed in this documentation and in SPCAF do not necessarily reflect the opinions and recommendations of Microsoft or any member of Microsoft. SPCAF and RENCORE are registered trademarks of Rencore. All other trademarks, service marks, collective marks, copyrights, registered names, and marks used or cited by this documentation are the property of their respective owners.