REST API - List view threshold

Question

We have a list that is now over 5000 and the following stopped working. All the fields used in filters are indexed

var requestPendUri = webAbsUrl + "/_api/web/Lists/getByTitle('LeaveRequest')/Items?$\
        filter=(((Manager0 eq '" + str + "') and (Status eq 'Pending'))\
            or ((AltManager eq '" + str + "') and (Status eq 'Pending'))\
            or ((Manager0 eq '" + str + "') and (ChangeStatus eq 'Pending'))\
            or ((AltManager eq '" + str + "') and (ChangeStatus eq 'Pending')))&$\
        select=Id&$\
        top=500";   

    var ajaxPendCount = $.ajax({
        url: requestPendUri,
        async: false,  //pass value outside of ajax
        method: "GET",
        headers: { "Accept": "application/json; odata=verbose" },
        success: function (data) {
            myCount = data.d.results.length;
        },
        error: function (data) { alert("Failed to count items.");   }
    });

I've read through Manage large lists and libraries in SharePoint. Each view is filtered and columns are indexed but still not sure how to work around the issue with REST.

EDIT I typed https://tenant.sharepoint.com/_api/web/Lists/getByTitle('LeaveRequest')/Items?$filter=(((Manager0 eq '[email protected]') and (Status eq 'Pending')) or ((AltManager eq '[email protected]') and (Status eq 'Pending')) or ((Manager0 eq '[email protected]') and (ChangeStatus eq 'Pending')) or ((AltManager eq '[email protected]') and (ChangeStatus eq 'Pending')))

replacing all [email protected] with actual email address but IE just displayed `The website cannot display the page.

But, it seems to display data if I break it down to https://tenant.sharepoint.com/_api/web/Lists/getByTitle('LeaveRequest')/Items?$filter=((Manager0 eq '[email protected]') and (Status eq 'Pending')) or ((Manager0 eq '[email protected]') and (ChangeStatus eq 'Pending'))

and https://tenant.sharepoint.com/_api/web/Lists/getByTitle('LeaveRequest')/Items?$filter=((AltManager eq '[email protected]') and (Status eq 'Pending')) or ((AltManager eq '[email protected]') and (ChangeStatus eq 'Pending'))

Have ypu checked if the records returned by the filtered view are less than 5000? — harshal gite
– harshal gite, Commented Sep 11, 2018 at 20:01
Yes, we only have 5016 records in list so far and there are only less than 100 pending items. — Tamras Merin
– Tamras Merin, Commented Sep 11, 2018 at 20:49
Did you try hitting your url in the browser? If yes, what was the result? — harshal gite
– harshal gite, Commented Sep 11, 2018 at 20:51
Should I be looking for anything specific? It says displaying 100/100 - doesn't really give me any hints if there's an error. — Tamras Merin
– Tamras Merin, Commented Sep 11, 2018 at 20:56
Can you post a screenshot of the result in browser along with your url? — harshal gite
– harshal gite, Commented Sep 11, 2018 at 20:57

Dheepa Iyer · Accepted Answer · 2018-09-11 20:29:43Z

0

Please use the search API to get the items based on your filters and then you can manipulate the items in the result source to what you want to do.

answered Sep 11, 2018 at 20:29

Dheepa Iyer

114 bronze badges

I've never used search API but will look into it. Thanks for the suggestion.

Tamras Merin
– Tamras Merin

2018-09-11 20:57:37 +00:00
Commented Sep 11, 2018 at 20:57

Add a comment |

Stack Exchange Network

REST API - List view threshold

1 Answer 1

Hot Network Questions

REST API - List view threshold

1 Answer 1

Related

Hot Network Questions