http://www.endusersharepoint.com/STP/ SharePoint Q&A en Tue, 12 May 2009 15:55:14 +0000 http://www.endusersharepoint.com/STP/topic/moss-2007-roll-up-multiple-task-lists-into-a-single-view#post-566 Thu, 07 Aug 2008 07:23:24 +0000 AutoSponge 566@http://www.endusersharepoint.com/STP/ <p>Try it without the datatype first. If you keep the datatype, there can't be any spaces between that comma and the next word.</p> <p>Because you're using TASK in all of these lists, you will end up pulling something from several lists if you keep the Query radio button set to the whole site. However, if you did not use content type settings to extend Task or create a child type, any custom columns may not be seen. </p> http://www.endusersharepoint.com/STP/topic/moss-2007-roll-up-multiple-task-lists-into-a-single-view#post-565 Wed, 06 Aug 2008 23:35:16 +0000 SharePointCurious 565@http://www.endusersharepoint.com/STP/ <p>Following these guides, I thought I would start with modifying the CQWP to display data from multiple columns in a single task list, and then work up to the understanding content types and pulling from multiple task lists.</p> <p>I was able to export the webpart satisfactorily. Just to dip my toe in the water, I tried changing the code of the CommonViewFields part as follows:</p> <p> &lt;property name="CommonViewFields" type="string"&gt;Priority, Choice;&lt;/property&gt;</p> <p>...where Priority is one of the columns in my task lists, and Choice is the type of field.</p> <p>I imported the webpart to the SharePoint page and saw no change in the data displayed--what'm I missing?</p> <p>(BTW, poking around the web, I'm wondering if this is CQWP is the right tool for the job, since all the modified versions I've seen show data in paragraph format, whereas what I'm looking to do is have columns. I.e. I want what looks to the user like a single task list, but on the backend is an aggregation of multiple such lists.) </p> http://www.endusersharepoint.com/STP/topic/moss-2007-roll-up-multiple-task-lists-into-a-single-view#post-556 Wed, 06 Aug 2008 09:33:55 +0000 AutoSponge 556@http://www.endusersharepoint.com/STP/ <p>This is the article and video that got me started:<br /> <a href="http://msdn.microsoft.com/en-us/library/bb897399.aspx" rel="nofollow">http://msdn.microsoft.com/en-us/library/bb897399.aspx</a></p> <p>Since you've already created Task lists, they will all use the Task Content Type (or children thereof). To help you determine what data you need (especially if you extended the schema of Task), I blogged a tip that outputs all parameters available to the web part (before adding custom fields):<br /> <a href="http://autosponge.spaces.live.com/blog/cns" rel="nofollow">http://autosponge.spaces.live.com/blog/cns</a>!D7F85948C20F0293!372.entry</p> <p>Post back here if you get stuck. </p> http://www.endusersharepoint.com/STP/topic/moss-2007-roll-up-multiple-task-lists-into-a-single-view#post-547 Tue, 05 Aug 2008 21:27:15 +0000 SharePointCurious 547@http://www.endusersharepoint.com/STP/ <p>Today's challenge: trying to roll up multiple task lists into a single view.</p> <p>I've created the task lists using consistent metadata--but what next?</p> <p>Google and sundry blogs have given me a dim notion that the idea is to use the Content Query Webpart and possibly Content Types, but it would be mighty helpful to have a step-by-step guide to doing this for this specific task, as thus far the best I've been able to do is to get a view of single set of list items with no metadata.</p> <p>I've seen Bamboo's list rollup web part (http://store.bamboosolutions.com/ps-32-5-list-rollup-web-part-release-20.aspx) -- $600, but is that the best way to go?</p> <p>N.b. I've got SharePoint Designer and limited chops thus far in using it.</p> <p>Thanks, gang. </p>