Take the 2-minute tour ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

I have created a Site Collection with a number of Sites that were created using the same Site template have therefore have an instance of the same List type (Issue Tracking) - 'Tasks'. I simply want to create a Dashboard overview on the root Site of the Site Collection. The CQWP seemed an obvious choice for this. However, I can't believe that the only way to add more fields and customize it to display anything useful is to Export the Web Part, change the XML by hand and then create custom XSLT!

I literally want it to display the aggregated List content, presented in exactly the same format as the child Lists - I don't need to change the fields or provide a fancy design. Even if I did this manual process once it seems slow, error prone and time consuming. Is there anything out there that would allow me to simply define a View on child Lists and then specify that View in the Web Part properties. It would then render like any any other List.

I can develop this Web Part myself if necessary, but I want to make sure I haven't overlooked anything first.

Thanks,

Mike Taylor

share|improve this question

1 Answer 1

"List Type" is meaningless from a SharePoint perspective as it sees everything in terms of content types. If your custom list uses a specific content type then the CQWP can easily query all items of that type across the entire site collection (if needed), but if each list just has its own fields without using a content type then you pretty much have to roll your own solution based on the list name instead.

Adding custom fields is precisely how you describe but not quite the way you describe it. Exporting the web part and modifying the XML is only required once and that is only to tell it to use a different XSL file when it renders. Once that is done and uploaded back to the page, you shouldn't need to edit the Xml again. The custom fields is actually done by adding them to the Item rendering XSL and choosing that Item Style from the dropdown. That makes the custom fields visible in the Tool Part and then you can remap to your heart's delight. You can also edit freely edit the custom XSL file as well to make it behave the way you like.

Why Microsoft doesn't include the option to specify a different XSL file right in the tool part is beyond me, but that is what they did. They allow it for the XML Viewer Web Part, but not this one, go figure.

share|improve this answer
    
I see what you're saying, and my understanding of Content Types is obviously not all there, but this is not a Custom List - it is the built in Issue Tracking one I believe. As far as your comment on XML - from what I've read (and I could be wrong) you need to change CommonViewFields too, which to me is the error prone bit - finding the correct field InternalName and Type to use is a faff IMO. I haven't done the XSLT part yet, but importing the Web Part with CommonViewFields changed gives you no hint as to whether it actually got parsed correctly or not. –  Michael Taylor Dec 11 '12 at 17:59
    
Go into one fo the list settings and click on the Advanced settings link. Toggle the Allow management of content types to Yes and click OK. This will then tell you what the content type is for the Issues Tracking list and in turn use that in the CQWP to roll up the data. –  PirateEric Dec 11 '12 at 18:05
    
Ok, done what you suggested but I'm not exactly sure what's changed. I can see that 'Issues' is the only Content Type and in CQWP I have changed it to use List Content Types and Issues. I still only get one column displayed - how do I get more without messing about in XSLT? –  Michael Taylor Dec 11 '12 at 18:15
    
How it appears is in the Presentation section of the CQWP settings and it has a limited number of Item Styles available out of the box. If you need more or a different layout, you will need to create your own XSL. This might help: heathersolomon.com/blog/articles/customitemstyle.aspx –  Dave Wise Dec 11 '12 at 18:50

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.