Our SharePoint 2016 site consists of 14 custom lists where each list has approximately 500 list items.
We wanted a way to query all 14 lists by PR NO which is common in all lists. We were looking for a solution implemented in JavaScript/jQuery.
I Have followed this solution to fetch all data from the 14 lists. response from server was taking too much time so we are not doing that approach.
You can do this using SharePoint Search. REST API also contains Search APIs for SharePoint.
Create a result source by adding paths of all your lists in the query builder (also specify content type contains item). Check this article for creating a result source.
Your query builder should look like this.
Check if the results are as desired and then you can use the Search API referring to the Microsoft documentation here.
To get results from result source using search rest api, I used the following url
https://spdev.sharepoint.com/sites/SPTeam/_api/search/query?querytext='*'&sourceid='46cac739-2506-4f58-bef1-d4857548cf0b'
here instead of querytext='*', you can add your PR NO. For Example, querytext='PR123123'
To build Search Rest API Queries, you can use this free tool -> SharePoint Search Query Tool. This tool is very useful in creating SharePoint Search REST API URLs.
/_api/search/query?querytext='sharepoint it is giving me the following error: {"error":{"code":"-1, Microsoft.Office.Server.Search.REST.SearchServiceException","message":{"lang":"en-US","value":"An unknown error occurred."}}} do you know what could be the reason?