EndUserSharePoint.com: How can I get an aggregated list of all my tasks?
The question of the day comes from Diane:
Is there a web part that would pull all tasks assigned to me from sites and sub-sites into one aggregated list?
Diane – Yes, you want to use the Content Query Web Part (CQWP).
Put the CQWP on your desired page. Configure the query to “Show items from the following site and all subsites”. Point to the highest level site that contains information you would like to aggregate. It will automatically drill down to all subsites. For the List Type, choose Tasks. Scroll down and set your “Additional filters” to filter for your name in the “Assigned to” column.
I would probably use [ME] as the filter. That way, anyone coming to the site will see their tasks, not yours. It just depends on what you are trying to display. Ryan at Get the Point has also provided possible uses for the [ME] filter.
This all assumes that you have the CQWP enabled in MOSS and all of the information is in one Site Collection.
Hope that helps.
Mark
Hello,
is there also a solution for WSS 3.0? Because there is no CQWP, or?!
regards,
Kristof
Kristof – Chris works more with WSS than I. Let’s see what he has to say. — Mark
Sorry, there is nothing in WSS that will aggregate content. The CQWP is part of the publishing features that come with MOSS, but there may be some third party tools at Codeplex that could be used on a WSS site. (www.codeplex.com)
Can I get this list on MySite?
I just get an error saying “there was an error retrieving data to display in this web part” when I follow your instructions.
Any ideas how to fix that?
To accomplish this content aggregation in WSS 3.0, you should consider the Bamboo Solutions List Roll-up Web Part. This is one of our most popular Web Parts. Here is a link to the detailed product page: http://store.bamboosolutions.com/ps-32-5-list-rollup-web-part-release-31.aspx
Like all Bamboo Web Parts, you can download and try it for free.
Bamboo List Rollup will allow you to aggregate content from any kind of list (e.g. tasks, contacts, bugs, etc.) or document libraries into a single dynamically updated data view. Further, you can filter the aggregated display, even apply CAML filtering for more sophisticated applications.
Priced at $600.00, this is some of the most powerful functionality for the money you can buy. It will completely solve your content aggregation headaches… and enable a whole new wave of applications on your portal.
I hope this information is helpful. Drop by our community site at community.bamboosolutions.com and give us the thumbs up if we made your life a little easier.
Another possible option would be to use an XML webpart. It’s essentially the same process as using the webpart to act as an RSS aggregator – you link it to the RSS feed of the tasks list then modify the XSL to get the desired displayed results (compare currently logged in user to the assigned user field, etc.).
It may or may not work for this scenario, but it appears promising.
Here’s a link to how to do the initial setup and configuration:
http://www.sharepointblogs.com/erickraus/archive/2007/09/19/content-query-web-part-alternative-for-wss-3-0.aspx
- Dink
Dink,
Thanks for that tip… I hadn’t considered that web part before! Now I have to go play with it…