SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I'm looking for an equivalent to the SPSiteDataQuery functionality in the Client Object Model (COM).

The CamlQuery can be used with an instance of List to execute SPQuery level of aggregation, but is there an equivalent to site collection level queries for the COM?

Checked the Web object: and also the Site object and don't see anything there. SubwebQuery had a promising name, but turns out that it's not what I'm looking for.

Perhaps there's no equivalent functionality in the COM?

Any pointers would be appreciated.

share|improve this question
Those stumbling across this in the SP2013 generation - use Search to do this, plenty available with the REST API and Result Sources. – James Love Jan 26 '15 at 13:43
up vote 9 down vote accepted

There is no equivalent.

Per MSDN (suggested alternative at the end):

The CSOM does not provide a mechanism for querying data across multiple lists that are not associated by a lookup field. In other words, there is no client-side functional equivalent of the SPSiteDataQuery class. If you need to perform a cross-list query from client-side code, consider creating a list view on the server that performs the list aggregation. You can then query the aggregated data from your client-side code.from your client-side code.

share|improve this answer
That's exactly what I was looking for; great information, thanks! Now here's another question, though: a list view by nature only aggregates items in that list. The beauty of SPSiteDataQuery is that I can query every list in every sub-web. So is there some new feature in 2010 lists that allows for deeper aggregation at the list level? – Charles Chen Nov 21 '10 at 19:47

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

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