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>?
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:
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:
Click Show items only when the following is true.
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.
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:
