I have 3 sharepoint lists with the same columns. I need to fetch the list items with a particular property value, eg. CustomName property with value 'Test' from all the 3 lists. Instead of looping through each list I would like to retrieve all the list items with a single call.
The Rest api to fetch an item from a given list is below
http://server/_vti_bin/listdata.svc/TestList?$Filter=Title eq 'Test1'
But this means I have to make 3 calls, once for each list. Is there an API that I could use to query across all or multiple lists?
There is already a post explaining how to do this using the search API in sharepoint 2013. We are looking for a solution in Sharepoint 2010.