R – Aggregating news with Sharepoint MOSS 2007

mosssharepoint

Our company is split into divisions. These divisions work for client companies and are then further split into account teams that work on projects for a product of the clients.

So the structure goes Division > Clients > Accounts > Projects. And this is mirrored in the setup of our sharepoint installation. At each stage from Division to Account there is a subsite. Access to each subsite is controlled by AD groups and on each subsite there is a 'latest news' announcements list

What we want to do is have a 'wall' of announcements that feeds through so that each user can see on the top-level site all the posts in all of these anouncement lists, but this must be filtered using the AD groups that they are a member of so that confidential information isn't shown to someone who shouldn't see it.

Can anybody think of a way to do this?

Best Answer

Let's see - are those lists split accross site collection? With what tool you want to accomplish this?

You have several options (if you are within a site collection):

  1. Use Content Query Web Part to aggregate list items. You can customize it to display fields you like the way you like.
  2. You can use SharePoint Designer.
  3. Using Object Model/WebServices: Use SPSiteDataQuery class to query multiple lists at once and then SPGridView to display data.
  4. As you have a MOSS build, you could even use CrossListQueryCache. It's also a cross list query that has builtin caching and audience targeting. Be sure to read this to be sure caching is working.

If you want to aggregate between multiple site collections, then you will need to write code that get's all your SPSite objects and execute SPSiteDataQuery on them.

Maybe you can find out some additional information on Rollup of all Tasks of a Recurring Meeting in SharePoint

Related Topic