Question:How to get the data from multiple lists? Or What is SPSiteDataQuery class ?


SPSiteDataQuery class is used to retrieve data from multiple lists. Use SPSiteDataQuery object to aggregate data from multiple lists, which obviates the need to enumerate sites and lists.The SPSiteDataQuery class is used to query data from multiple lists across different sites in a site collection. SPSiteDataQuery is commonly used in list aggregation scenarios, where list data from team sites or other subsites is collated and presented in a single interface. Unlike the SPQuery class, you cannot use join predicates or projected fields with the SPSiteDataQuery class. The SPSiteDataQuery will only aggregate data from SharePoint lists and will ignore data from external lists.
Note: It’s not a best practice to use SPSiteDataQuery instead of that make a use of ‘for’ or ‘foreach’ loops to aggregate data.

asked Sep 13, 2013 in SHAREPOINT by rajesh
edited Sep 12, 2013
0 votes

Your answer

Your name to display (optional):
Privacy: Your email address will only be used for sending these notifications.
Anti-spam verification:
To avoid this verification in future, please log in or register.