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 am trying to use CQWP (content Query Web Part- SP 2007)using a custom list (Risk Management list). I use this list on all the sub sites which I need to roll up in a single view. Can this be achieved using CQWP. When I add this web part and modify the web part, I don't see my custom list as an option. I am able to use CQWP for an OOTB list (e.g. Project task), but not for a custom list that I create.

I appreciate any help I can get on this topic. I've been struggling for the longest time.

share|improve this question
    
Did your custom lists happen to use a custom ContentType? –  Dave Wise Apr 8 '13 at 16:01
    
No, not this list in particular. –  Zankhana Patel Apr 8 '13 at 16:07
    
Just a site note,when I use custom list option, it pulls items from all custom lists, not just this particular list that I'm looking to rollup –  Zankhana Patel Apr 8 '13 at 16:18

1 Answer 1

The easiest approach would be to create a custom Site Content Type at the root of the site collection that consists of all of your required fields and then add that to each list, copying data as necessary and deleting the old columns. Once that is in place, you can easily configure the CQWP to aggregate that content from anywhere in the site collection.

Using custom Content Types for grouping common fields is a Best Practice for reasons just like this (among others)

share|improve this answer
    
I created Site content type at the site collection level. Created custom list on 2 sub sites and added the content type to the list. Added CQWP to the parent site. Here are the settings: Show items from all sites in this site collection (also tried show items from the following site and all sub sites), show items from custom list , and content type is the name I just created. What am I missing? it doesn't work for some reason. Again, thank you for your help –  Zankhana Patel Apr 8 '13 at 16:58
    
Do you have data in the fields associated with the content type? –  Dave Wise Apr 8 '13 at 17:06
    
Yes, I added 2 entries to each list I created. –  Zankhana Patel Apr 8 '13 at 17:13
    
Also, if you are using non-standard fields, you may have to map them to what the CQWP understands. When configuring the web part, look down under Presentation for a block titled Fields to display. That block lists the attributes that the current XML used in the transform can understand. You will need to map your custom field names there. –  Dave Wise Apr 8 '13 at 17:14
    
I don't see any block titled field under Presentation.. I give up on this. Just wasted too much time behind it and not getting anywhere.. thanks for your help though –  Zankhana Patel Apr 8 '13 at 17:42

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.