I would like to display only those tasks that are assigned to the user who is currently logged in. Can this web part do that?
Hello milangross,
Yes, utilizing the SharePoint variable [Me] this can be achieved. First, you need to "prep" the data prior to building your List Rollup Data View Web Part. To do so, you will need to make sure a view exists in each list you want to rollup that has a filter where Assign To equals [Me]. If you are using the standard Tasks list this view actually already exists by default and includes an additional filter of Status does not equal Completed so you only see your tasks that you have not completed. I do need to clarify one thing though. I did just mention that the view needs to exist for EACH list you are rolling up but this is true for only static rollup (meaning you are not using the Auto-Discovery feature). If you are using the Auto-Discovery feature, you only need this view to exist in you Master List View. The reason we require a view to exist on each list (with the exception of Auto-Discovery) is because filtering occurs per list included in the List Rollup Data View Web Part.
Now that we have the data prepped accordingly, go to the List Rollup Web Part. In the List Rollup Web Part, enter the appropriate site URL where your list resides and select the appropriate list. In the their box, select the view where the filter for [Me] exists and select include list. Repeat for each list you want to include in the rollup. If you are using Auto-Discovery feature, select the top level site where you want the auto-discovery to begin at, select your appropriate list, then the view where the filter [Me] exists. No need to repeat these steps if you are utilizing auto-discovery feature, we will use the filter of the selected top level site list for all lists we discovery.
The above is the easiest method to enable filtering. Another option is you can use CAML Query as a substitute for all your lists. For more details about CAML Query, please refer to the application notes.
Let us know if we can be of any further assistance,
**************
Jeff Kozloff
Bamboo Solutions Corporation