Configuring and Customizing the Content Query Web Part

re: Configuring and Customizing the Content Query Web Part

Michael Gannotti — Thu, 26 Oct 2006 06:17:16 GMT

I was just getting set to write this up for a client. You are lifesavers! Thanks!!!!!

Michael

http://www.mikeysgblog.com

re: Configuring and Customizing the Content Query Web Part

MarcusJT — Thu, 26 Oct 2006 12:36:17 GMT

Great article, but I have a few queries:

1) How does one know that the body field needs to be referenced as "Body_x0020_content" in the .webpart file (as opposed to "Body_x0000_content", for example)? How would one find the required reference for another metadata field? Additionally, this field name appears to be composed of three parts - can any one of these be altered individually to achieve some other result, or do all three relate directly to each other and should only be considered as one?

2) In the XSLT "Body_x0020_content" becomes "Body_x005F_x0020_content" - where did the "x005F" part come from, what does it represent, and what is its effect?

Thanks! :)

re: Configuring and Customizing the Content Query Web Part

IanS555 — Thu, 26 Oct 2006 12:45:19 GMT

I'm just as confused as you Marcus, the hex value seems to be plucked from the air. How do I know the x005F bit is the description? How do I find out what other objects in this are named/hex valued???

Nice concept, but seriously lacking in any explainations as to how this actually works and how it can be utilized elsewhere.

Ian

re: Configuring and Customizing the Content Query Web Part

George Perantatos — Thu, 26 Oct 2006 20:25:53 GMT

Hi Marcus, to answer your questions:

1) When you tell the Content Query web part to ask for a set of fields, via CommonViewFields as above, you need to use the internal name of the fields. SharePoint's UI shows you the display name of the fields, but stores the internal name in the DB. Usually the internal name and the display name match, but certain characters (like spaces) are encoded.

An easy way to sneak a peek at what the internal name of a field is: when you visit the Site Column page for a particular column, the URL displays the internal name of the field. In this case it's "field=Body%5Fx0020%5Fcontent", which is just an encoded way of saying "Body_x0020_content".

2) This is one of the quirks of XML/XSL, namely certain characters getting encoded differently when getting passed as XML to the XSL to render. One easy way to see exactly what the XML looks like that the XSL has to render is to insert the markup I have in the example above into your Item Style, and that will render out the field names:

<xsl:for-each select="@*">

P:<xsl:value-of select="name()" />

</xsl:for-each>

This will yield all the fields you can render by their name, including in this case "Body_x005F_x0020_content".

Ian, if you have questions about how you can utilize the web part for your scenarios, feel free to post a comment describing what you're trying to do, and I can give you some pointers.

re: Configuring and Customizing the Content Query Web Part

Ian Morrish — Thu, 26 Oct 2006 22:09:16 GMT

To get the field names, I create a simple web part page and use the Data View web part to render the information from the _vti_bin/lists.asmx web service.

Example http://www.wssdemo.com/Pages/Lists.aspx

Configuring and customizing the Content Query Web Part

SharePointKicks.com — Wed, 01 Nov 2006 04:03:10 GMT

You've been kicked (a good thing) - Trackback from SharePointKicks.com

re: Configuring and Customizing the Content Query Web Part

Bisbjerg — Sat, 04 Nov 2006 12:12:57 GMT

Hi George,

This is a great post, and just what I needed. Now I've been able to add a group style for a links list, thus enabling targeting of single links in a list. It only required that I added URL to CommonViewFields.

A small question. It´s quite easy to add a Content by Query WP to a site definition. Just set up an existing CQWP, export the XML and copy/paste to onet.xml. But the last piece of the puzzle in provisioning a page with the CQWP, to point to a specific list is not so obvious. It seems that the CQWP does not understand current page (.) / parent page (..) notations. I cannot set up CQWP with a links list name and a weburl, say the relative address of the page, e.g. "/./Linkslist". In practice this means, that after provisioning a page with CQWP, you'd have to manually set up the webpart to point to the proper list. Do you know if there is a way to do this?

Kind regards,

Lasse

re: Configuring and Customizing the Content Query Web Part

Joost — Mon, 06 Nov 2006 14:12:29 GMT

i was wondering how you can set up this content query webpart using images. On the pages i want to display i have an image control. When i set the query on image on left i don't see any image. How come?

First i had only a rich text editor control on my page which can't display an image. So i changed this to an image control. But it's still isn't there.

I hope you can help me

re: Configuring and Customizing the Content Query Web Part

George — Mon, 06 Nov 2006 21:12:22 GMT

Hi Joost, out of the box, the Content Query Web Part requests the "Rollup Image" field as part of its queries, and displays it as the image in the out-of-box styles that display images, such as "image on left".

You can see this in action with a default site by creating an Article page. There, using the out-of-box page layouts, you should see a Rollup Image field control when you edit the page. Specifying this image will cause the image to appear in the Content Query web part.

If you want a different image to appear, I would recommend you use the CommonViewFields property to request the field, and then the DataColumnRenames property to map it to the Rollup Image that the XSLT renders. That way, the web part requests your custom image field, but then changes the name of it to match what the XSLT expects to render.

You can avoid the DataColumnRenames step if you're willing to modify your XSLT to render out your custom field by name. However, that effectively "hardcodes" your XSLT to a particular field name. The DataColumnRenames property helps keep your XSLT styles somewhat agnostic of the underlying fields that it is rendering.

re: Configuring and Customizing the Content Query Web Part

Mindy Kelly — Tue, 07 Nov 2006 01:53:57 GMT

Do you have any idea why the Content Query web part would not be available for me to add to a site? Running TR...

Thanks,

Mindy Kelly

re: Configuring and Customizing the Content Query Web Part

George — Tue, 07 Nov 2006 02:17:00 GMT

Hi Bisbjerg,

If you're trying to setup the CQWP to point to one and only one list/library or sub-site, that should be possible through specifying properties via the onet. However, there's not a great way to expand a "relative" path, including . and .., to a server-relative path to a list, library, or site, when the part is added to a page.

I'm assuming you're trying to configure the CQWP such that when the user adds it to a page, it points to the "right" list or library that lives somewhere in the site (say, a site-local document library).

One option, as you describe, is to have someone customize the part after it'd added to the page. Another option is to have a bit of code that, when the part is added to the page, goes in and sets the property to the correct server-relative path to the list/library that makes sense.

re: Configuring and Customizing the Content Query Web Part

George — Tue, 07 Nov 2006 02:18:01 GMT

Hi Mindy, what site template did you use to create your site? The CQWP is only available in sites that have the Publishing feature enabled. If you started with a team site, that feature is disabled. Sites like Publishing Site have it enabled. You can enable it via Site Settings -> Site Features.

Building tylerbutler.com, Part 2: Building Content Types and Page Layouts

Enterprise Content Management (ECM) Team Blog — Tue, 07 Nov 2006 05:34:24 GMT

Part 1 :: Part 2 This is part 2 of an ongoing series of posts about my experience building a custom site

re: Configuring and Customizing the Content Query Web Part

dino — Tue, 07 Nov 2006 13:52:45 GMT

Hi,

re: Configuring and Customizing the Content Query Web Part

Heather Solomon — Sat, 18 Nov 2006 02:00:58 GMT

Great post! I am running into one issue though... I am trying to use this method for the News site... display latest news on home page from the News section. I can get description, titles, IDs, etc all to show in the style, but not body. When I include body it renders nothing... no errors, just no content. Any ideas?

re: Configuring and Customizing the Content Query Web Part

George — Sat, 18 Nov 2006 04:01:25 GMT

Hi Heather, can you tell us how you're configuring the web part to show Body?

re: Configuring and Customizing the Content Query Web Part

Heather Solomon — Mon, 20 Nov 2006 05:04:47 GMT

Here is my custom template in ItemStyles.xsl:

<xsl:template name="S2Style" match="Row[@Style='S2Style']" mode="itemstyle">

<xsl:for-each select="@*">

P:<xsl:value-of select="name()" />

</xsl:for-each>

<xsl:variable name="SafeImageUrl">

<xsl:call-template name="OuterTemplate.GetSafeStaticUrl">

<xsl:with-param name="UrlColumnName" select="'ImageUrl'"/>

</xsl:call-template>

</xsl:variable>

<xsl:variable name="SafeLinkUrl">

<xsl:call-template name="OuterTemplate.GetSafeLink">

<xsl:with-param name="UrlColumnName" select="'LinkUrl'"/>

</xsl:call-template>

</xsl:variable>

<xsl:variable name="DisplayTitle">

<xsl:call-template name="OuterTemplate.GetTitle">

<xsl:with-param name="Title" select="@Title"/>

<xsl:with-param name="UrlColumnName" select="'LinkUrl'"/>

</xsl:call-template>

</xsl:variable>

<xsl:variable name="LinkTarget">

<xsl:if test="@OpenInNewWindow = 'True'" >_blank</xsl:if>

</xsl:variable>

<xsl:if test="string-length($SafeImageUrl) != 0">

</a>

</div>

</xsl:if>

<xsl:call-template name="OuterTemplate.CallPresenceStatusIconTemplate"/>

<xsl:value-of select="$DisplayTitle"/>

</a>

<xsl:value-of select="@Body_x005F_x0020_content" />

</div>

</xsl:template>

I stopped mid way through step 4 since I couldn't get body to show. I followed the previous steps to a tee. The Content Query Web Part is querying /News.

re: Configuring and Customizing the Content Query Web Part

ecmblog — Tue, 21 Nov 2006 00:29:57 GMT

Hi Heather, what happens if you remove the following lines from your XSLT template?

<xsl:for-each select="@*">

P:<xsl:value-of select="name()" />

</xsl:for-each>

re: Configuring and Customizing the Content Query Web Part

Heather Solomon — Tue, 21 Nov 2006 00:54:33 GMT

The resulting display only shows the News title.

re: Configuring and Customizing the Content Query Web Part

ecmblog — Tue, 21 Nov 2006 22:54:16 GMT

Hi Heather, things to check:

- Are you sure the web part is using the style above (S2Style)?

- Is the web part you're referring to asking for the Body content field? Can you confirm by exporting the web part and checking the CommonViewFields property?

- Did you confirm that the field is indeed coming back in the web part, with my value-of select="name()" trick above?

- Does the body content field of the page in question contain any content?

re: Configuring and Customizing the Content Query Web Part

Heather Solomon — Wed, 22 Nov 2006 01:44:21 GMT

Yes, I confirmed all of those potential issues.

One thought, do the various content types have different field names for common content? For Step 3, I used your example (<property name="CommonViewFields" type="string">Body_x0020_content, RichHTML</property>). Does News use a different field for the Body? Could the problem be that I am just not calling anything that exists for News (my News is the default News site that uses the Article Page content type)?

If so, how do you go about pulling fields for any given source where you are aggregating content in the CQW?

re: Configuring and Customizing the Content Query Web Part

ecmblog — Wed, 22 Nov 2006 03:52:06 GMT

Ah, that must be it. I _added_ a "Body content" field to my Product Page content type above. This field does not exist out of box.

For your case, if you're using the out of box article page content type, you can ask for something like "Page content" or the like to come back instead (the exact name of the column escapes me currently, but you can inspect the Article Page content type to see them all).

re: Configuring and Customizing the Content Query Web Part

Donna Sullivan — Wed, 22 Nov 2006 19:11:06 GMT

OK, there has to be a trick to this filters thing. I added a custom field to my content type and, for some reason, it does not appear in the filter's drop down. Why? Does anyone know why? Is there a trick?

donna.sullivan@rotary.org

re: Configuring and Customizing the Content Query Web Part

ecmblog — Wed, 22 Nov 2006 22:47:54 GMT

Hi Donna, what type of field did you add to your content type?

re: Configuring and Customizing the Content Query Web Part

Joost Schermers — Tue, 28 Nov 2006 11:26:02 GMT

Hi George,

I'm facing the same difficulty here as Heather. I want the pages from the Press Release to be displayed on my homepage in the CQWP using xslt. But nothing i try does affect the display. All i see is the title. For the pages i use the default article pages templates.

First i customized the CQWP like below:

<property name="CommonViewFields" type="string">Page_x0020_content, RichHTML</property>

As you can see i have changed Body_x0020_content to Page_x0020_content. (btw i have also tried changing RichHTML to Publishing html (while thats the column type)

Then i customized the ItemStyle as follows:

<xsl:template name="Default" match="*" mode="itemstyle">

<xsl:variable name="SafeLinkUrl">

<xsl:call-template name="OuterTemplate.GetSafeLink">

xsl:with-param name="UrlColumnName" select="'LinkUrl'"/>

</xsl:call-template>

</xsl:variable>

<xsl:variable name="SafeImageUrl">

<xsl:call-template name="OuterTemplate.GetSafeStaticUrl">

<xsl:with-param name="UrlColumnName"

select="'ImageUrl'"/>

</xsl:call-template>

</xsl:variable>

<xsl:variable name="DisplayTitle">

<xsl:call-template name="OuterTemplate.GetTitle">

<xsl:with-param name="Title" select="@Title"/>

<xsl:with-param name="UrlColumnName"

select="'LinkUrl'"/>

</xsl:call-template>

</xsl:variable>

<xsl:variable name="LinkTarget">

<xsl:if test="@OpenInNewWindow = 'True'" >_blank</xsl:if>

</xsl:variable>

<xsl:if test="string-length($SafeImageUrl) != 0">

<a href="{$SafeLinkUrl}" mce_href="{$SafeLinkUrl}"

target="{$LinkTarget}">

<img class="image" src="{$SafeImageUrl}"

mce_src="{$SafeImageUrl}" alt="{@ImageUrlAltText}" />

</a>

</div>

</xsl:if>

<xsl:call-template name="OuterTemplate.CallPresenceStatusIconTemplate"/>

<xsl:value-of select="$DisplayTitle"/>

</a>

<xsl:value-of select="@Page_x005F_x0020_content" />

</div>

</xsl:template>

I know it's a bit of a mess due to copy - paste. But i think you know where to look.

I really hope you can help me! I have also asked Heather if might know a solution

many tnx, Joost

re: Configuring and Customizing the Content Query Web Part

Anabhra — Wed, 29 Nov 2006 18:04:00 GMT

Is it possible for the CQWP to query pages based on data in a field control?

What I am trying to do is generate a related content section for my articles page. In the editpanel, the author will enter keywords for the article.

Now the CQWP should read the keywords and execute the query on other pages that have these keywords too? Kinda like tags...

So I define the site, the Content Type, Field Control and Filter and then I want the filter value to be picked up run time based on the page that this web part is sited on.

Any ideas how to do this?

thanks,

anabhra

Customizing the Content Query Web Part and Custom Item Styles

Heather Solomon - MVP, WSS - Blog about Design, MCMS, SharePoint, and CSS — Wed, 29 Nov 2006 20:34:23 GMT

re: Configuring and Customizing the Content Query Web Part

ecmblog — Wed, 29 Nov 2006 21:44:17 GMT

Hi Anabhra, if I understand your scenario, you want to have the web part query for other pages that are tagged with keywords that match the current page, and you want this to dynamically change based on what the current page tags are.

If so, I'd recommend you write some code (say, as a control) that lives on the page, inspects the page's tag, and then sets the Content Query web part to filter on that tag.

For example, if the current page's topic is "Hiking", your control can read that, and then programmatically set the CQWP's filter to be Topic is equal to Hiking. This would be done during the page lifecycle. You could put this control on certain page layout to ensure it runs on the right pages (e.g. article pages).

Hope this helps,

--George

re: Configuring and Customizing the Content Query Web Part

ecmblog — Wed, 29 Nov 2006 22:20:14 GMT

Hi Joost, looks like internal names got you :) Go to Site Settings -> Site Content Types -> Article Page, and then click on "Page Content". That's the display name, but that's not the internal name.

