A class of the Microsoft.SharePoint namespace, SPSiteDataQuery represents a query that can be performed across multiple lists in multiple Web sites in the same Web site collection.

learn more… | top users | synonyms

9
votes
1answer
2k views

Client Object Model Equivalent of SPSiteDataQuery?

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 ...
5
votes
2answers
4k views

SPSiteDataQuery vs. Recursive SPWeb.Lists Performance

I'm looking for the best performing means of querying for site data within a site collection. I need to query for all of the lists in either a particular SPWeb, or a set of SPWeb's, that contain a ...
3
votes
2answers
1k views

CAML: Possible to query non existing field?

I'm using SPSiteDataQuery to fetch list contents from 2 different lists. List A) has the fields CustomField and Title List B) has only Title Is it possible to build a (filter) query with ...
6
votes
2answers
7k views

CAML Query with Date Range

I'm writing an SPSiteDataQuery and I am having issues with the Query property. I need to return all results where the Record_x0020_Yr_x0020_End_x0020_Date is between 12/31 of the current year and 90 ...
2
votes
1answer
697 views

SPSiteDataQuery throwing exception while setting it's Query property

I am querying multiple task lists in a SharePoint site. I can retrieve the results until I set the Query property and specify the OrderBy clause. The detailed exception and code is pasted below. ...
1
vote
2answers
825 views

CrossListQueryInfo\SPSiteDataQuery how to skip items with specific WebId?

Customer wants to see 10 news items from all webs on front page. Also customer wants to specify some news that we should skip. I am trying to do next thing: var id =1; <Neq><FieldRef ...
0
votes
1answer
596 views

SharePoint Object Model: how to query ONLY last major version of data from Publishing Page?

I came into a situation where I wanted to use SharePoint Object Model SPSiteDataQuery to query data from Publishing Page. However, I dont want the data query based on the permission on current login ...