I want to create a paginated view that shows me ALL the items, 30 items at a time. I have a list with 8000 items. The item limit is 5000 items, so I got this error on the "All Items" view:
This view cannot be displayed because it exceeds the list view
threshold (5000 items) enforced by the administrator.
I first created an index on the "Title" column. I set it as the first and only column in the view. I also set the item limit to 30 rows:
The next step is where I got stuck: Filtering. How am I meant to filter on the index? Title is not equal to NULL? I'm not sure how I can succesfully filter to prevent SharePoint from loading more than 30 rows at a time. I'm missing something here.
Basically, in order to get past the List View Threshold, you need to specify a filter on a column that is indexed (and returns less than 5000 items). If a column is not indexed you can choose to index a non-indexed column.
For a view to quickly filter through a large number of items, the
first column that you specify in the filter must be indexed. Other
columns you specify in the view filter may or may not be indexed, but
the view does not use those indexes. You also need to make sure that
the first column of the filter does not return more items than the
List View Threshold, even if the final result of the filtered view
returns less than the List View Threshold.
If the first column of the filter returns more items than the List
View Threshold, you can use a filter with two or more columns. When
you define a filtered view that uses two or more columns, using an AND
operator will usually limit the total number of items returned. But
even in this case, you still need to specify as the first column in
the filter the column that most likely returns the lesser amount of
data. Note that using an OR filter almost always increases the number
of items returned and won't be effective under these circumstances.
With SharePoint lists that exceed the list threshold, any use of item grouping or the use of field totals (sum, avg, count, etc...) will result in the "list view threshold" message if the data used by the group or total exceeds 5,000 records.
If there is a filter the restricts the number of records in the full query to less than 5,000 the use of groups or totals should continue to work as expected.