One way to find the internal name is to check the query string parameter on the field page.

For this out of box field, the internal name is PublishingPageContent. Try replacing your instances of Page Content above (in both common view fields and the xslt) with this and see if it works.

For fields that you create, the internal name will be more predictable. Very likely, it will match the display name, and will have characters like spaces encoded.

Hope this helps,

--George

re: Configuring and Customizing the Content Query Web Part

Heather Solomon — Thu, 30 Nov 2006 03:53:51 GMT

Thanks for all of the support! I got my customized Item Style up and working, thanks to you guys.

I have put together an article covering the stuff I learned in the process and basically embellished on some things from this post: http://www.heathersolomon.com/blog/articles/customitemstyle.aspx

re: Configuring and Customizing the Content Query Web Part

ecmblog — Thu, 30 Nov 2006 04:16:14 GMT

Good to hear - and great post!

--George

re: Configuring and Customizing the Content Query Web Part

Liam Cleary — Thu, 30 Nov 2006 19:58:19 GMT

Excellent Post!! Good indepth sample.

Thanks

Liam

re: Configuring and Customizing the Content Query Web Part

Anabhra — Thu, 30 Nov 2006 20:32:43 GMT

George,

Thanks for the response. You understand my problem perfectly.

However, one thing that I am struggling with is that since we do all configuration with the sharepoint designer now (page layouts reside in the database and do not allow me to do any code

behind), how do I associate or hook into the page life cycle events. Ie; if I build a web part that reads the field control value and then sets the CQWP filter attribute, how do I know that the CQWP will execute the search after I set the attribute?

Also, which in which life cycle event of the web part will I be able to read the field control value and set the CQWP filter?

many thanks,

anabhra

re: Configuring and Customizing the Content Query Web Part

Joost — Sat, 02 Dec 2006 20:31:41 GMT

Hi George,

Tnx for the help. It works like a charm now. Tnx to you and Heather. Thumbs up

Many tnx, Joost

re: Configuring and Customizing the Content Query Web Part

George Karkalis — Tue, 05 Dec 2006 01:51:43 GMT

Really usefull...

Have you tried to also use your own CAML query to have advanced control over the returned data?

I have tried to do this using the QueryOverride property in order to create a list of the current user's tasks including the tasks assigned to a group of the current user, because the "User Tasks" web part does not return these tasks.

I couldn't make it to work correctly. It shows the tasks on "Edit Page" mode but not in normal mode... Really dissapointing and I couldn't find anyone talking about the QueryOverride property...

thanks anyway...

re: Configuring and Customizing the Content Query Web Part

Jason Becker — Wed, 06 Dec 2006 19:19:58 GMT

Does anyone know how to grab the Content Query Web Part's properties rather than those of the source data?

I seek to control the output appearance more closely by retrieving the web part's default "ItemLimit" and "DisplayColumns" properties as well as custom properties which the web designer can modify. Adding, for example, attributes to be appended to the MORE link's URL (IE: http://mysite?FilterBy=Forms). For my purposes each web part would need unique values for this argument.

Any suggestions?

Customização da Content Query Web Part

André Vala — Sat, 09 Dec 2006 02:46:02 GMT

Uma das web parts mais flexíveis fornecidas pelo SharePoint 2007 é a Content Query Web Part . Alguns

re: Configuring and Customizing the Content Query Web Part

Ana — Tue, 09 Jan 2007 18:09:25 GMT

Hi,

Could you help me, please?

The Pages Library option isn't showed in field List Type. I have a News Site.

Sincerely,

Ana.

MOSS2007 – Content Query Web Part Step by Step Basic Styling

hello its liam (trainbloggin) — Tue, 16 Jan 2007 00:24:03 GMT

Well I am currently working on a project that has a great need to use the Content Query Web Part for...

re: Configuring and Customizing the Content Query Web Part

ecmblog — Fri, 19 Jan 2007 01:51:44 GMT

Hi Jason, a web part in the end is very similar to a server control. You can write another control that looks at the control tree, finds the CQWP, and examines its properties, for example. For your example, you can imagine a control reading the qs parameter and changing the CQWP parameters to filter on the fly.

re: Configuring and Customizing the Content Query Web Part

Jason Chan — Mon, 29 Jan 2007 11:45:30 GMT

Does this webpart only available in MOSS2007? How about WSS3?

re: Configuring and Customizing the Content Query Web Part

briand — Thu, 01 Feb 2007 17:19:54 GMT

I have the CQWP running a the top-level team site and it is successfully crawling the discussion boards in the sub-sites. The only problem is that when I click on the discussion within the web part I am directed to an /_layouts page(therefore failing) rather than the site directory/*site*/lists/.....?

Any suggestions on ensuring the links point the the right location?

re: Configuring and Customizing the Content Query Web Part

Richard Calderon — Thu, 08 Feb 2007 18:54:08 GMT

Great article. However, instead of using the removeMarkup() function to disable escaping, try:

<xsl:value-of select="@Body_x005F_x0020_content" disable-output-escaping="yes"/>

Works like a charm....

re: Configuring and Customizing the Content Query Web Part

ecmblog — Wed, 14 Feb 2007 21:26:45 GMT

Hi Richard, while that function does work, a potential unintended consequence is that, by disabling output escaping, you "run" any of the markup in the Body content field. That's fine for things like <div> and <span>, but what about <script>?

It's true that SharePoint strips out script before it goes into HTML fields. However, one can configure a Content Query web part to map a field with script in it to a field that the web part doesn't output escape (like Body content in your example above). The result would be that someone with rights to update that field and put script in it could run the script on your site.

The out of box Content Query web part and the XSLTs provide safeguards for this, by checking the source field type and making sure that you don't map it to something that disables output escaping. But that's for our out of box XSLT styles. If you do the above, you have to ensure that consumers of your web part don't try to sneak in markup that shouldn't be there.

re: Configuring and Customizing the Content Query Web Part

ecmblog — Wed, 14 Feb 2007 21:27:20 GMT

Hi Jason, the Content Query web part is available in MOSS. WSS does provide the underlying cross-site query (SPSiteDataQuery) if you want to use it directly.

re: Configuring and Customizing the Content Query Web Part

ecmblog — Wed, 14 Feb 2007 21:28:40 GMT

briand, can you give me an example of the URL that's failing, when you click on a discussion board item?

re: Configuring and Customizing the Content Query Web Part

Vintage — Sat, 17 Feb 2007 22:19:38 GMT

Hi George, great post!

I saw on one picture that your Additional Filters you had a custom field, "Product Line".

I am dying to know how to add the custom columns I create for a Document Library to the Content Query filters like you did with "Product Line".

Could you point me in the right directions, please?

Thanks a lot! :)

re: Configuring and Customizing the Content Query Web Part

Marc — Mon, 19 Feb 2007 16:20:35 GMT

Great article!

re: Configuring and Customizing the Content Query Web Part

Marc — Mon, 19 Feb 2007 17:55:18 GMT

You should use

disable-output-escaping="yes"

instead of your own tag filter. It will render the html! still a great post though!

re: Configuring and Customizing the Content Query Web Part

ecmblog — Wed, 21 Feb 2007 20:53:46 GMT

Hey Vintage, the Content Query web part will enumerate custom site columns that you have added, letting you filter on them. Note that if you choose to filter on a content type, we will only enumerate site columns from that content type.

Are you having trouble seeing your custom column appear in the CQWP?

re: Configuring and Customizing the Content Query Web Part

Robert — Fri, 23 Feb 2007 19:59:29 GMT

This is a great article and will save a lot of time for alot of people. One question: Is there a reason the CQWP limits the additional filters to three filters? Suppose I have a content type with many columns and I'd like to filter on more than three columns. The behavior I would like would be something similar to creating a view in the document library. Any recommendations or guidance on how to filter the CQWP on more than three filters would be very helpful.

re: Configuring and Customizing the Content Query Web Part

Karthik — Wed, 28 Feb 2007 10:29:17 GMT

Hey Robert, you can configure the CQWP to use more than three filters by modifying the "QueryOverride" property to use your custom CAML query for filtering. The CAML query can have any number of filter fields and values

re: Configuring and Customizing the Content Query Web Part

Karthik — Wed, 28 Feb 2007 10:39:29 GMT

I have configured the CQWP to use a custom style ( modified the ItemStyle.xsl file ). Would it be possible to set the XSL of the web part at run time. The behavior I would like to see, would allow the administrator to configure the web part by entering the XSL code at run time, in a text area in the tool pane. Is this possible?

re: Configuring and Customizing the Content Query Web Part

Vintage — Wed, 28 Feb 2007 18:23:47 GMT

Hi!

Thanks for your answer, but I've managed to find out how to add the custom columns to the CQWP using the AdditionalFiltersField!

Thank you for sharing all this information with us!

Take care!

re: Configuring and Customizing the Content Query Web Part

alex — Fri, 02 Mar 2007 22:43:31 GMT

Hey George,

I have to customise the cqwp. I have the following queries:

1. Is it possible to populate the content query web part from database( sql server 2005.....if the content data resides in sql server database). ?? if it is possible, Do u have any examples for this ??

What are the possible sources from which i can populate the content query web part ??

2. I have a cqwp in which I am displaying the news items related to a category (ex: Tax). I want to display the news for the previous week on the click of a link button << on my web part? How can I do this? do u have any examples ?? any help would be highly appreciated.

Thanks

alex

re: Configuring and Customizing the Content Query Web Part

mkelly — Tue, 06 Mar 2007 01:45:57 GMT

Hi Ian,

I think what you did here is terrific! http://www.wssdemo.com/Pages/Lists.aspx

But I'm a beginner and don't understand at all how you set this up, would you be willing to elaborate?

Thanks,

Mindy

re: Configuring and Customizing the Content Query Web Part

Alex — Wed, 07 Mar 2007 01:05:10 GMT

Geaorge,

Great Link!! I have made a content query web part comprising of news items filtered on news category. In the CQWP I am able to display the news items for the current month using filters.

I have the following requirement- I need to add a button called previous << on click of which it should fetch me the news items for the previous month.

Can you help me out how do I achive this? Ny code u have sample?

Any help would be highly appreciated !!!!

re: Configuring and Customizing the Content Query Web Part

Adam — Wed, 07 Mar 2007 09:34:51 GMT

Hi George, thanks for a great article!

QuestionL: how can I pass the listname to the CQWP XSL stylesheet?

For example I want to add a View All button at the bottom of the rendered content that links to the /listname/AllItems.aspx page, but I can't find a way to pass or query the listname.

At present I've got it working by grabbing the first row returned and stripping out the string but that does not work when 0 rows are returned....The listID is passed but not the listname.

Thanks!

re: Configuring and Customizing the Content Query Web Part

Somesh — Fri, 09 Mar 2007 17:14:48 GMT

I am trying to use the CQWP to query on two lists residing on two different subsites. Now while configuring the query part of CQWP i have three options to set as source.I cannot use either "Show item from following list" or "Show item from the following site" since the lista lie in two different subsites. So i set the source as "Show items from all sites".Further i have

List Type = Custom List

Content Type Group = List Content Types

Content Type = Items.

However on doing this i am getting a large number of items from lists other than the above two lists which is not acceptable for me.

How do i configure the CQWP to show items from just the two Lists.

Can i somehow mention the GUID's for the list in order to restrict my query to just the two specified lists?

re: Configuring and Customizing the Content Query Web Part

Pablo — Thu, 15 Mar 2007 17:44:24 GMT

Hi, I'm trying the same as Robert: use more than 3 filters.

I'm doing like that:

protected override void OnInit(EventArgs e)

{

base.OnInit(e);

this.QueryOverride = @"<Where><Eq><FieldRef Name=""isFull"" /><Value Type=""Boolean"">0</Value></Eq></Where>";

}

What could be wrong? It doesn't filter anything. Thanks!

re: Configuring and Customizing the Content Query Web Part

MikeD — Thu, 15 Mar 2007 20:38:04 GMT

Hello

I would like to add small image to entries which emphasize new articles. e.g. Like the "new"-image in list for new list entries.

Is this possible with the cqwp and xsl?

Thanks

Mike

re: Configuring and Customizing the Content Query Web Part

Jeremy W — Fri, 16 Mar 2007 05:22:24 GMT

I am trying to schedule announcements for display on the front page using a CQWP. I can get it to work using QueryOverride and <Today/>, but I want to specify specific times, too. Can this be done? I tried using <Now/> to no avail. Please help!

