Take the 2-minute tour ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

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:

enter image description here

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.

Related: Sharepoint list view threshold maximum limit? (Many more similar questions but I could not find the answer).

share|improve this question
add comment

1 Answer 1

up vote 0 down vote accepted

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.

Excerpt from Office.com:

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.

To create an indexed column (Except here):

  1. Navigate to the site that contains the list or library.
  2. Click its name on the Quick Launch, or click on the Settings menu , click View All Site Content, and then click the name.
  3. Click List or Library > List Settings or Library Settings.
  4. Under the Columns section, click Indexed columns.
  5. On the Indexed Columns page, click Create a new index.
  6. Do one of the following: To create a simple index:
    1. In the Primary Column section, under Primary column for this index, select the column.
    2. Click Create. To create a compound index:
    3. In the Primary Column section, under Primary column for this index, select the column.
    4. In the Secondary Column section, under Secondary column for this index, select a different column.
    5. Click Create.
share|improve this answer
    
As the question indicates, I have already created an indexed column. I have set it as the first (in fact, the only) column in the view. The view is not filtered. I want the view to show ALL the items, 30 items at a time using paging. So far, I know that under Filters, I have to choose "Show items only when the following is true:". What next? –  David Jun 26 '13 at 15:05
    
Indexing a "Title" column isn't practical. Filter another column that is more predictable and recurring. Otherwise, for example, You can create a view called "A-B" that filters the Title column based on: "Title" -> Begins with -> A ** OR ** "Title" -> Begins with -> B –  Mike Jun 26 '13 at 15:31
    
Yes, but I want the view to contain all the items, not just those beginning with A or B. Essentially, I don't want any filtering but it seems compulsory to overcome the item limit. Any ideas? –  David Jun 26 '13 at 21:51
    
The only way is to increase the limit. CA -> Application Management -> Manage Web Applications -> Highlight web application -> General Settings dropdown menu -> Resource Throttling -> List View Threshold -> Change number -> Click OK. –  Mike Jun 27 '13 at 14:36
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.