1 / 24

Intro to Content Query Web Part Power User – Level 200 Kim Frehe – Rightpoint Consulting

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.

kylar
Download Presentation

Intro to Content Query Web Part Power User – Level 200 Kim Frehe – Rightpoint Consulting

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Intro to Content Query Web PartPower User – Level 200Kim Frehe – Rightpoint Consulting

  2. 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:

  3. 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

  4. Agenda • About CQWP • Examples • Anatomy of a CQWP • Samples • Requirements & Recommendations • Tips & Tricks

  5. About the Content Query Web Part Information

  6. Site Collection

  7. CQWP

  8. 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

  9. Examples An Few Examples

  10. 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

  11. DEMO

  12. 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

  13. 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" />

  14. 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]”

  15. 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.

  16. 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/

  17. Thanks to Our Other Sponsors! Thanks to our Sponsors

  18. Special thanks to our organizers! Jim Bob Howard Matthew Lathrop

More Related