Sample:

<Where>

<And>

<Leq>

</Leq>

<Geq>

</Geq>

</And>

</Where>

~Jeremy

re: Configuring and Customizing the Content Query Web Part

ArtiK — Mon, 19 Mar 2007 06:49:49 GMT

Hi, seems some of you have got the QueryOverride property working. I am trying to use the property to retrieve documents from one of the document library using a simple CAML query as below,

<Query>

<Where>

<Eq>

</Eq>

</Where>

</Query>

However, I get the error "There is a problem with the query that this Web Part is issuing. Check the configuration of this Web Part and try again.". Tried changing some configurations but the error persists.

I have also set values in the DataColumnRenames and CommonViewFields properties. Would that affect in anyway?

Is there anything else that needs to be configured? I have tested the query successfully using the U2U CAML Query builder.

Any help or advice is greatly appreaciated. Thanks!

re: Configuring and Customizing the Content Query Web Part

ecmblog — Mon, 19 Mar 2007 20:18:30 GMT

Hi ArtiK, chances are you have some malformed XML, or you have some additional spaces somewhere in the markup, or you have an invalid CAML query.

Have you tried some of the examples from here?: http://msdn2.microsoft.com/en-us/library/aa981241.aspx

re: Configuring and Customizing the Content Query Web Part

ecmblog — Mon, 19 Mar 2007 20:21:06 GMT

Hi MikeD, it depends on what your logic is. One approach would be to get the created date for each item in the CQWP result set, and then do some conditional logic in the XSLT that compares that with today's date and renders the "New" if it's within some set window of time.

Provided you have the items' created date and today's date in hand by the time the XSL is running, you should be able to do this.

re: Configuring and Customizing the Content Query Web Part

ecmblog — Mon, 19 Mar 2007 20:39:29 GMT

Hi Pablo, do you get the same effect if you specify the QueryOverride property in the .webpart XML, instead of programmatically?

re: Configuring and Customizing the Content Query Web Part

ecmblog — Mon, 19 Mar 2007 20:48:07 GMT

Hi Somesh, you can configure the web part's ListsOverride property to pull from specific lists, based on list ID. You can find more information about the property here: http://msdn2.microsoft.com/en-us/library/aa981241.aspx

re: Configuring and Customizing the Content Query Web Part

ecmblog — Mon, 19 Mar 2007 21:51:57 GMT

Hi Karthik, you can set the XSLs that the web part loads at runtime. You could write another control, for example, that sits on the page that sets the CQWP's item, header, and/or main XSL files at some point before the render method is called. Each of the three XSL files are represented as separate properties in the web part. They're also expressed as .webpart properties in the XML.

re: Configuring and Customizing the Content Query Web Part

ecmblog — Mon, 19 Mar 2007 22:01:02 GMT

Hi George Karkalis,

You are only seeing your items in edit mode because the caching infrastructure of the CQWP does not cache checked-out items of individual users and we disable cache in edit mode. You can disable caching on your webpart by setting the "UseCache" property to false.

re: Configuring and Customizing the Content Query Web Part

ecmblog — Mon, 19 Mar 2007 22:04:10 GMT

Hi Jason Becker,

You should look into extending the ContentByQueryWebPart class, from there you can add additional properties to the web part and also pass new arguments down to the XSLT.

Adri Verlaan

re: Configuring and Customizing the Content Query Web Part

ecmblog — Mon, 19 Mar 2007 22:10:23 GMT

Hi briand,

You can fix this by modifying the following line in ContentQueryMain.xslt from

<xsl:if test="$UseCopyUtil = 'True'">

<xsl:value-of

select="concat('/_layouts/CopyUtil.aspx?Use=id&Action=dispform&ItemId=',@ID,'&ListId=',@ListId,'&WebId=',@WebId,'&SiteId=',$SiteId)"/>

</xsl:if>

to (added $SiteUrl)

<xsl:if test="$UseCopyUtil = 'True'">

<xsl:value-of

select="concat($SiteUrl,'/_layouts/CopyUtil.aspx?Use=id&Action=dispform&ItemId=',@ID,'&ListId=',@ListId,'&WebId=',@WebId,'&SiteId=',$SiteId)"/>

</xsl:if>

Adri Verlaan [MSFT]

re: Configuring and Customizing the Content Query Web Part

ecmblog — Mon, 19 Mar 2007 22:23:10 GMT

Hi alex,

1. Yes, it is possible to use data from other sources but will require some coding. First retrieve the data from your source and convert it to a DataTable. Then set your resulting DataTable into the "Data" property of the CQWP. From there the CQWP will use the data provided instead.

2. You can achieve this by extending the CQWP. You could use a querystring parameter to identify the month and then have your extended CQWP change the CAML based on the month.

Adri Verlaan [MSFT]

re: Configuring and Customizing the Content Query Web Part

ecmblog — Mon, 19 Mar 2007 22:28:33 GMT

Hi Adam,

You can achieve your scenario by extending the CQWP and overriding the "ModifyXsltArgumentList" function to pass a new parameters (List Name) down to the XSLT engine.

protected override void ModifyXsltArgumentList(ArgumentClassWrapper argList)

argList.AddParameter(columnName, namespace, value);

Adri Verlaan [MSFT]

re: Configuring and Customizing the Content Query Web Part

ecmblog — Mon, 19 Mar 2007 22:33:55 GMT

Hi Jeremy W,

For time comparisons you need to include the following CAML attribute: IncludeTimeValue="TRUE"

Adri Verlaan [MSFT]

re: Configuring and Customizing the Content Query Web Part

ecmblog — Mon, 19 Mar 2007 22:42:50 GMT

Hi Ana,

The CQWP will show list types that are present on the root web. If it is only present in a sub-web then you can use the ListsOverride property to set the correct value.

Out of the Box, the Pages Library server template is 850, hence you might set the ListsOverride property to the following:

Adri Verlaan [MSFT]

re: Configuring and Customizing the Content Query Web Part

ArtiK — Tue, 20 Mar 2007 05:10:15 GMT

Hi, thanks for the quick reply. I have tried the example from msdn sdk as well and it gives the same error.

I tried creating a CQWP to display items from one of the document libraries, this works fine. Then exported it to add in the query in the QueryOverride property. One the query is entered, it gives the error "There is a problem with the query that this Web Part is issuing. Check the configuration of this Web Part and try again.".

Is there any specific configuration or authentication required to be set somewhere? I have tested my queries using the U2U CAML Query Builder and they are retrieving the correct data.

Really lost figuring out what is wrong. Appreciate your reply. Thanks.

re: Configuring and Customizing the Content Query Web Part

ArtiK — Tue, 20 Mar 2007 06:20:53 GMT

Hi, I have managed to get the CQWP webpart to work using the queryoverride property, there was some problem with the query format.

Thanks for the help.

re: Configuring and Customizing the Content Query Web Part

JoeD — Mon, 26 Mar 2007 16:33:36 GMT

In ItemStyle.xsl, I see this for every template:

<xsl:variable name="LinkTarget">

<xsl:if test="@OpenInNewWindow = 'True'" >_blank</xsl:if>

</xsl:variable>

When I use the CQWP to display links from a Links list, I want the links to open in a new browser window. The above looks like it should do it, but I don't see an "Open in new window" field when I create a link in a Links list. Can I add a field that will take advantage of this?

re: Configuring and Customizing the Content Query Web Part

BeckyB — Wed, 28 Mar 2007 06:43:30 GMT

How can I create a content query web part that queries multiple types of lists? For example, I want to create a "News and Information" CQWP where items from both a Pages Library and a Document Library are returned. But when I start defining a CQWP, I am only presented with one choice for a list type.

re: Configuring and Customizing the Content Query Web Part

ecmblog — Fri, 30 Mar 2007 23:25:01 GMT

Hi JoeD,

Yes you can take advantage of this.

Create a new column to your list called "OpenInNewWindow".

Then add "OpenInNewWindow" to the CQWP CommonViewFields property.

http://msdn2.microsoft.com/en-us/library/ms497457.aspx

Adri Verlaan [MSFT]

re: Configuring and Customizing the Content Query Web Part

ecmblog — Tue, 03 Apr 2007 22:57:42 GMT

Hi BeckyB,

You should look into what the ListsOverride property can offer you.

http://msdn2.microsoft.com/en-us/library/aa981241.aspx

Adri Verlaan [MSFT]

re: Configuring and Customizing the Content Query Web Part

rkeinc — Tue, 17 Apr 2007 16:51:57 GMT

I have been working in a MOSS 2007 environment and cannot find the Content Query Web Part in the web part Gallery. Where can I obtain it/download it?

Thank-you very much,

Rod

rkeinc@rke-inc.com

rodney.erb@us.army.mil

re: Configuring and Customizing the Content Query Web Part

rkeinc — Tue, 17 Apr 2007 17:29:13 GMT

My SharePoint 2007/MOSS 2007 environment has NOT had the Content Query Web Part installed because the system administrator indicated if it relies on MOSS 2007 search/indexing there are problems with our server in this area.

My question to the guru's out there is does the Content Query Web Part rely on searn/indexing?

If it does NOT my system administrator indicated he would install it now.

Thanks to anyone who might know the answer.

Rod

re: Configuring and Customizing the Content Query Web Part

ecmblog — Wed, 18 Apr 2007 00:06:55 GMT

Hi Rod,

The Content Query Web Part [CQWP] does not rely on MOSS search/indexing.

Adri Verlaan [MSFT]

re: Configuring and Customizing the Content Query Web Part

rkeinc — Wed, 18 Apr 2007 23:49:36 GMT

At Step 4 (see below) the article assumes the reader knows how to edit the web part. How do you edit the web part? In the picture, I see STYLE LIBRARY "This System List was created by the Publishing Resources feature to..." I'm lost... can someone help me? Specifically, I am trying to add a "column" (Publish) to the Content Query Web Part so that I can render/select it in my Query

"Step 4: customize XSLT to render additional fields

The Content Query web part utilizes XSLT to render its contents. This means that I can edit the way the web part renders content and configure exactly what is shown and how it's shown.

If I edit the web part and look at the toolpane, I'll see a couple of drop-downs that relate to Styles. These correspond to the Header and ItemStyle XSLT files that are located in the site collection's Style Library, which is in the root site."

Thank-you.

Rod

re: Configuring and Customizing the Content Query Web Part

Zandy Garrard — Thu, 26 Apr 2007 23:33:11 GMT

Perhaps this is a basic question - but where do the values for the filter portion come from? For instance, if I choose to filter my Content Query web part under Additional Filters, I get a drop-down list box (Show items when:). Where does this list of fields come from? how can I add fields to this list?

Thanks

Zandy

re: Configuring and Customizing the Content Query Web Part

Edward Owens — Fri, 27 Apr 2007 15:52:26 GMT

My installation of MOSS 2007 is missing the Content Query Web Part, along with the Summary Summary Link Web Part and Table of Contents Web Part. How do I install these?

re: Configuring and Customizing the Content Query Web Part

rkeinc — Tue, 01 May 2007 22:30:44 GMT

Ed,

The Content Query Web Part is part of the “Web Content Management” features of Microsoft Office SharePoint Server 2007 and in order to use it you need to turn on the Publishing feature on a site. It is not available in a default Windows SharePoint Services v3 installation.

The following article which is based on the beta may be useful in how to use it once you get it installed...

http://www.microsoft.com/belux/msdn/nl/community/columns/stevenvandecraen/contentquerywebpart.mspx

I hope this helps.

Good Luck,

Rod

re: Configuring and Customizing the Content Query Web Part

ecmblog — Wed, 02 May 2007 03:51:01 GMT

Hi Zandy,

The list of fields is derived from the Site Columns.

You can add new columns following this path:

Site Actions->Site Settings->Modify All Site Settings->Site columns->Create.

Adri Verlaan [MSFT]

re: Configuring and Customizing the Content Query Web Part

Mike G — Thu, 10 May 2007 03:40:03 GMT

Great article (and thanks to Heather Solomon for her additional information).

I've been able to really tweak the CQWP results but I'm stuck with a list of results where I'd like to display the results as a grid with multiple columns.

I've figured out how to create a new column for each group (<property name="DisplayColumns" type="int">2</property> within .webpart), but I'd really like to have a display more similar to what's available with a photo library.

Any help?

Mike.

re: Configuring and Customizing the Content Query Web Part

ecmblog — Sat, 12 May 2007 03:03:33 GMT

Hi Mike,

You can achieve your scenario, using at least two different methods:

1. You can modify ItemStyle.xsl and create <div> with specific CSS attributes to create your columns.

http://www.glish.com/css/ has some good example of how to do this.

2. You can modify ContentQueryMain.xsl and add a <table>/<thead>/<th> tag before the call-template to each items and a closing </table> tag afterwards. Then Modify the ItemStyle.xsl to generate a single row using <tr> and <td>/<th>

Adri Verlaan [MSFT]

re: Configuring and Customizing the Content Query Web Part

vamsi — Wed, 16 May 2007 17:01:16 GMT

Will it be possible to assign the filter value dynamically..for eg getting site name and assinging to filter value ?

re: Configuring and Customizing the Content Query Web Part

ecmblog — Wed, 16 May 2007 23:20:53 GMT

Hi vamsi,

You can do this by extending the Content Query Web Part and assigning the filter values during OnLoad() of the web part.

Adri Verlaan [MSFT]

re: Configuring and Customizing the Content Query Web Part

anhpt — Thu, 17 May 2007 10:28:55 GMT

Hi George Perantatos,

I have created a Column with type of lookup from a My List and I add to Page content type. When i used Content Query Webpart to filter information but that column disappear to manipulate

I tried to create a new column with type of Choice, new column always appear in filter property of Content Query Web part

Please help me.

Pham Tuan Anh

re: Configuring and Customizing the Content Query Web Part

ecmblog — Fri, 18 May 2007 02:23:46 GMT

Hi Pham Tuan Anh,

The Content Query Web Part [CQWP] shows only site columns. You can add site columns by going to:

Site Actions->Site Settings->Modify All Site Settings->Site columns

