5

I have a webpart that shows the task list, and has more than 5000 items, the list view threshold is 5000 items.

However, when I checked the view used in the webpart, it says return items in batches of 10 items.

Why am I receiving this error if its supposed to return items in batches of 10>?

2 Answers 2

5

As already explained, the view queries all the tasks in the list (>5000 items) and returns all the items (>5000) in batches with pagination. In order for your webpart to work, it has to query less than 5000 items and it has to return less than 5000 items too. The filtering column must also be indexed.

Realistically speaking, your options include the following:

  1. If you intend to show the Tasks assigned to the current user, create a view with the filter Assigned to'is equal to' [Me] and index the Assigned column
  2. If you wish to show Tasks for all users, it may be better to just show incomplete tasks, in which case you need to create a view with the filter Status 'is not equal to' Completed and index the Status field.
2
  • Why an index in the created column and not in the "assigned to" column? Commented Dec 20, 2013 at 7:51
  • Sorry, just a typo. Thank you for pointing it out; I corrected it
    – yandr
    Commented Dec 20, 2013 at 11:20
8

The webpart item limit only affects the front end display (pagination)- so a request for all the items is still sent to the database. I suggest you create numbers of views to display the data. When creating the views, you can set the Filter to limit the items shown in each view to 5,000:

  1. Click Show items only when the following is true.

  2. For the first view, select ID, is greater than or equal to, 1, click And, then select ID, is less than or equal to, 4,999.

  3. For the second view, select ID, is greater than or equal to, 5000, click And, then select ID, is less than or equal to, 9,999. Set the Filters of the views one by one, like the above.

For your reference:

1
  • 1
    Also, it would be prudent to put a filter in place that the Assigned To user is equal to [Me]. Commented Dec 18, 2013 at 18:23

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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