Connect.Collaborate.SharePoint

CQ CQ CQ Using the SharePoint Content Query Web Part with the Fantastic 40 Application Templates

(Yes, I have a HAM license) If you want to rollup information from many sites that use one of the application templates, you will find that the CQ web part property UI only exposes the standard lists (although it picks up custom fields added to these lists). The lists in the application templates are not standard ones so you have to go into the CQ and change the ServerTemplate value in the web part properties.

You can do this one of 2 ways:

  1. by exporting the web part from the browser and using Notepad and then importing the .webpart file back into the page
  2. edit the page with SharePoint Designer (only if it is a pure web part page, can't be done with a publishing page)

(2 is my preference)

The real trick is in finding the list template number. Again, you have 2 options.

  1. Look in the 12\Template\Features directory for the application template you are using and find an xml file that relates to lists.
    e.g, the ITTeamListInstances folder contains ListInstances.xml
    Projects List TemplateType=7140

    Project Tasks TemplateType=7142

    Project Issues TemplateType=7141

    Project Milestones TemplateType=7143

  2. Use my supper handy list details web part page. I always add this to my prototyping sites.
    This lets me select any list on this site and view its details, fields, views and content types.

    This page is just a number of Data View web parts that use the _vti_bin/list.asmx web service to extract this information (without any programming ;-)

So now I have a rollup across all my project sites of the tasks.


There is only one warning for you. If you edit the CQ web part properties from the Modify Shared Web Part menu, it will undo the ServerTemplate value.

Posted by Ian Morrish on Monday, 9 Jul 2007 09:49 | 0 Comments
SharePoint

Links to this post

Trackback from Blog on 12 Apr 2008 08:58

Name

Url

Email

Comments

CAPTCHA Image Validation