I have a document library that has reached it's 5000 view limit and I'm trying to retrospectively create views on indexed lookup columns.
I can successfully return views that are customised in SharePoint Designer to use the Interger Lookup ID. However on queries that exceed 5000 with one column filter I need to filter on an additional lookup and I can't seem to get that to work.
<Query> <GroupBy Collapse="TRUE" GroupLimit="500"><FieldRef Name="Project_x0020_Category"/></GroupBy> <OrderBy> <FieldRef Name="LinkFilenameNoMenu"/></OrderBy> <Where> <And> <Eq> <FieldRef LookupId="TRUE" Name="Program"/> <Value Type="Integer">6</Value> </Eq> <Eq> <FieldRef LookupId="TRUE" Name="Responsible_x0020_Group"/> <Value Type="Integer">9</Value> </Eq> </And> </Where> </Query>
In response to a query additional information may be of help pinpointing the issue:
I'm querying a document library that has reached it's 5000 view limit, it is managed by Document sets and the filter data is to be used in the custom document set for each content type.