240 likes | 306 Views
Intro to Content Query Web Part Power User – Level 200 Kim Frehe – Rightpoint Consulting. Thank you for being a part of the first SharePoint Saturday Austin. Please turn off all electronic devices or set them to vibrate.
E N D
Intro to Content Query Web PartPower User – Level 200Kim Frehe – Rightpoint Consulting
Thank you for being a part of the first SharePoint Saturday Austin • Please turn off all electronic devices or set them to vibrate. • If you must take a phone call, please do so in the hall so as not to disturb others. • Open wireless access is available with no password • Feel free to “tweet and blog” during the session • Thanks to our Title Sponsors:
About Me • SharePoint Power User since 2001 • Graduated with BS in Advertising from University of Florida • Huge Gator Fan • Chicago • Dog Lover and SharePoint Geek • Consultant at • Twitter @chomp1313
Agenda • About CQWP • Examples • Anatomy of a CQWP • Samples • Requirements & Recommendations • Tips & Tricks
About the Content Query Web Part Information
Usage • Announcements / News Rollups • Administrative Dashboard • Calendar Rollups • Recurring calendar items are an issue • Contracts / RFP’s • Employees / Contacts • Client Profiles • All contacts, contracts, RFP’s, announcements, etc related to one client or project • User fields – how are they using
Examples An Few Examples
Anatomy of CQWP • Display information from all sites in site collection, • One “parent” with children or just one site • Can display based on list just one list
Requirements & Recommendations • Publishing Feature must be turned on • Access Level: Must have design access to add web parts to a page • Set up Content Types at the Parent Site or Content Type Hub
Tips & Tricks • Format Date: At the top: xmlns:ddwrt=http://schemas.microsoft.com/WebParts/v2/DataView/runtime In the Template: <xsl:value-of select="ddwrt:FormatDate(@DueDate, 1033, 1)"/> • Show Rich Text: disable-output-escaping="yes" • <xsl:value-of select="@Description“ disable-output-escaping="yes" />
Tips & Tricks Tips & Tricks • Create custom slot: <div class=“item”> <xsl:value-of select=“@fieldname”/> </div> • If “Due Date” does not work, try “Due Date [Core Task and Issue Columns]”
Tips & Tricks • For “Yes / No” checkbox: filter by 1 or 0 • Discussion Replies: use “ItemChildCount” • <property name="CommonViewFields" type="string">ItemChildCount,Lookup</property> • Expiration date: _dlc.ExpireDate • Managed Metatdata: CQWP allows single and multiple values for filter, but not grouping.
Tips & Tricks • Quick way to render Names of Fields - 2007 <xsl: for-each select=“@*”> <xsl: value-of select = “name( )”/> </xsl: for-each> • Add it to the code above “Display Title” variable to see a list of fields being passed to the web part • Show additional fields- 2007 “CommonViewFields” <property name="CommonViewFields" type="string">Body_x0020_content, RichHTML</property> Internal names: http://sharepointmalarkey.wordpress.com/2010/10/12/sharepoint-internal-field-names-sharepoint-2010/
Thanks to Our Other Sponsors! Thanks to our Sponsors
Special thanks to our organizers! Jim Bob Howard Matthew Lathrop