Content Query Web Part (CQWP) and Discussions Lists

There was a question recently in our group about how to filter a discussion so that it doesn’t have the “(blank)” replies to discussions in the CQWP results. It isn’t obvious how to do this in SP 2010, and filtering in the area below doesn’t allow for filtering of content types. 

Turns out, that the Discussion content type is actually of the FOLDER type.  Configure the CQWP like this:

CQWP 

This will get you discussions only, and the (blank) entries of the replies will disappear.  Then the question turned to “I can’t filter on my column that I created in the list. Yep, that’s true, you can’t, nor can you in any CQWP.  The column has to be a site column, and added to the content type you are using.  I tried inheriting the content type from the “Discussion” folder content type, creating my own, and adding the column.  The result was that you can do this, it works great in the CQWP, but breaks everything in the Discussion, lol.  The only alternative is to add the site column to the Discussion content type directly, which isn’t really recommended, but the only way to get this to happen without XSLT or other coding methods. 

Leave a Reply

x

We use cookies to ensure the best possible experience on our website. Detailed information on the use of cookies on this site is provided in our Privacy and Cookie Policy. Further instruction on how to disable our cookies can be found there.