Content Query Web Part - Rightpoint by wangnianwu

VIEWS: 15 PAGES: 24

									           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.
• 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:
                   A User since
• SharePoint Power BOUT ME2001
• 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 CINFORMATION WEB PART
           ONTENT QUERY
SITE COLLECTION
CQWP
                    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
   FEW EXAMPLES
AN 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
DEMO
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]”
• For “Yes / No”TIPS & TRICKS by 1 or 0
                 checkbox: filter

• 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.
• Quick way to render NamesRICKS - 2007
                 TIPS & T of Fields
   <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/sharep
      oint-internal-field-names-sharepoint-2010/
              OTHER SPONSORS
THANKS TO OURour Sponsors !
  Thanks to
SPECIAL THANKS TO OUR ORGANIZERS!

  Jim Bob Howard   Matthew Lathrop

								
To top