.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

Customizing the Content Query Web Part in SharePoint Server 2007

Posted By:      Posted Date: August 26, 2010    Points: 0   Category :SharePoint
Walk through how to customize the Content Query Web Part in SharePoint Server 2007 to query content across multiple sites in a site collection and display the results in any way that XSL can support. Learn how to get similar results when customizing the CQWP does not meet your needs.

View Complete Post

More Related Resource Links

Customizing Content Query Web Part (SP-2007)


Hi , i tried following to customize the CQWP as


connect the CQWP and configure according with my new "Template".

Add Column as 

<property name="CommonViewFields" type="string">Title, Text; Description, Note;</property>

 every thing is file but when i want to show this in another page again i have to do this again (Export and Import add "CommonViewFields".

 My Question is that is there any other method so that i don't have to add the "CommonViewFields" only have to change the XSL Template ....


Thanks and Regards Er.Pradipta Nayak

Content Query Web Part missing in SharePoint 2010

If you don't see content query web part listed in the web parts list, this is because you have not enabled "Search Server Web Parts" feature in site collection features. Enable this feature and content query web part will show in the list of web parts.

Real World Branding with SharePoint Server 2007 Publishing Sites, Part 1

Learn the essential concepts needed to create an engaging user interface design in SharePoint Server 2007 publishing sites.

Best Practices for Content Types in SharePoint Server 2007 and Windows SharePoint Services 3.0

Learn best practices to develop, deploy, and manage custom content types, as well as scenarios for making updates to existing content types in lists.

Issues after customizing Content Query Web Part


I have used CQWP in my SHarepoint 2010 application where i have done following steps..

1.Add CQWP

2.Provide query to use content

3.Exported the CQWP

4. Change the properties in .webpart file (itemXSL link, mainXSL link, XSL) to refer to my cutomized ContentQueryMain.XSL and ItemStyle. XSL, these 2 XSL's are stored in new folder in Style library

5.After the changes when i import the web part i am not able to open the properties when CQWP is applied in my UI (on clicking EditWebpart)

Kindly provide me some ideas so that i can resolve this problem..!!

Inconvenient SharePoint 2010 Content Query Web Part and Anonymous Access


Morning every one

I am hoping some one has found a work around regarding this.

I am using a JQuery random 'quote' generator (http://nextconnect.blogspot.com/2009/12/jquery-random-quote-viewer.html) in my site.I have enabled full anonymous access. My issue is that it still prompts you for the login in order to see the quote generator. I have tried the "ViewFormPagesLockDown" fix but it isn't even activated on my site. And now I am at a complete loss. I did some googling (Read 5 hours) and it seems that in Sharepoint 2010 doesn't have a work around for this and I am really hoping I am wrong.


Any ideas?


Have a great friday :)


Content Query Web Part Sharepoint 2010 AND Customize the data presentation


In fields to display you have a Title field. We will like to show two columns (Section Name and Status) in the title field, but only the fist one is displayed in the result.We use this syntax:

Column [Group];Column [Group]

When I use this formula

Section Name [Agresso R&D Base Columns] ; Status [Agresso R&D Base Columns ]

in the title field, the Section Name is displayed, and no Status, When I use this formula

Status [Agresso R&D Base Columns ]; Section Name [Agresso R&D Base Columns] ;

in the title field the Status field is displayed, and no section name. Is this a bug? or is it an other way to show both columns in the title field?


Fields to display Depending on the scope of your query, you can select one or more site or list columns whose values you want to show in the display slots for this style. To specify a column from a particular group, type the name of the group in square brackets after the column name, for example, Column [Group]. Be sure to separate each column you enter with a semi-colon.


SharePoint 2007-2010 content upgrade, Summary Links web part closed after upgrade.


Has anyone seen this before?

Did a DB content upgrade from SharePoint 2007 to 2010.  After the content upgrade (with only a warning saying that an unknown 3rd party web part was missing), we reviewed the new site, and found MANY pages which contained Summary Links web parts suddenly had many (but not ALL) of the Summary Links web parts now marked as closed.  At first we thought the parts were missing from the page, but when we edit the page we see the parts are in the Closed gallery.  We can add the part back in from the Closed gallery and all it's originally set properties are there.  Why are they coming up as Closed after the upgrade when they weren't Closed BEFORE the upgrade?

More details:

We have quite a few pages that contain one or more Summary Links web parts.  On SOME of the pages, one or more of these web parts are now Closed.  However, not ALL of the pages that contain these parts have the parts closed, and on the pages that now have these closed parts, not ALL of the Summary Links parts on that page are Closed, so it is not a problem with an unregistered Summary Links web part as the part is working on the same and other pages (I found other people on the web mentioning issues where NONE of their Summary Links parts are working after an upgrade.)  So, it seems to be somewhat random as to which instance

display sharepoint list Data into content Query Web Part


Hi i have content query web part. now i want to show the sharepoint list data into my content query part

using CQWP setting, i am able to get only one column data but not all.

pls let me know how can i get all list data in different style format 

sharepoint List data not showing in content query web part


hi friends,

i am displaying data from sharepoint list into content query web part.

i have also mentioned column name in commonfield properties after exporting web part and save it.

but it is showing only two column name.

i have also inserted images url in sharepoint list, but i am not able to see images in CQWP.


<xsl:template name="News" match="Row[@Style='News']" mode="itemstyle">
  <xsl:param name="CurPos" />
  <xsl:param name="LastRow" />
  <xsl:variable name="SafeLinkUrl">
    <xsl:call-template name="OuterTemplate.GetSafeLink">
      <xsl:with-param name="images" select="'@images'"/>
  <xsl:variable name="SafeImageUrl">
    <xsl:call-template name="OuterTemplate.GetSafeStaticUrl">
      <xsl:with-param name="images" select="'@images'"/>

Content Query web part does not render on one of the front end server


I have 2 front end servers, and always develop by pointing SharePoint Designer to server one. When I try to browse the pages on server 2, I find that none of the content query web parts render. Instead they show the following message.

Unable to display this Web Part. To troubleshoot the problem, open this Web page in a Microsoft SharePoint Foundation-compatible HTML editor such as Microsoft SharePoint Designer. If the problem persists, contact your Web server administrator.

When I open the page in designer, it says that I can edit only the page layout and not the actual page.
Any suggestions on resolving this error message?

Configuring SharePoint Server 2010 Search for External Content Types, Part 2

Learn how defining external content types reduces crawl times for large amounts of data by using incremental crawls.

Configuring SharePoint Server 2010 Search for External Content Types, Part 1

Learn how to use SharePoint Designer 2010 to define external content types and to set up a SharePoint Server search crawl that includes that external data.

SOAP Error 500 when query in Sql Server 2008 using for reporting a Sharepoint list 2007


I'm doing the reporting services for a SharePoint list, the datasource is configured as a connection with http://<Servername>/_vti_bin/lists.asmx and I add the parameters listName , rowLimit and viewName with the

SharePoint 2007 - Consolidating everything as feature into WSP [Content Type, Page Layout, Pages, Ma


Hello –


Overview – We are building a Mobile Web Site using SharePoint 2007. The big screen site has been already built and we need to integrate the mobile site into same site collection of big screen –


·         The Mobile site will use the existing content types of existing big screen site

·         We will build a new custom Master page

Deploying custom Web Parts on SharePoint 2007 production server

I would like to develop a custom SharePoint 2007 Web Part for a client. Currently I'm using Visual Studio to deploy my solution to a test environment (since it's a SharePoint Project I choose just Build -> Deploy from the menu). What are the appropriate steps to deploy it to the production server?

I'd like keep it simple and safe (i.e. use the principle of least privilege). Therefore (if possible) avoid using stsadm, achieve this through web interface, or avoid using administrative rights.

Also, can I specify the scope of my Web Part, i.e. choose on which Web Application or Site Collection will it be installed?
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend