Site and Sub Site List Aggregation

Is there a way to get all items for any given list (ie Contacts) for all sites and subsite using a single web service call Right now I am getting a list of all sites using "GetAllSubWebCollection" web service method, then for each site get the items for a given list. This is taking a very long time, can I execute a query from the root site and get this same list

Thanks



Answer this question

Site and Sub Site List Aggregation

  • 2006

    will the list data service return only data for the current site and not the sub sites Or will it return all data, including sub sites.


  • Simone1

    I'm using 2003. I've been messing around with the List Data Retrieval Service but can't seem to get the "select" statement right. Is this the right direction I should be going or can I use something else
  • Yogendran

    no, its not.

    Basically, the search engine isnt the way to go at all, but instead you will have to use custom code (build your own web service for example) that will run a recursion on the sites. A CAML query on each list will return the items you want and you will be able to aggregate. but instead of doing that, I would recommend buying a 3rd party aggregation web part. I worked for a company called omnisys who has such a web part (power aggregator) that has tons of options (www.omnisys.co.il) and I know that Corasworks also have similar products. I would recommend buying rather than developing. Cheaper this way.



  • Grant McElroy

    version 2003 or 2007

  • ajaimes

    I have no way of checking since my entire environment is now 2007 (which has a solution for this built in) Sorry

  • Site and Sub Site List Aggregation