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

We are designing a system with a national level, regional level and a sub-regional level.

We plan to implement this with a site structure with sub-sites and sub-sub-sites.

The sites at the lowest level will have a list.

One the level above we would like to have a list that contained all items from all subsites.

Is this possible without copying the list items?

share|improve this question
up vote 10 down vote accepted

Yes this can be achieved by using an SPSiteDataQuery. See: This will require some programming.

If you do not want to develop against the SharePoint Object model, then use the Content Query Webpart (requires SharePoint Publishing Infrastructure feature activated). You will need to modify some XSLT in this scenario.

Another way is to use the DataView webpart and set scope to recursive. See: This can be done from SharePoint Designer.

share|improve this answer

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.