Also the Cross List Query [XLQ], which is the data source of the CQWP does not support choice or lookup fields that have multi-choice enabled.

Adri Verlaan [MSFT]

re: Configuring and Customizing the Content Query Web Part

Sam — Tue, 22 May 2007 16:51:07 GMT

Has anybody else encountered a problem using lookup columns with the Content Query Web Part?

I have a site column called Portfolio which is a lookup from a list on my top level site. This column has been added to a content type. I have instances of this content type on several subsites.

I am trying to roll up all instances of this content type onto my top level site.

I have edited the CommonViewFields property of the .webpart file to include Portfolio,Lookup however I get the following message when I upload this web part

'There was an error retrieving data to display in this Web Part'

I have other custom columns in this content type which work fine but aren't lookup columns.

Any help would be greatly appreciated.

re: Configuring and Customizing the Content Query Web Part

Sam — Wed, 23 May 2007 16:15:25 GMT

Follow up to above...

I have just found that by grouping the items by another lookup column on that content type, the Portfolio lookup is displayed. As soon as I take this grouping off I get the error message as above. How strange.

Does anybody have any ideas why this should be so?

re: Configuring and Customizing the Content Query Web Part

ecmblog — Thu, 24 May 2007 20:13:30 GMT

Hi Sam,

Most likely the error is caused because the lookup column allows multi choices. Multi choices is not supported by the Cross List Query [XLQ] which is the data source of the Content Query Web Part [CQWP].

Adri Verlaan [MSFT]

re: Configuring and Customizing the Content Query Web Part

ron williams — Fri, 25 May 2007 01:58:06 GMT

Is it possible to configure a CQWP to return a list of documents that have the edit drop down (check in/out, send to, etc.)?

re: Configuring and Customizing the Content Query Web Part

Sam — Fri, 25 May 2007 12:39:16 GMT

Hi Adri,

Thanks for your reply.

However, the lookup column does not allow multiple choices. As I mentioned, when grouping the items by another column then the lookup value is returned, but when there is no grouping then the error message is displayed. It sounds a bit like a bug. Can anybody else reproduce it?

re: Configuring and Customizing the Content Query Web Part

James — Tue, 29 May 2007 18:15:38 GMT

Hi there, wondering if anyone else has experienced this behavior. I have a list with a couple of custom fields on it (the list is derived from the 'Site List' type from the Site Directory site template).

I am able to get the fields that were initially part of the list template (Region, Division, URL) to show up in the filter drop-downs using the AdditionalFilterFields property. I can also get my custom fields to show up (for example, I added 'Site Type').

The problem - when I enter a value to query for Region, the expected results are returned. However, if I enter a value for 'Site Type', expected results are NOT returned.

Is there some problem with using custom fields added to a list template for filtering?

Thanks in advance - James

re: Configuring and Customizing the Content Query Web Part

marvin — Wed, 06 Jun 2007 17:18:40 GMT

hi, I have one problem.

I use side navigation and content query webpart.

When I change side navigtation configuration. query source is changed in webpart automatically.

for example)

/MDocuments -> /defalut.aspx/MDocumets

It means that /defalut.aspx is created automatically.

re: Configuring and Customizing the Content Query Web Part

marvin — Wed, 06 Jun 2007 18:38:25 GMT

Hi folks,

Sometimes, when I changed navigation configuration, the query soruce is changed automatically.

for example)

/document -> /defalut.aspx/document/

Any idea how to fix this?

Thank you.

re: Configuring and Customizing the Content Query Web Part

Mark — Sat, 09 Jun 2007 00:23:00 GMT

I have the CQWP on my site, but it only shows the image rollup or description on a publishing page.

if I query a task list or calendar, not even the description appears.

re: Configuring and Customizing the Content Query Web Part

Shimon — Mon, 11 Jun 2007 19:52:24 GMT

Hello,

I am trying to pull up the list of attachments attached to specific item at the list in order to display them on the page. I'm using CQWP to query the list, but i can't get done.

Do anybody have an idea how it could be accomplished?

Thanks,

Shimon

re: Configuring and Customizing the Content Query Web Part

nxliu — Fri, 15 Jun 2007 10:38:05 GMT

yes, it works, but only under system user(eg. 'browse in explorer' under sharepoind designer ), after configure my site to anonymous access, only title field is displayed when access in anonymous user, am i missed any configuration step?

re: Configuring and Customizing the Content Query Web Part

Tim — Fri, 15 Jun 2007 14:24:48 GMT

Hi there,

first of all thanks for the great post above - helped me a lot. I'm still a beginner when it comes to sharepoint customizing so I hope you can help me with these bunch of questions :)

i created a template in the itemstyle.xsl to display the latest announcements. I added the title, the date and the author to the output.

So, my first question is (maybe the easier one): what has to be changed within the attached lines of code(or elsewhere) to display a 24h-format of the time ?

<xsl:variable name="Created">

<xsl:value-of select="ddwrt:FormatDateTime(string(@Created) ,1033 ,'dd-MM-yyyy hh:mm')" />

</xsl:variable>

...

My second question is probably tougher: i wanted to display with the CQWP the latest documents of a scope. no problem bout that.

The Problem comes up when I wanted to display the name! of the document in the webpart - not the title. All i could find was the "FileRef"-Field, which displays the whole path of the document.

I also discovered "FileleafRef" for the name of the document but couldn't make it to display it in the webpart.

Is there maybe a possibility with substring in combination of FileRef ? or how else can i display the name of the document ?

...

Finally, my last questions is what did i wrong in the following code? why does my CQWP do not show the first 200 chars of the content of my announcements and just the "..." ? must be a stupid mistakes by myself but couldn't find it!

Modified by <xsl:value-of select="$Author" /> at <xsl:value-of select="$Created"/> O'Clock

</span>

<div>

<xsl:value-of select="substring(@PublishingPageContent, 0, 200)" disable-output-escaping="yes"/>

</div>

i also add the following lines in the .webpart-file:

<property name="CommonViewFields" type="string">ExternalUrl,URL;PublishingPageImage,Image;PublishingPageContent,Note;</property>

I am appreciate for any hints.

Thanks,

Tim

