Title

“Error: The filter settings provided returned too many results. Narrow your search and try again.”

Description

“Error: The filter settings provided returned too many results. Narrow your search and try again.”

Please wait...

Using qListView for a list with over 40000 items to show 3 columns (2 columns are text and the 3rd is a number), there is a filter setup on an indexed column. The filter used is:

<Eq>

 <FieldRef Name="Case_x005F_x0020_ID" />

 <Value Type="Number">668899</Value>

</Eq>

However, the following error is displayed immediately:

"Error: The filter settings provided returned too many results. Narrow your search and try again." 

Cause

All the indexs in the SharePoint list will not work if you use the Content Type field as an indexed field.

Resolution

WORKAROUND:

Delete the index of the Content Type field.

Defect ID

All the indexs in the SharePoint list will not work if you use the Content Type field as an indexed field.