$Destination:\ SharePoint 2013$

Destination:\ SharePoint 2013

Quick Launch

All Site Content

Destination:\ SharePoint > Destination:\ SharePoint 2013 > Posts > Query multiple lists across sites in a web site collection

September 12

Query multiple lists across sites in a web site collection

by Srini Sistla

on 9/12/2010 9:33 AM

Category: RollUp; SPSiteDataQuery; Sandboxed

Title: Query multiple lists across sites in a web site collection

Details: SPSiteDataQuery Class - This is one of the very intresting and wonderful classes available in SharePoint to retreive information from list across sites in the same web site collections. How many of you have tried the roll up ( not including the CQWP ) by coding? Look at the below code and see the simplicity of it. Simply build the SPSiteDataQuery ( query ) to the GetSiteData Method and get DataTable in return. One important thing to notice is that, it is not supported in SharePoint 2010 Sandboxed Solutions.

Code:

void UsingSPSiteDataQuery(SPWeb web)
{
   SPSiteDataQuery query = new SPSiteDataQuery();
            
   query.Lists = "";
   query.ViewFields = "";
   query.Webs = "";

   web.GetSiteData(query);
}

2 Comment(s)

Comments

Query multiple lists across sites in a web site collection

Post migrated by Metalogix - The SharePoint Management Experts
www.metalogix.net
9/11/2010 2:42:43 PM
Commented by Metalogix Software Corp. on 9/11/2010 2:42:43 PM

Srini Sistla

on 9/11/2010 1:48 PM

List Query to Multiple Site Collection

hi srirni....

great post ...

is there any way to Query data from multiple site collections other than FullTextSQLQuery

on 3/29/2011 1:36 AM

Gabriel

http://www.hisdress.com/flower-girl-dresses.html flower girl dresses cheap http://www.celldress.org evening dresses http://www.celldress.org/cocktail-dresses.html tight cocktail dresses http://www.hisdress.com/mother-of-the-bride-dresses.html mother of the bride jacket dresses http://www.loldress.com cheap wedding dresses http://www.didwatch.com fake watches

on 3/12/2012 11:42 PM

lewis

http://www.watcheview.com/cartier-watches.html http://www.watcheview.com/rolex-watches.html http://www.watcheview.com/rado-watches.html the hill spot has previously been registered as being a common Jordan Chicagos location amongst the vacationers on the country and undoubtedly this charming hill station will entice world tourism really soon http://www.fakesale.org/rado-watches.html . The mesmerizing view of your hill city is definitely the landmark of the trade of tourism in Lavasa that fascinates the vacationers with glory and grandeur. Lavasa tourism is a developing marketplace that's quickly anticipated to outshine like a flourishing industry with the charms that the land http://www.watcheview.com/seiko-watches.html http://www.fakesale.org/rolex-watches.html

on 3/16/2012 9:37 PM

harris

http://www.dresscome.co.uk cheap plus size junior dresses http://www.dresscome.co.uk/celebrity-dress-function-occasion.html celebrity maternity dresses http://www.dresscome.co.uk/formal-wedding-dresss-function-occasion.html formal dress http://www.dresscome.co.uk/celebrity-dress-function-occasion.html cheap celebrity dresses http://www.dresscome.co.uk/mother-of-the-bride-dress-function-occasion.html mother of the bride dress http://www.dresscome.co.uk bridal wedding gowns http://www.dresscome.co.uk/bridesmade-dress-function-occasion.html plus size bridesmaid dresses

on 3/23/2012 9:29 PM

joyce

commonplace in the PC market as well. http://www.backshoes.net/pumps.html These new interfaces supplanted the more complex and pricy SCSI interfaces, resulting in standardization and cost reductions for the external hard drive. The internal structure of external hard disk drives resembles standard hard disk drives; in fact, they include Bell & Ross replica a normal hard disk drive which is mounted in a disk enclosure http://www.backshoes.net/classic-collection.html . http://www.backshoes.net/pumps.html For an external hard disk now the capacities range from 160 GB to 4TB and the cost per gigabyte varies between . http://www.backshoes.net/classic-collection.html . 15 and . .40 USD. http://www.backshoes.net . As an external hard disk retains the platters and moving heads of traditional hard drives they are much less tolerant of physical jolts than flashbased technology (a fact often overlooked by buyers lulled into a false sense of ruggedness by their styling). Larger versions often include fullsized 3.5" fake Swiss Mont Blanc watches PATA or SATA desktop hard drives, can be found in the fake Swiss Roger Dubuis same size ranges, and generally carry a .

on 6/2/2012 7:14 AM

Brian Atwood Adara Lace-Up Calf Hair Ankle Boot

on 9/29/2012 2:56 AM

Sueyuang Green

on 10/15/2012 4:28 AM

Re: Query multiple lists across sites in a web site collection

on 10/15/2012 5:19 AM

Louis Vuitton Handbags

on 12/8/2012 1:23 AM