(hope i english isn't too bad)

re: Configuring and Customizing the Content Query Web Part

Brian — Tue, 19 Jun 2007 23:35:14 GMT

You are the bomb ... this is quite useful. I knew it was possible, you have saved me several hours of digging.

re: Configuring and Customizing the Content Query Web Part

Sanjeev — Fri, 06 Jul 2007 15:40:18 GMT

Hi,

Thanks for the useful post. I've been able to use information in this post and others to create a 'task rollup' view using the CQWP. The query had to be customized to return the Due Date, Assigned To, fields etc. The task lists being queried exist on the root site and a number of sub-sites within a site collection.

This worked wonderfully until I logged in as a user that is not a Site Collection Administrator - this user does not see any of the custom-queried fields, only the task title. If I make the user a site collection admin, it works.

Anyone else seen this?

Coult there be a bug in the implementation of the CQWP where it is not executing the query to get the additional fields with elevated privilege?

Thanks!

re: Configuring and Customizing the Content Query Web Part

Sahal — Wed, 11 Jul 2007 15:10:47 GMT

Hello to all,

All the thanks to everybody to share this valuable information...

I have a case and I do not know if it face any of you.

When I use the CQWP to query all documents inside specific folder in specific Document Library, It does not work.

The error is: "Cannot save the property settings for this Web Part. The list name is not valid. The list name should refer to a list within the specified site: /listname/"

Any idea how I can modify the CQWP to do so?

Any help would be greatly appreciated...

re: Configuring and Customizing the Content Query Web Part

Paul — Wed, 11 Jul 2007 20:28:48 GMT

What a shame that its all so "black box". Would be nice to ba able to see the XML I'm supposedly working against. Does my extra "CommonViewField" come through? who knows, it could be ropy XSL, but I've no way of knowing. Talk about overcomplicating something simple.

re: Configuring and Customizing the Content Query Web Part

LL — Thu, 12 Jul 2007 07:25:49 GMT

Would you please give me some suggestions on how to retrieve the results data from the Content Query WEbPart?

Firstly, I setup the WebPart to retrieve List data from all sites' tasks Lists. Those Listitems are return to the WebPart and I can see the results on the screen.

Now I would like to get those results data from the Webpart and passing them to another web applicaiton.

How can realize this function?

re: Configuring and Customizing the Content Query Web Part

tutejaamit5 — Wed, 18 Jul 2007 09:36:50 GMT

#Problem getting outer div around all the items

Hi ,

I want to add a div tag,and want to open it in header and close that div in footer in ItemStyle.xsl.I have found both header and footer.

I tried implementing the Mike's way(https://blogs.pointbridge.com/Blogs/gehard_mike/Lists/Posts/Post.aspx?ID=23)

but it does not seems to be working.Whenever i add and open a simple div tag in header and close it in footer,it gives an error.When i prefixed <![CDATA[ before div,it just printed the div as simple string.

re: Configuring and Customizing the Content Query Web Part

JWM — Thu, 19 Jul 2007 21:45:43 GMT

Is it possible to install this Content Query Web Part on WSS 3.0? All I have found on this web part assumes that you already have it on your Sharepoint server, and I know it comes with out of the box MOSS. I have WSS 3.0 and need a web part that will do what the CQWP will. Any suggestions? Thanks!

Configuring & Customizing a CQWP

Mirrored Blogs — Sat, 21 Jul 2007 00:05:26 GMT

http://blogs.msdn.com/ecm/archive/2006/10/25/configuring-and-customizing-the-content-query-web-part.aspx

re: Configuring and Customizing the Content Query Web Part

Vicky Nguyen — Sat, 21 Jul 2007 00:20:27 GMT

Hi,

I've read a few blogs on how to use Content Query Web Part to rollup information from multiple sharepoint lists. I could still not successfully get it to work.

I basically just want to use CQWP to rollup the two task list we have on two separate Sites (Parent & child sites). I was successfully get the title of tasks from both lists to show up, but I would like to also display additional fields from the task list in this rollup web part, I couldn't get it to work. Please help

re: Configuring and Customizing the Content Query Web Part

icemx — Mon, 30 Jul 2007 04:54:04 GMT

I, i would to use Content by query in a user control with

url in parameters and costum field. My problem is i dont want

import and export my cbq in a web part zone.. I want use

the cbq control and use its properties. I find in a web and i

just find the solution in this article... Do you know how i can

display my custom field with xslt but not with the import

export way?

thanks

re: Configuring and Customizing the Content Query Web Part

Kwok-Ho — Wed, 01 Aug 2007 17:28:18 GMT

Hi,

I'm getting the hang of CQWP and all.. but I got stuck at the Additional-Field part. Now I have a field which can either be filled with multiple values or no values (null/blank). Is it possible to filter these out?

I've tried several possibilities with 'is equal to' and 'is not equal to' and the AND and NOT operator. But the results are either Show All or None :S

Thanks

Kwok-Ho

re: Configuring and Customizing the Content Query Web Part

Andy — Mon, 13 Aug 2007 12:18:10 GMT

Hi,

I had copied the "Image on Right" item template to "MyItemTemplate" in the itemstyle.xsl.

The newly added item can be selected in the tool plane. However, no changes in layout even thou' I updated the itemstyle.xsl.

Do we need to restart anything (e.g. iis / wss) in order to take effect?

re: Configuring and Customizing the Content Query Web Part

Thomas — Tue, 14 Aug 2007 17:38:57 GMT

Hi,

we have a Custom list on the home page which we must display on several other web sites. I tried to do that with the content query Web Part, but i want to display _all_ Columns from the list. Is it not possible to display that without manually select the columns via export webpart/edit xml ?

Thanks

re: Configuring and Customizing the Content Query Web Part

eddietec — Wed, 15 Aug 2007 23:37:33 GMT

Hi guys, somebody knows how to retrieve the Display Name of a column?. Actually, the name() funtion gets the internal column name only.

Thks.

re: Configuring and Customizing the Content Query Web Part

rkeinc — Thu, 16 Aug 2007 16:17:17 GMT

Go to http://www.heathersolomon.com/blog/articles/CustomItemStyle.aspx and good luck!

re: Configuring and Customizing the Content Query Web Part

David Porter — Mon, 20 Aug 2007 18:05:00 GMT

I'd like to leverage the Content Query Web Part to display a Summary link part created on my main page, to display the Summary Link web part throughout all other pages.

I've been succesful in doing this with my announcements but don't see Summary Link web part as a option in the List Types, only links.

re: Configuring and Customizing the Content Query Web Part

Yannis Chaviaras — Thu, 30 Aug 2007 20:04:01 GMT

Hello,

I receive the following error message when creating any CQWP.

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

The funny thing is that with my admin account, the CQWP works fine. Every other user, receives the above error message on his screen.

Any help would be highly appreciated!

re: Configuring and Customizing the Content Query Web Part

bartski — Thu, 06 Sep 2007 17:50:07 GMT

Hello,

I want the CQWP to show items from multiple list types. The Page library, a document library and a custom list.

I tried this by using the list override property but:

When I use de GUID from a custom list or a link list in combination with a guid from a document library and the page library it doesn't show the items from the custom list only from the libraries.

When I just use the (custom) list GUID it works fine for that one.

Code example:

<![CDATA[

<Lists>

</Lists>]]>

Could anyone help me out, please?

Greetz

re: Configuring and Customizing the Content Query Web Part

Lellie — Mon, 10 Sep 2007 15:25:09 GMT

What about those of us with WSS 3? This is exactly what I need for a site, but I don't have MOSS 2007. Any ideas how we can get the same functionality - is it possible to install the web part or import one in to do this?

re: Configuring and Customizing the Content Query Web Part

Bob — Tue, 11 Sep 2007 05:21:27 GMT

Greetings,

This worked like a champ! Thanks for the code.

One question. I am rolling up announcements from other departmetns into a single announcement on my "root home page". therefore in my query section I have selected:

* show items from all sites in this site collection

I would much rather pick and choose the annoucement lists if possible. Is there a way?

Also, I only want to show the 2 most recent announcements from each department annoucement list in my roll-up but I have not found a way to do that. Your example above does not quite fit, since, I believe I am querying the whole site collection.

Thanks for your help

bsieloff@gmail.com

re: Configuring and Customizing the Content Query Web Part

Dario — Mon, 17 Sep 2007 22:51:00 GMT

Hello,

I have to share contents between diffetent Sites Collection. I mean, I need to show a content information from SiteCollection1 in SiteCollection2.

Is there a way to do this?

Thanks for your help

re: Configuring and Customizing the Content Query Web Part

Lucas Persona — Wed, 19 Sep 2007 00:18:45 GMT

After reading this, Heather's and a couple of other posts, my main objective was to 'wrap' all items from a list in a DIV tag, with minimal impact to ContentQueryMain.xml

I've found something not posted in any of these blogs/posts/comments that may well indicate further developments on this area.

Both Header and ItemStyle have a 'mode' attribute.

ContentQueryMain call three templates types: CallHeaderTemplate, CallItemTemplate and CallFooterTemplate.

The problem is that only the first too actually call something else, while the last one, just add a DIV tag for the footer.

My change, that I believe will be implemented in next MOSS release, was to add to ContentQueryMain 'CallFooterTemplate' template:

<xsl:apply-templates select="." mode="footer">

</xsl:apply-templates>

Then inside Header.xsl, you can create two GroupStyle templates using both modes 'header' and 'footer', where the tags for open/close tables, divs, and everything else can be placed.

Works very good, with minimal changes to ContentQueryMain.xml, and using the same architecture that MS is using for Header and Item.

Regards,

Lucas Persona

re: Configuring and Customizing the Content Query Web Part

Jen — Wed, 19 Sep 2007 20:56:02 GMT

Hi,

I am trying to configure the CQWP for our team site. We want to roll up tasks assigned to a given user from multiple child sites and display them all on the parent site. When I run the query and select the "assigned to" filter, I get the error, "There was an error retrieving data to display in this web part," even though the user's tasks should have been displayed. Oddly, when I change the filter selection to "created by" and run the query, it works. I've been searching for a solution and haven't been able to find one. Has anyone else encountered this?

Thanks,

Jen

re: Configuring and Customizing the Content Query Web Part

Pete — Thu, 20 Sep 2007 12:35:06 GMT

I am trying to follow the example above and it all works great except I can't get it to return the fields from my custom content type attached to the list.

I have added the following code to the styles.

<xsl:for-each select="@*">

P:<xsl:value-of select="name()" />

</xsl:for-each>

The items from the list are returned as expected and the query is set to filter out those items which are not created with my custom content type but none of the fields from my custom content type attached to the list are returned from the <xsl:for-each>

Does the select="@*" filter these out?

Any ideas???

Thanks

Pete

re: Configuring and Customizing the Content Query Web Part

Lucas — Tue, 25 Sep 2007 00:10:29 GMT

Pete,

Are you adding these additional fields to the CommonViewFields tag in the XML (after you Export the webpart)?

Lucas

re: Configuring and Customizing the Content Query Web Part

Pete — Tue, 25 Sep 2007 04:47:21 GMT

Hi Lucas,

No I haven't... I guess my understanding was that this would show me all fields associated with this list. If I have to add the fields to the CommonViewFields tag in the xml then I already know what these fields are and surely this code is redundant? Am I missing the point of this code?

I was hoping that this code would show me what fields are associated to the list so I knew what to put in the CommonViewFields tag?

Thanks

Pete

re: Configuring and Customizing the Content Query Web Part

Shannon — Wed, 26 Sep 2007 19:54:12 GMT

More questions on the need for more than three filters within the CQWP and it is a two parter:

1. I need a way to have the author specify more than three filters but I can not find anything that shows how to get the CQWP to display more than three sets. Using the QueryOverride does just that, it disables the UI area for the filters at runtime.

2. Is there a way to do an "AdditionalQuery" in that it takes what is entered by the author in the filter fields and add whatever additional params to the query - like a QueryOverride but not override the whole query. Need for global date filtering so that the authors don't have to specify it every time.

Or, to do any of the above, need to make a custom CQWP?

re: Configuring and Customizing the Content Query Web Part

ecmblog — Thu, 27 Sep 2007 03:12:49 GMT

Hi ron,

Yes it is possible to modify the XSLT to show an edit drop down menu.

Hi James,

The AdditionalFilterFields takes internal names, and not their display names. The space in "Site Type" gets converted by SharePoint, check the URL when modifying your site column the internal should be in it.

Hi Marvin,

Navigation should not affect the CQWP. Do you have custom code, what navigation setting are you changing?

Hi Mark,

You need to figure out where calendar/task list description are stored and follow the article instruction.

Hi nxliu,

Have you published and approvel your XSLT?

Hi Tim,

FormatDateTime passes the specified string to the toString of a DateTime, the doc bellow should help you figure out what format you want: http://msdn2.microsoft.com/en-us/library/k494fzbf.aspx

Check DataColumnRename and try to rename the column you want to show as title to "Title"

Since you are getting the first 200 character, there might be malformed tags or missing tags, which causes the browser not to render your content where you expect it to be. Also make sure that this is indeed the internal name of the column where your data reside.

Hi Sanjeev,

This is most likely because your XSLT are in draft mode, hence only visible to the Site Collection Administrator from which you modified those files. You need to publish and approve your changes.

Hi Sahal,

The CQWP does not support specifying a folder, please select a list. You can use one of your filter tripplet to reduce the result to a specified folder.

Hi LL,

You can extend the CQWP, from there you can do what you want with the data. There are also some API that you can call to retrieve the data (and cached), without the need to use the CQWP for your third party web applications.

Hi tutejaamit5,

Try to print your value as text by putting quotes in your select attribute, otherwise you might need to modify the ContentQueryMain.xslt to do what you want.

Hi JWM,

This is a MOSS only feature.

Hi Vicky,

What step are you having a problem with?

Hi icemx,

You can use SharePoint Designer and drag and drop the web part and modify the property from a toolpane.

Hi Kwok-Ho,

Unfortunatly the data source that the CQWP uses does not support Mutli-Valued Lookups or Multi-Choice columns.

Hi Andy,

Check your first line, and verify that the match attribute is correctly set.

Hi Thomas,

Not to my knowledge but you might have more luck looking up SPSiteDataQuery documentation.

Hi eddietec,

To get the display name you will need to extend the CQWP and write code to pass down as an arguments the display name of your columns.

Hi David,

To achieve this scenario you will need to write a new DataSource that retrieve the data from your summary link web part. What I would suggest is creating a custom list and placing your items there, and then have all your CQWP point to that list.

Hi Yannis,

Most likely the Site administrator is seing a draft version of the xslts that are valid, while users are still seeing the published xslts version. Publish and approve your xslts.

Hi bartski,

Check the SPSiteDataQuery documentation to see if having stream and non-stream items in a single request is supported.

Hi Lellie,

The CQWP is a MOSS only feature, but you can upgrade WSS to MOSS.

Hi Bob,

You can set your query to a list and specify the maximum number of items to return using the toolpane.

Hi Dario,

This is currently not supported without custom code.

Hi Jen,

Most likely your assigned to column is a multi-value lookup or multi-choice column which is not supported by our data source (SPSiteDataQuery)

Hi Pete,

The code snippet you specified only returns the column name once those column have been requested, you will need to first specify the CommonViewFields so that those column are returned with the data. You can get the list of columns of a list by looking at it's settings.

Hi Shanon,

Yes, you will need to extend the CQWP to be able to implement your scenarios.

Adri Verlaan [MSFT]

re: Configuring and Customizing the Content Query Web Part

Harlan — Thu, 27 Sep 2007 17:56:42 GMT

I used this example to pull content from an announcements list and display the body contents in the CQWP. However, I'm having problems displaying double quotes from the body of the announcement. They show up as '&quot' in the CQWP, and looking behind it seems that it translates the '&' from the '&quot' to '&' and then adds the rest 'quot;' so what I see when I view the source is '&quot;'.

Anyways, I tried to fix the problem by using a simple XPath replace function on the $bodyContent in the ItemStyle.xsl, but it fails the web part. What I've written is this:

<xsl:value-of select="replace($bodyContent, '&quot;', '"')" />

I have tested the function by replacing a with b and it still fails with the message Unable to display this Web Part.. etc.

Any suggestions? Is my syntax incorrect? Any other way to solve this problem? Funny thing is that double quotes from the announcements' titles are displaying correctly.

Thanks for any suggestion..

- Harlan

re: Configuring and Customizing the Content Query Web Part

Nancy — Wed, 03 Oct 2007 02:06:51 GMT

I have the same problem as Yannis: Unable to display webpart... Pages are not publishing pages. Admin can see CQWP info, but others can't, but sometimes the others can. This problem has just arisen in the last week. Previously, no problem with anyone seeing anything. Sites are provisioned from a template, but then changes are made to the provisioned site and the error arises.

Help!

Visual How-To: Displaying Custom Fields in Content Query Web Parts in Office SharePoint Server 2007

Microsoft Enterprise Content Management (ECM) Team Blog — Wed, 03 Oct 2007 23:19:09 GMT

The topic of making the Content Query web part display custom fields has been a hot topic on this blog

Friday 10/5 SharePoint Link Love

Mirrored Blogs — Fri, 05 Oct 2007 14:24:51 GMT

I don't normally do this, but there are a few things I've noticed in my feeds the last week or

Visual HowTo Custom Fields im CQWP anzeigen

SharePoint, SharePoint and stuff — Mon, 08 Oct 2007 13:49:34 GMT

Ein Visual HowTo zum Thema Displaying Custom Fields in Content Query Web Parts in Office SharePoint Server

Enhanced Content Query Web Part available on CodePlex

Microsoft SharePoint Products and Technologies Team Blog — Thu, 11 Oct 2007 08:54:58 GMT

The Content Query Web Part (or CQWP) in MOSS 2007 is one of the most often used components on SharePoint-based

Enhanced Content Query Web Part available on CodePlex

Noticias externas — Thu, 11 Oct 2007 09:19:28 GMT

The Content Query Web Part (or CQWP) in MOSS 2007 is one of the most often used components on SharePoint

CQWP debug item style

Mirrored Blogs — Fri, 12 Oct 2007 00:28:14 GMT

Reading this post a few months ago I found this great tip. If you want to know what are the fields that

SharePoint 2007 : Customization de la Content Query Web Part

Philippe Sentenac [Usual Coder] — Fri, 12 Oct 2007 18:04:38 GMT

Aujourd'hui, je vais profiter de vous donner quelques informations sur la customization de la content

re: Configuring and Customizing the Content Query Web Part

chia weng yan — Wed, 17 Oct 2007 12:10:02 GMT

Hi everyone,

I need some help.I have just created a publishing portal. I have problem with my anonymous access. Somehow member of the public cant view my custom list item without being prompt for a username and password. I have set the anonymous access to "view entire websites". I do not have the same problem with other theme sites. I think the problem lies in the lock down mode (limited access) in publishing portal. Can anyone teach me how i can handle anonymous access to allow them to view custom list item?.. Any help is appreciated

Thanks

Chia Weng Yan

re: Configuring and Customizing the Content Query Web Part

Daniel — Wed, 17 Oct 2007 15:52:20 GMT

Excellent blog!

I have one question, I want to group by weeks, how do I accomplish that?

re: Configuring and Customizing the Content Query Web Part

Peter — Sat, 20 Oct 2007 13:39:01 GMT

Great article. It works great here.

I have one question, when user click the (more) link, I want to just show the entire annountment on the web page without Title, Body, Expires, ... in the left hand side and announcement details on the right hand site.

In other word, I just want to display announcement details on the page without showing all announcement attributes in a table format

How can I do it?

Thanks,

Peter

re: Configuring and Customizing the Content Query Web Part

Christof — Tue, 23 Oct 2007 19:29:23 GMT

Hi ECM-Team,

is it possible to query the Wiki content field with the Content Query Webpart? There is a field called "WikiField", but if I integrate it in the CommonViewFields nothing will be displayed.

Anybody any ideas??

re: Configuring and Customizing the Content Query Web Part

- Dustin — Wed, 07 Nov 2007 04:49:40 GMT

Is it possible to add paging to the CQWP?

e.g. A CQWP is querying a links list that contains 20 items and the CQWP displays 1-10 initially and has a next option to display 11-20 with a previous option?

Thanks,

Dustin

re: Configuring and Customizing the Content Query Web Part

james — Wed, 07 Nov 2007 20:30:39 GMT

Does anybody know how to get file size internal name and type for a document library. When I checked all field names, I saw '_x0020_ows_File_x005F_x0020_Size'. but when I used the name in xslt, I didn't get any value

re: Configuring and Customizing the Content Query Web Part

oi — Thu, 08 Nov 2007 21:30:02 GMT

Hello, all.

I have such problem as in great article.

In page I uses discussion board.

And task:

News page must to display information about latest discussion board messages. What do you advice to me? (May be I have to use query conten web part or rss viewer.)

Compartir información entre sitios WSS

Jorge Dieguez Blog — Fri, 09 Nov 2007 02:48:06 GMT

Desde que conozco SharePoint siempre he percibido una gran limitación: la imposibilidad de tener

Compartir información entre sitios WSS

Jorge Dieguez Blog — Fri, 09 Nov 2007 02:49:18 GMT

Desde que conozco SharePoint siempre he percibido una gran limitaci&#xF3;n: la imposibilidad de tener

re: Configuring and Customizing the Content Query Web Part

Steve Walsh — Tue, 13 Nov 2007 21:51:33 GMT

I have a similar question as Somash. I followed the link you provided, but I cannot see how to use this for multiple lists. I want to have 1 COntent Query Web Part, and I want it to get data from 2 seperate lists (List 1 and List 2). Is this possible? If so, how? Please help I have been on this problem for weeks now...

Thanks

Steve

re: Configuring and Customizing the Content Query Web Part

rich L — Mon, 19 Nov 2007 23:05:51 GMT

How do you change the UseCopyUtil parameter? For some reason if we make any edits to the Query Web Part it will default the part so that UseCopyUtil will equal true hence displaying a link to the Item List rather than the link address.

This is an upgraded site so the List object being used is the Listings list. I have even exported the web part manually changed the UseCopyUtil to false but if anyone makes even the slightest change to the web part it over writes it back to true.

re: Configuring and Customizing the Content Query Web Part

ecmblog — Wed, 28 Nov 2007 03:41:43 GMT

Hi Harlan,

Your content is being encoded by the xsl engine. This is to stop Cross-Site Scripting vulnerabilities, where a malicious user could create an announcement containing javascript.

-If you trust the content of your announcement, then look into the xsl property disable-output-escaping.

-If you don't trust the content, then the OuterTemplate.GetColumnDataForUnescapedOutput function allows you to verify that the data is indeed from a column that validates agaisn't OSafe (e.g. Html). (Osafe strip out JavaScript from HTML)

Hi Nancy,

Check the ULS logs, they will have information as to why the web part can't display.

Hi Daniel,

You will need to inherit from the ContentByQueryWebPart class and use the ProcessData delegate. From there you can modify your date column, place the same value for the ones you want in the same group. Then you can use the AdditionalGroupAndSorting

Hi Chia,

Yes, it is a conflict with the Lock Down Feature, try disabling the feature then deactivate and reactivating anonymous access for changes to take effect.

Hi Peter,

You can achieve your scenario using JavaScript and DHTML. First start by storing your data into a javascript array and then create a function that populate the right hand side based on the array.

Hi Christof,

Make sure that your items are returned first, otherwise you might have to change settings like Content Type and List Template you are requesting. Then add to the CommonViewFields 'WikiField,Note'.

Hi Dustin,

The Data Source that the CQWP uses does not handle paging. You could request the top 50 items, display initially 10 and create paging on the client using DHTML & JS.

Hi james,

Try File_x0020_Size or File_Size and it should be of type Lookup.

Hi Steve,

Look at bartski post above, it has an example of one can achieve this.

Adri Verlaan [MSFT]

re: Configuring and Customizing the Content Query Web Part

Matthew Vore — Fri, 30 Nov 2007 20:15:01 GMT

Everything is/was working fine until I decided to "Group" the results by DatePublished (custom field). It is grouping them just fine, but I can't customize the style of the group headers, We have a dark green background and the text is black (hardly readible). I tracked the style down to Header.xsl and div class="groupheader item medium", however when i try to put a custom div class there it doesn't work, and I can't seem tof ind where this div is located, I tried throwing it in my stylesheet and even calling my stylesheet inside header.xsl and nothing has worked, any help would be great!

Debugging XSLT from a Content Query WebPart

Imagine Think Create Share — Wed, 05 Dec 2007 02:39:33 GMT

Hi, Today I receive several questions about debugging CQWP XSLT. Although I love writing them in Notepad

re: Configuring and Customizing the Content Query Web Part

Bonnie — Wed, 05 Dec 2007 22:21:11 GMT

I have created a Links list with a content type called FormLink. I'm trying to use a CQWP to display specific links from that links list. It displays them ok, but when you click the link, it takes you into the View Item screen from the list instead of taking you to the URL designated for that item. Ideas on what I've done wrong?

re: Configuring and Customizing the Content Query Web Part

Todd H. — Fri, 07 Dec 2007 01:26:27 GMT

Hi,

I have read this and several other articles/blogs regarding the CQWP. Thanks for all of your help so far and your promptness in answering questions.

My question is simple, I have a "custom list" with a custom column that is a "link" field (linking to content not on my site). When I use the CQWP with this custom list the clickable results of my query always direct me to the actual item on my site not the target of the link in my custom list.

How can I make the result of my query a custom list's link field, so that users can click on the item returned from the CQWP and go directly to the external site for which the item's link field represents.

Thanks!

-Todd

re: Configuring and Customizing the Content Query Web Part

Raja — Thu, 13 Dec 2007 00:58:46 GMT

hi..I need to use the CQWP in a team site. I created the Style Library at the top level site and populated it with content from a publishing site. I can add the web part to the page but it freezes the browser when I try to browse to a list in the web part properties pane..

Can u please tell me what does it take to make it functional in a team site?

Thanks in advance..

re: Configuring and Customizing the Content Query Web Part

Anil Kumar — Tue, 18 Dec 2007 00:43:24 GMT

How can I dispaly a Work flow status column in a list using content query web part.

re: Configuring and Customizing the Content Query Web Part

itay4x4 — Sun, 23 Dec 2007 16:34:15 GMT

I've got a list of "course" that i want to dispaly in my welcome page.

1. I added a CQWP to my welcome page with the following properties --> I've taken the items for a specific list, and the list type is calender.

2. I exported the file and added description to it (i know that in some cases this data is already included, so i tried both ways)

3. opend the file in the designer and edited it :

<xsl:template name="MyView" match="MyView" mode="itemstyle">

<xsl:variable name="SafeLinkUrl">

<xsl:call-template name="OuterTemplate.GetSafeLink">

<xsl:with-param name="UrlColumnName" select="'LinkUrl'"/>

</xsl:call-template>

</xsl:variable>

<xsl:variable name="SafeImageUrl">

<xsl:call-template name="OuterTemplate.GetSafeStaticUrl">

<xsl:with-param name="UrlColumnName" select="'ImageUrl'"/>

</xsl:call-template>

</xsl:variable>

<xsl:variable name="DisplayTitle">

<xsl:call-template name="OuterTemplate.GetTitle">

<xsl:with-param name="Title" select="@Title"/>

<xsl:with-param name="UrlColumnName" select="'LinkUrl'"/>

</xsl:call-template>

</xsl:variable>

<xsl:variable name="LinkTarget">

<xsl:if test="@OpenInNewWindow = 'True'" >_blank</xsl:if>

</xsl:variable>

<xsl:if test="string-length($SafeImageUrl) != 0">

</a>

</div>

</xsl:if>

<xsl:call-template name="OuterTemplate.CallPresenceStatusIconTemplate"/>

<xsl:value-of select="$DisplayTitle"/>

</a>

<xsl:value-of select="@_x0020_Description" />

</div>

</xsl:template>

4. Its seems that something is not working properly since the view hasnt change

could you help me please

Thanks

re: Configuring and Customizing the Content Query Web Part

ecmblog — Thu, 03 Jan 2008 05:49:59 GMT

Hi Matthew,

It is indeed in the Header.xsl, modify the template that correspond to the group style that is selected in the CQWP Toolpane.

Hi Bonnie & Todd,

The url by default for list items are it's view item screen. You will need to modify the xslt and change the value of the url to the value of your column containing your links.

Hi Raja,

You can always type the list you want to retrieve.

Hi Anil,

You need to request the work flow status column using the CommonViewFields property of the web part and then use the DataColumnRename property and/or modify the xslt to show the column data.

Hi itay4x4,

Verify that the Item Style in the Toolpane is now on "MyView".

Adri Verlaan [MSFT]

re: Configuring and Customizing the Content Query Web Part

Thomas Walz — Fri, 04 Jan 2008 13:36:17 GMT

Hi,

i have a content query webpart on my portal. i want to filter the

data via an url-filter webpart. but the cqwp seems not to use webpart connections. is there any way i can do this ?

Thanks

Thomas

re: Configuring and Customizing the Content Query Web Part

Dave — Mon, 07 Jan 2008 20:37:29 GMT

Hi,

I want to use the CQWP to link to a calendar list that has a Single-value lookup field. And I want it to display this field as a link to a PDF file that this lookup is referencing. I can pull the field a but the best I can get is a link to the calendar item, not to the PDf link in the calendar item.

Thanks,

Dave

re: Configuring and Customizing the Content Query Web Part

Dragan Panjkov — Thu, 17 Jan 2008 11:55:42 GMT

when I have double quotes inside my RichHTML field, when rolling up inslide cqwp i receive " instead of "

re: Configuring and Customizing the Content Query Web Part

Dragan Panjkov — Thu, 17 Jan 2008 12:28:30 GMT

solved with disable-output-escaping="yes"

re: Configuring and Customizing the Content Query Web Part

Stephan KW — Mon, 21 Jan 2008 21:02:20 GMT

Thx for this sample great walkthrou.

Is it possible to setup the CQWP to display Items according to the users rights?

I'd like to display the latest sites within a websitecollection. All these pages have an expire date and disappear after this date. But special groups like the content editors and administrators should be able to see these entries plus the expired entries of the last 10 days.

Can you tell me how to set it up?

thx in advance

Steve

Customizing the content query webpart : Part 2

Bart Callaerts — Tue, 22 Jan 2008 18:04:48 GMT

In addition to my previous post. I was working on a way to give the announcementslist a better look through

re: Configuring and Customizing the Content Query Web Part

Alan Wooley — Wed, 23 Jan 2008 09:44:30 GMT

George,

Great post on this subject!!! I am doing a rollup based on the Posts list of a Blog site in the same collection, but I can't seem to get the body to display. Doing the adjustments that you mention above, I was able to get it very VERY close. Example of what is rendering:

BLOG UPDATES

2008/01/23 08:55:00 ＜Title＞　

Author：　＜USER＞　　Created：　2008/01/22

＜BODY＞...more

But the BODY part mentioned above, I can't get no matter what I do. I add this to the ItemStyle.xsl:

<xsl:value-of select="substring(@Body, 0, 200)" disable-output-escaping="yes"/>

href="{$SafeLinkUrl}" target="{$LinkTarget}" title="Lees meer">More...</a></div>

Then I changed the CommonViewFields property in ContentByQueryWebPart.webpart to read:

<property name="CommonViewFields" type="string">Body,RichHTML</property>

Should work, right? Well, it doesn't seem to come out, for some reason. Am I missing a step somewhere? Can you advise what I'm doing wrong? Is it because I'm not specifying something like @Body_x005F_x0020_content? (and how can I easily find what field this is for the Posts list if that is the case?)

Best Regards,

Alan

re: Configuring and Customizing the Content Query Web Part

Senthil — Thu, 31 Jan 2008 08:31:52 GMT

Hi ,

I have a lookup field in my content type. I have edited the CustomView propoerty.

Ex: CommonViewFields="Title,Text;Comments,Text;Author,User;BookCategory,Lookup;".

But it is not displaying the values of the Lookup field. All the other field values are dispalyed in my result.

can any one help me??

re: Configuring and Customizing the Content Query Web Part

Tim Butler — Thu, 31 Jan 2008 20:43:03 GMT

I'm trying to use a content query web part to show some text and an uploaded image (an attachment) from a custom list.

I can work out whether each item has an attachment or not using the attachments property but I can't for the life of me figure out where the file is or what the filename might be.

Is this some kind of known issue which I will never resolve or am I just missing the answer?

Thanks

Tim

re: Configuring and Customizing the Content Query Web Part

martin — Wed, 06 Feb 2008 03:59:55 GMT

I have added a CQWP to the my Intranet home page and want to show all announcements from all sites by

selecting 'Show items from all sites in this site collection',

select announcements for 'List Type:'

select List content type and Announcement under 'Content Type:'

and have grouped by Site.

If I select a 'Show items from the following site and all subsites:' eg. /Corporate it works fine but if I select 'Show items from all sites in this site collection' it doesn't return any announcements and shows 'There is a problem with the query that this Web Part is issuing. Check the configuration of this Web Part and try again.' message.

Any ideas would be much appreciated.

Martin

re: Configuring and Customizing the Content Query Web Part

Peter Hack — Wed, 06 Feb 2008 21:36:38 GMT

Hi,

My problem here is that I have a Hyperlink field in my list, but it displays in the CQWP as text, saying http://www.kcci.com, http://www.kcci.com. (I assume it is displaying twice because its showing the URL and the description from the list field the CQWP is drawing from) It is not displayed as a link though. How can I make the field display properly in the CQWP as a link?

Thanks in Adavance!!

- Peter Hack

From Webpart:

<property name="CommonViewFields" type="string">Market;Column11;Column13;Column14;Column15;Column16;Website2,url;Column7;Column2;Column9;Column10</property>

From XSL:

- <div class="description">

- <h3>

<FONT COLOR="000080">Market:</FONT>

<xsl:value-of select="@Market" />

<br />

<FONT COLOR="000080">Address:</FONT>

<br />

<xsl:value-of select="@Column11" />

<br />

<xsl:value-of select="@Column13" />

<xsl:value-of select="@Column14" />

<br />

<xsl:value-of select="@Column15" />

<br />

<FONT COLOR="000080">Website:</FONT>

<xsl:value-of select="@Website2" />

<br />

<FONT COLOR="000080">Phone:</FONT>

<xsl:value-of select="@Column16" />

<br />

<FONT COLOR="000080">Affiliation:</FONT>

<xsl:value-of select="@Column7" />

<br />

<xsl:value-of select="@Column2" />

<br />

<FONT COLOR="000080">Channels:</FONT>

<xsl:value-of select="@Column9" />

<br />

<FONT COLOR="000080">Coverage:</FONT>

<xsl:value-of select="@Column10" />

</h3>

re: Configuring and Customizing the Content Query Web Part

Chander — Fri, 08 Feb 2008 02:51:13 GMT

Hi Folks,

How to get the Image displayed on the Left in the "image on Left" item style?

Thanks

Chander

SharePoint AcademyLive Recommended Readings

Brett's SharePoint Blog — Sat, 16 Feb 2008 00:09:21 GMT

This won't mean too much for those of you who aren't attending the AcademyLive courses, but here are

re: Configuring and Customizing the Content Query Web Part

Charlene Jacobs — Thu, 21 Feb 2008 15:13:03 GMT

I have created a custom content query web part to show and image and the body od announcement. The body is showing but my image is unfortunately not.

I have change the commonviewfileds property to:

<property name="CommonViewFields" type="string">Body, RichHTML;AnnouncementImageURL, URL;</property>

And also made the adjustments in the ItemStlye.xsl file but image is still not showing in the web part.

The image link is working though, I can see image when I test it.

Please help.

Thanks

Content Query Webpart fun!

Mirrored Blogs — Fri, 22 Feb 2008 11:02:17 GMT

Body: I've been poking around an existing web part and have been having real troubles in pulling

re: Configuring and Customizing the Content Query Web Part

ecmblog — Tue, 26 Feb 2008 02:49:34 GMT

Hi Thomas,

Web Part connections is not supported out of the box. You'll need to create a new class that inherits the Content Query Web Part [CQWP].

Hi Dave,

Your almost there, place the value that you are pulling into the A link href of your XSL.

Hi Dragan,

Your content is being encoded by the xsl engine. This is to stop Cross-Site Scripting vulnerabilities, where a malicious user could create an announcement containing javascript.

-If you trust the content of your announcement, then look into the xsl property disable-output-escaping.

Hi Steve,

Only items that users have rights to see will show up in the CQWP.

Hi Alan,

Most likely Posts list put their content in a site column that is a different name. Check your list settings -> site content type -> site columns to find out what the internal name is for the HTML Content.

Hi Senthil,

Check that your column name or the type is correct (is it a Choice column?)

Hi Tim,

Attachment data is located in a seperate database table, to get your data, you will need to inherit the CQWP and then for each row that has attachment make a call to sharepoint to retrieve the list of attachment for that item.

Hi Martin,

Most likely you've hit the MaxListlimit. http://msdn2.microsoft.com/en-us/library/microsoft.sharepoint.spsitedataquery.lists.aspx

Hi Peter,

Check the OuterTemplate.FormatColumnIntoUrl and OuterTemplate.FormatValueIntoUrl

XSL function provided out of the box.

Hi Chander,

Out of the box it is mapped to the PublishingRollupImage site column.

Hi Charlene,

The Out of the box image is mapped to the PublishingRollupImage. Check that you either used the DataColumnRename web part property to remap AnnoucementImageUrl to ImageUrl. Or modified the XSL and replaced occurences of ImageUrl to AnnoucementImageURL.

Adri Verlaan [MSFT]

re: Configuring and Customizing the Content Query Web Part

Maarten — Tue, 26 Feb 2008 11:58:15 GMT

Hi!

I've got an issue regarding the content query webpart. I'm developing a webpart which shows newsitems filtered by audience; so users see only their local office news items. (e.g. users from our office in Amsterdam only see news articles regarding that office)

Here's the issue:

When I apply a rowfilter the following happens: e.g. when I set the rowfilter to 5 items, the Content Query Webpart selects the 5 items from the ENTIRE newsitem list. After that, the audience filter is applied.

So, e.g. if the top 5 newsitems are targeted to the Londen audience, a user in Amsterdam won't see any newsitem at all!

I've tried to apply a rowfilter on the itemstyle.xsl xsl template with no success... Does anyone have a suggestion how to solve this?

Thanks a million!

Regards,

Maarten

re: Configuring and Customizing the Content Query Web Part

ChristosK — Tue, 26 Feb 2008 12:27:28 GMT

trivial Qs:

In step 4, you change the XSLT itemstyle.

Is this XSLT bound to any instance of CQWP?

I want to use CQWP multiple times in several pages doing different things. Can i have multiple "itemstylexx.XSL" files in <styles library>?Can i use Folders in styles library??

I really wouldn't want a BIG itemstyle.xslt

Thanks

ChristosK

re: Configuring and Customizing the Content Query Web Part

Kris White — Wed, 05 Mar 2008 11:16:37 GMT

George,

My custom CQWP is working fine and the body is showing up as well. Thanks for the great tip.

Now, for my problem:

My custom CQWP is connecting to an Announcements list on anther site in my portal. The data comeup fine and when I click on the title or '(more)' links, the DispForm.aspx for the particular announcement is displayed. However, when I click on the 'Close' button on the DispForm.aspx page, I get redirected to the actual Announcement list in 'AllItems' view. What I want is to be redirected back to the page where I came from, ie. the one conataining the custom CQWP.

Do you know how I can do this?

Kris

re: Configuring and Customizing the Content Query Web Part

SIQ Max — Thu, 06 Mar 2008 21:49:07 GMT

Hi,

I have same problem as Peter Hack has, tried both OuterTemplate.FormatColumnIntoUrl and OuterTemplate.FormatValueIntoUrl

the result is same

re: Configuring and Customizing the Content Query Web Part

Ernie B — Mon, 10 Mar 2008 21:21:24 GMT

Hey,

First, I'd like to say great post! Lots of great info here. I'm currently workin on project and was able to add all the necessary fields into the CQWP. The issue i'm having is now with formatting the PublishingStartDate field. As is, the field displays as (2008-03-28 07:00:00). What i would like to do is reformat this to a more user friendly format, like (March 3, 2008) eliminating the time all together. I tried creating a template to reformat and calling the template but i'm not sure i'm doin it right. Here is my code for the templates:

{

<xsl:template name="URLwithDate" match="Row[@Style='URLwithDate']" mode="itemstyle">

<xsl:variable name="DisplayTitle">

<xsl:call-template name="OuterTemplate.GetTitle">

<xsl:with-param name="Title" select="@URL"/>

<xsl:with-param name="UrlColumnName" select="'URL'"/>

</xsl:call-template>

</xsl:variable>

<xsl:variable name="LinkTarget">

<xsl:if test="@OpenInNewWindow = 'True'" >_blank</xsl:if>

</xsl:variable>

<xsl:element name="NewDate">

<xsl:variable name="FormattedDate">

<xsl:call-template name="FormatDate">

<xsl:with-param name="DateTime" select="@PublishingStartDate"/>

</xsl:call-template>

</xsl:variable>

</xsl:element>

<xsl:call-template name="OuterTemplate.CallPresenceStatusIconTemplate"/>

<table>

<tr>

<td>

<a>

<xsl:attribute name="href">

<xsl:value-of select="substring-before($DisplayTitle,', ')">

</xsl:value-of>

</xsl:attribute>

<xsl:attribute name="title">

<xsl:value-of select="@Description">

</xsl:value-of>

</xsl:attribute>

<xsl:value-of select="substring-after($DisplayTitle,', ')">

</xsl:value-of>

</a>

</td>

<xsl:value-of select="@PublishingStartDate" />

</td>

</tr>

</table>

</div>

</xsl:template>

<xsl:template name="FormatDate">

<xsl:param name="DateTime"/>

<xsl:variable name="mo">

<xsl:value-of select="substring-before($DateTime,'/')" />

</xsl:variable>

<xsl:variable name="day-temp">

<xsl:value-of select="substring-after($DateTime,'/')" />

</xsl:variable>

<xsl:variable name="day">

<xsl:value-of select="substring-before($day-temp,'/')" />

</xsl:variable>

<xsl:variable name="year-temp">

<xsl:value-of select="substring-after($day-temp,'/')" />

</xsl:variable>

<xsl:variable name="year">

<xsl:value-of select="substring($year-temp,1,4)" />

</xsl:variable>

<xsl:choose>

<xsl:when test="$mo = '1' or $mo = '01'">January</xsl:when>

<xsl:when test="$mo = '2' or $mo = '02'">February</xsl:when>

<xsl:when test="$mo = '3' or $mo = '03'">March</xsl:when>

<xsl:when test="$mo = '4' or $mo = '04'">April</xsl:when>

<xsl:when test="$mo = '5' or $mo = '05'">May</xsl:when>

<xsl:when test="$mo = '6' or $mo = '06'">June</xsl:when>

<xsl:when test="$mo = '7' or $mo = '07'">July</xsl:when>

<xsl:when test="$mo = '8' or $mo = '08'">August</xsl:when>

<xsl:when test="$mo = '9' or $mo = '09'">September</xsl:when>

<xsl:when test="$mo = '10'">October</xsl:when>

<xsl:when test="$mo = '11'">November</xsl:when>

<xsl:when test="$mo = '12'">December</xsl:when>

</xsl:choose>

<xsl:value-of select="' '"/>

<xsl:if test="(string-length($day) < 2)">

<xsl:value-of select="0"/>

</xsl:if>

<xsl:value-of select="$day"/>

<xsl:value-of select="', '"/>

<xsl:value-of select="$year"/>

</xsl:template>

}

Any thoughts?

Thanks,

Ernie B.

re: Configuring and Customizing the Content Query Web Part

Lola — Thu, 13 Mar 2008 22:16:22 GMT

I am creating a CQWP from a calendar list. I need to show not only the name of the meeting but the link to the Workspace (which shows as a check box that you click when you create the meeting). The only thing I know about the workspace in the calendar is that the type is called a Cross Project Link. When I am in the webpart code changing the CommonViewFields, I don’t know what the hex code for that field is and I don’t know how to refer to the type=”” in the property line.

"CommonViewFields" type="string">Body_x0020_content,RichHTML</property>

Please help!!

Related to that, is there anyway I can change the type of workspace related to a calendar? Instead of being a Meeting Workspace to be a Document Workspace for example?

Thanks

Content Query Web Part - Unable to Activate the Publishing Infrastructure

The Boiler Room - Mark Kruger, Microsoft SharePoint MVP — Thu, 20 Mar 2008 00:02:03 GMT

So you want the Content Query Web Part but you're running into issues implementing it... First let

re: Configuring and Customizing the Content Query Web Part

ecmblog — Wed, 26 Mar 2008 04:31:33 GMT

Hi Maarten,

You will need to remove the item limit from the Toolpane, and then use XSLT to limit to showing only the first 5 results.

Hi ChristosK,

The out of the box Content Query Web Part [CQWP] use the three XSLT that we install.

You can modify any CQWP instances to use a different XSLT by changing one of the HeaderXslLink, ItemXslLink and MainXslLink web part property.

http://msdn2.microsoft.com/en-us/library/microsoft.sharepoint.publishing.webcontrols.cmsdataformwebpart.headerxsllink.aspx

http://msdn2.microsoft.com/en-us/library/microsoft.sharepoint.publishing.webcontrols.cmsdataformwebpart.itemxsllink.aspx

http://msdn2.microsoft.com/en-us/library/microsoft.sharepoint.publishing.webcontrols.cmsdataformwebpart.mainxsllink.aspx

Hi Kris,

You can do so by modifying the ContentQueryMain xslt and modify the CopyUtil line to pass a Source query string parameter. This Source query string will be where the user will be returned after clicking Close.

Hi SIQ Max,

You can write your own XSLT function that will strip out the description from your URL.

Hi Ernie B,

Have you tried to use the runtime function FormatDateTime:

<xsl:value-of select="ddwrt:FormatDateTime(string(@Created) ,1033 ,'dd-MM-yyyy hh:mm')" />

Hi Lola,

Go to Site Settings -> Site Columns -> Click on your column

Then check the URL of the current page, and find the field=ColumnName

This is the value you want to put inside your CommonViewFields.

Usually this will be the same as the column name.

Adri Verlaan [MSFT]

re: Configuring and Customizing the Content Query Web Part

piyush — Thu, 03 Apr 2008 17:48:16 GMT

hi to get the name of list inside the Item style.xslt

can we use

<xsl:value-of select="substring-before(substring-after(@FileRef,'Lists/'),'/')"></xsl:value-of>

re: Configuring and Customizing the Content Query Web Part

Kirsten — Thu, 10 Apr 2008 22:59:29 GMT

Hi, great post...thanks to you I was able to display an additional Status field in a Content Query Web Part. I'm having an issue with the additional filters though. I'm trying to roll-up task lists from sub-sites onto a main Project site. When I do this with no additional fields, all items are displayed. I need to filter out the Completed tasks though. I've tried setting the additional filters to Status is not equal to Completed, but when I do that I get "This query has returned no items. To configure the query for this Web Part, open the tool pane." in the web part results panel.

Any ideas for me? I'm at a loss after trying every combination I can think of. Thanks in advance for any assistance.

re: Configuring and Customizing the Content Query Web Part

Per — Wed, 16 Apr 2008 12:08:37 GMT

To Adam (post from Wednesday, March 07, 2007 1:34 AM) and who it might concern.

There is a way to retrieve the name of the list (and the name of the site) when using CQWP. I have digged deep and found a way to do this.

You need to set the ViewFieldsOverride property on the webpart and add <ListProperty Name="Title" /> and <ProjectProperty Name="Title" />. You must however also add all default fields (like Title and so on) since CQWP does not add them when ViewFieldsOverride is set.

I have a (hopefully) more clear instruction on my blog:

http://sharepoint-tweaking.blogspot.com/2008/04/displaying-listname-and-sitename-when.html

re: Configuring and Customizing the Content Query Web Part

Maria — Thu, 17 Apr 2008 07:58:44 GMT

I have only had luck with the CQWP when querying data that is associated with a content type. I can't seem to get the CQWP to work or return any results when I am just trying to query list data from a site and all of its subsites without having a content type associated. Any ideas? I am running out...

re: Configuring and Customizing the Content Query Web Part

sbendigo — Tue, 22 Apr 2008 19:50:34 GMT

All- I am using MOSS 2007 and don't have the CQWP. Is there something I have to do to enable that web part in the list?

re: Configuring and Customizing the Content Query Web Part

Saurabh — Tue, 29 Apr 2008 17:42:05 GMT

Hello EveryOne........I am using MOSS 2007......i have created a Top Level Site and created a WebPart Page in that ..... and then i Edit that WebPart Page.......but when i click on Add Web Part a window pops up but there is not option for Adding Content Query WebPart.......

plz help me out........where i m wrong.....??

Note on Customizing Content Query Web Part

Colt Kwong Blog — Sat, 17 May 2008 06:08:44 GMT

Content Query Web Part (CQWP) is a powerful feature in SharePoint, where users can create custom view

re: Configuring and Customizing the Content Query Web Part

Smith — Wed, 21 May 2008 02:15:18 GMT

currently i am able to display custom columns using CQWP, i wanted to add more... at the bottom of content query webpart, but i am getting more.... for each row items, i just need to add a more... going to separate page (this could be any page for eg www.google.com)

how to achieve this in itemstyle.xsl

some thing like this, any body had similar requirements please help

title1 description1

title2 description2

more...

re: Configuring and Customizing the Content Query Web Part

dasy — Fri, 23 May 2008 16:02:56 GMT

Great information!

I would like to be able to show a count in my web part of how many items are returned - how do I get that?

thanks!

修改MOSS内容查询WebPart的默认显示方式

莫斯 — Sun, 25 May 2008 17:15:30 GMT

在OfficeSharePointServer2007中的内容查询WebPart默认为标题列，如何以名称列显示，方法如下：

re: Configuring and Customizing the Content Query Web Part

Hector — Tue, 27 May 2008 00:42:53 GMT

Hi! Could you elaborate on this:

"Hi Tim,

or give some pointers

Thank you!

re: Configuring and Customizing the Content Query Web Part

slp — Thu, 29 May 2008 18:41:27 GMT

Do you know where you would make specifications for the width of a webpart? by default they are way to wide for my design, and i can't seem to find the style to overwite it. Any pointers?

The work at home institute.

Work at home http. — Thu, 05 Jun 2008 04:46:54 GMT

Home computer work. Work from home. Envelope stuffing work from home. Work at home. Work home time tracking software.

修改MOSS内容查询WebPart的默认显示方式

莫斯 — Sat, 07 Jun 2008 17:17:17 GMT

在Office SharePoint Server 2007中的内容查询Web Part默认为标题列，如何以名称列显示，方法如下：

re: Configuring and Customizing the Content Query Web Part

Avanti — Tue, 24 Jun 2008 09:51:05 GMT

Hi ..

Is there any way to access the ItemLimit property of the CQWP in the Itemstyle.xsl so that i can display the More link depending on the number of items that are specified in this property?

re: Configuring and Customizing the Content Query Web Part

Hani — Sat, 28 Jun 2008 15:15:01 GMT

you told Alex he can do this

how i can do?

I want to retrieve data from 7 list and they in different site, and they not child for one

Best Regards,

Hani Qasem

Displaying a presence icon in the Content Query Web Part

Christian Agerbeck's Blog — Fri, 11 Jul 2008 19:45:20 GMT

Displaying a presence icon in the Content Query Web Part

re: Configuring and Customizing the Content Query Web Part

meera — Wed, 16 Jul 2008 10:19:48 GMT

Very helpful post indeed. Have u ever tried customizing the date format in CQWP......??

When I query the Created field in a document libary the date is displayed as :

2008-07-15 14:21:01

Is there any way to change this to mm/dd/yy hh:mm format????

Please help.

Many thanx in advance

re: Configuring and Customizing the Content Query Web Part

meera — Fri, 18 Jul 2008 09:24:32 GMT

Hello,

I just want to find out if the source list name can als be dispalyed along with the items ie., if I have my CQWP crawls data from 3 document libraries in a site, is it possible to indicate which data is from which doclib as shown below .

Document 1 - doclib a

Document 2- doclib x

Document 3 - doclib p

.....and so on?????

re: Configuring and Customizing the Content Query Web Part

Rob — Fri, 18 Jul 2008 20:35:45 GMT

Hi all,

I was wondering - I have a custom column type is Person or Group.

I am having trouble getting anything to show in my CQWP. I've tried setting the field type in the CommonViewFields as Text, User, Person - but nothing seems to work. Any ideas?

thanks

re: Configuring and Customizing the Content Query Web Part

Waldek Mastykarz — Sat, 19 Jul 2008 10:44:37 GMT

It is possible to page the results of a Content Query Web Part query. Some time ago already I have wrote an article about it, plus I have published an extended version of the CQWP which supports paging. You can find more information on my blog @ http://blog.mastykarz.nl/2008/04/12/paging-content-query-web-part/

re: Configuring and Customizing the Content Query Web Part

Paul Noone — Tue, 12 Aug 2008 09:15:26 GMT

I'd like to create a Related Documents web part (as mentioned above) which will allow people to add links (with Summary Links WP or using CQWP) and display the following:

DocIcon Filename FileSize

Unfortunately, desptigin having gone to great lengths to discover these column names, they do not appear to be usable in this way.

Any suggestions on how to grab this most useful data for file lists??

re: Configuring and Customizing the Content Query Web Part

AMD — Wed, 13 Aug 2008 20:25:38 GMT

Hi,

Thanks for the great post.

I have one additional requirement. i.e. I have list with one column containing "multiple select" enabled. Column is choice type and selection is check box. With this user will be able to select multiple etnires for the row.

Now requirement is we need to extract rows which contains specific data and display the same in Content Query Web Part. For example I have one row with Sharepoint 2003 & other row with sharepoint 2003 and MOSS 2007 selected. Data query filter should be set to only extract sites wilth 2003 only.

Please advice.

Thanks in advance.

Zolpidem overdose.

Zolpidem. — Wed, 20 Aug 2008 19:08:33 GMT

Cheap zolpidem. Zolpidem ambien.

Lipitor.

Lipitor memory loss. — Fri, 22 Aug 2008 20:18:49 GMT

Lipitor and anxiety. Lipitor and its bad effects. Lipitor. Lipitor pricing. Nicain and lipitor.

re: Configuring and Customizing the Content Query Web Part

frikouflios — Thu, 04 Sep 2008 13:37:17 GMT

Hello to all, a big big thanks to George for this great article....

but i have an issue......

in the list that CQWP display i have enable the Audiences. So when i login like Admin the CQWP working fine (with my custom field everything that i was added in ItemStyle.xsl) but when i login with another account then the CQWP display the default value (only the title and not the custom field)

any ideas????

re: Configuring and Customizing the Content Query Web Part

frikouflios — Fri, 05 Sep 2008 09:58:39 GMT

Follow up to above...

OK i solve the issue..... the problem was with the permissions in Style Library. I don't know what exactly i done and if this the correct way....

my steps was

in Style Library : Settings --> Document Library Settings --> Permissions for this document library --> select all groups --> Actions --> Inherit permissions

Now i think i have a permissions issue!!! I'' do some tests and i'll inform the blog.

I'd like to know your opinion about this issue......

re: Configuring and Customizing the Content Query Web Part

jriesen — Mon, 15 Sep 2008 06:09:20 GMT

I would like to add the CQWP to my site definition based on the comments from Bisbjerg on Nov. 4 2006. I am assuming that the XML should be pasted into the Modules section of the onet.xml file. Does it need to be placed inside a CDATA section? Do I only need to grab the content starting and ending with the <webpart> tag? Or is the <webparts> tag also required? We are using MOSS 2007, if that makes any difference. Thanks in advance for your help.

re: Configuring and Customizing the Content Query Web Part

jriesen — Tue, 16 Sep 2008 17:19:14 GMT

Just as a follow-up to my message on Sept 14. I tried adding the webpart both ways and get an error.

Web Part Error: The file format is not valid. Try importing a Web Part file (.WebPart).

The trouble is that I don't want to import it. I want the page to be pre-built so the no manual intervention is required.

Is this possible?

I am not finding any helpful information on the internet in this regard.

Thanks!

re: Configuring and Customizing the Content Query Web Part

Sue — Thu, 18 Sep 2008 15:28:08 GMT

I have a CQWP that displays the current day's events from a calendar. Is there anyway to display the attachment icon for those events that do have attachements??

re: Configuring and Customizing the Content Query Web Part

Hardik — Mon, 29 Sep 2008 13:59:08 GMT

Hi , I would like to configure CQWP in such a way that it should allow me to select the products I want to display rather than displaying latest 5 products.. Is there any way to achieve that?

re: Configuring and Customizing the Content Query Web Part

Bart de Jonge — Wed, 01 Oct 2008 14:02:14 GMT

Hello Hardik,

You can add a new sitecolumn to your library (eg showonpage as a boolean).

Export the cqwp and add the new sitecolumn to the AdditionalGroupAndSortFields like this:

<property name="AdditionalGroupAndSortFields" type="string">showonpage </property> after importing you can use showonpage as a filter

hope it helps.

re: Configuring and Customizing the Content Query Web Part

SteveD — Wed, 01 Oct 2008 22:54:27 GMT

I have modified my CQWP to receive @Body. I have removed the content within < >. However, I still have " with body content. This is from users entering blogs from Word - ie. the fancy " ".

Every method I have tried to replace or truncate the " from the @Body, basically breaks the webpart, as it is removing actual quotes etc from the XML stream.

<!--

<xsl:template name="removequotes">

<xsl:param name="StringToTransform" />

<xsl:choose>

<xsl:when test="contains($StringToTransform,'"')">

<xsl:value-of select="translate($StringToTransform,'"','')" />

</xsl:when>

<xsl:otherwise>

<xsl:value-of select="$StringToTransform" />

</xsl:otherwise>

</xsl:choose>

</xsl:template>

-->

<xsl:call-template name="replace-string">

<xsl:with-param name="text" select="substring-after($text,$replace)"/>

<xsl:with-param name="replace" select="$replace"/>

<xsl:with-param name="with" select="$with"/>

</xsl:call-template>

Content Query Web Part - Field Types

Brian Caauwe — Mon, 01 Dec 2008 22:41:00 GMT

Over the last few months I have had to configure various Content Query Web Parts (CQWP) to provide portal

SharePoint - ContentQueryWebPart, CommonViewFields and Multi-value choices

John Liu's SSW Blog — Wed, 03 Dec 2008 07:46:45 GMT

When you add a choice or lookup to the CommonViewField for a ContentQueryWebPart, if you had ticked the

SharePoint :: Master Page Customize Reference

I'm small, so share nothing... — Thu, 29 Jan 2009 18:10:22 GMT

SharePoint :: Master Page Customize Reference

The Content Query Web Part, and Working With Lookup Fields in a Custom Web Part

Kirk Evans Blog — Tue, 24 Feb 2009 02:13:58 GMT

I am helping work on a proof of concept for a customer, and one of the requirements is to display data

Grouping pages on Date in SharePoint using XSL

Baris Wanschers — Thu, 09 Apr 2009 21:20:19 GMT

MOSS2007 comes with the Content Query Web Part to group and sort content as you need. This works like a charm in most situations, but sometimes I find most common things missing. Lately I was working on a news archive for a company who posts a lot of

Democratization of IT: Creating WebParts for SharePoint Without IT Operations

Kirk Evans Blog — Mon, 15 Jun 2009 17:46:19 GMT

I've had several conversations with customers lately about creating some type of gadget gallery for their

Configuring and Customizing the Content Query Web Part

re: Configuring and Customizing the Content Query Web Part

re: Configuring and Customizing the Content Query Web Part

re: Configuring and Customizing the Content Query Web Part

re: Configuring and Customizing the Content Query Web Part

re: Configuring and Customizing the Content Query Web Part

Configuring and customizing the Content Query Web Part

re: Configuring and Customizing the Content Query Web Part

re: Configuring and Customizing the Content Query Web Part

re: Configuring and Customizing the Content Query Web Part

re: Configuring and Customizing the Content Query Web Part

re: Configuring and Customizing the Content Query Web Part

re: Configuring and Customizing the Content Query Web Part

Building tylerbutler.com, Part 2: Building Content Types and Page Layouts

re: Configuring and Customizing the Content Query Web Part

Recommended reading for November

re: Configuring and Customizing the Content Query Web Part

re: Configuring and Customizing the Content Query Web Part

re: Configuring and Customizing the Content Query Web Part

re: Configuring and Customizing the Content Query Web Part

re: Configuring and Customizing the Content Query Web Part

re: Configuring and Customizing the Content Query Web Part

re: Configuring and Customizing the Content Query Web Part

re: Configuring and Customizing the Content Query Web Part

re: Configuring and Customizing the Content Query Web Part

re: Configuring and Customizing the Content Query Web Part

re: Configuring and Customizing the Content Query Web Part

re: Configuring and Customizing the Content Query Web Part

Customizing the Content Query Web Part and Custom Item Styles

re: Configuring and Customizing the Content Query Web Part

re: Configuring and Customizing the Content Query Web Part

re: Configuring and Customizing the Content Query Web Part

re: Configuring and Customizing the Content Query Web Part

re: Configuring and Customizing the Content Query Web Part

re: Configuring and Customizing the Content Query Web Part

re: Configuring and Customizing the Content Query Web Part

re: Configuring and Customizing the Content Query Web Part

re: Configuring and Customizing the Content Query Web Part

Customização da Content Query Web Part

re: Configuring and Customizing the Content Query Web Part

MOSS2007 – Content Query Web Part Step by Step Basic Styling

re: Configuring and Customizing the Content Query Web Part

re: Configuring and Customizing the Content Query Web Part

re: Configuring and Customizing the Content Query Web Part

re: Configuring and Customizing the Content Query Web Part

re: Configuring and Customizing the Content Query Web Part

re: Configuring and Customizing the Content Query Web Part

re: Configuring and Customizing the Content Query Web Part

re: Configuring and Customizing the Content Query Web Part

re: Configuring and Customizing the Content Query Web Part

re: Configuring and Customizing the Content Query Web Part

re: Configuring and Customizing the Content Query Web Part

re: Configuring and Customizing the Content Query Web Part

re: Configuring and Customizing the Content Query Web Part

re: Configuring and Customizing the Content Query Web Part

re: Configuring and Customizing the Content Query Web Part

re: Configuring and Customizing the Content Query Web Part

re: Configuring and Customizing the Content Query Web Part

re: Configuring and Customizing the Content Query Web Part

re: Configuring and Customizing the Content Query Web Part

re: Configuring and Customizing the Content Query Web Part

re: Configuring and Customizing the Content Query Web Part

re: Configuring and Customizing the Content Query Web Part

re: Configuring and Customizing the Content Query Web Part

re: Configuring and Customizing the Content Query Web Part

re: Configuring and Customizing the Content Query Web Part

re: Configuring and Customizing the Content Query Web Part

re: Configuring and Customizing the Content Query Web Part

re: Configuring and Customizing the Content Query Web Part

re: Configuring and Customizing the Content Query Web Part

re: Configuring and Customizing the Content Query Web Part

re: Configuring and Customizing the Content Query Web Part

re: Configuring and Customizing the Content Query Web Part

re: Configuring and Customizing the Content Query Web Part

re: Configuring and Customizing the Content Query Web Part

re: Configuring and Customizing the Content Query Web Part

re: Configuring and Customizing the Content Query Web Part

re: Configuring and Customizing the Content Query Web Part

re: Configuring and Customizing the Content Query Web Part

re: Configuring and Customizing the Content Query Web Part