Deep Dive into the Content Query Web Part

Christina Wheeler

Agenda• Introduction• Content Query Web Part– About the CQWP– How it’s being used– Tips & tricks– How to Customize

About me…

• Christina Wheeler• SharePoint Trainer & Consultant

• B: http://www.thesharepoint411.com

• E: cwheeler76@live.com

• L: http://www.linkedin.com/in/christinawheeler

• T: @cwheeler76

Publications

SharePoint 2010 Field Guidehttp://bit.ly/Xoxatd

SharePoint 2013 Inside Outhttp://oreil.ly/Wtk2UV

CQWP• Used to aggregate content from SharePoint

lists & libraries from within the current site collection

• Filter by content types• Add additional columns• Presentation styling• Audience Targeting

What’s new?• Dynamic Filters– SharePoint 2007• You had to subclass the CQWP to add dynamic filters

– SharePoint 2010• Filters based off other fields on the page• Or from a value on the QueryString

What’s new?• CommonViewFields– SharePoint 2007• Had to export web part. • Tweak the CommonViewFields property.• Reimport to page to pass additional content

fields down to the XSLT for rendering.– SharePoint 2010• Now exposed in the CQWP’s Editor part

Controlling the Presentation• Use existing Styles from the style gallery• Levels are set using the presentation section in

the tool pane• Create Custom XSL– Conditional Formatting– Key Performance Indicators– Calendar displays

Building the Query

Building the Query• PageFieldValue– Token allows to specify field on page layout and

dynamically replaces value of filter with current page’s field value

• PageQueryString– Use URL query string for a value to use in Query– Example

• Add Query String value to URL (&NewsCategory=Sports”) and set the CQWP’s query to return pages where the News Category field is equal to “Sports”

Building the Query

Building the Query• Supports filtering over the Enterprise

Keywords columns and the “All Tags” column– Allows to look for any

managed metadata tag on a queried item, regardless of which metadata field on the item contains the tag.

Building the Query

Building the Query

Resources• SharePoint 2010 CAML Designer– http://karinebosch.wordpress.com/2012/05/12/caml-design

er/

• Stramit CAML Viewer– http://spcamlviewer.codeplex.com

• Lightning Conductor Web Part– http://www.lightningtools.com

QUESTIONS?

Contact Info• Email

cwheeler76@live.com • Blog

http://www.thesharepoint411.com • Twitter

@cwheeler76 • LinkedIn

http://www.linkedin.com/in/christinawheeler