Subclassing Content Query Web Part to override CAML query

re: Subclassing Content Query Web Part to override CAML query

Michael — Tue, 24 Nov 2009 21:31:44 GMT

The way to achieve this is to control the CAML query you overried in your subslassed CQWP

re: Subclassing Content Query Web Part to override CAML query

Carl — Tue, 24 Nov 2009 17:13:05 GMT

Can you provide more details on filtering content in content query. I have enabled the connection on content query webpart and reading the providers field values and i want to filter the content of the content query webpart.

Thanks in advance.

re: Subclassing Content Query Web Part to override CAML query

Mohamed Hachem — Tue, 15 Sep 2009 19:54:35 GMT

Hello

To achieve Orderby and where statment in content query web part

you have two ways :

static way writing query in the the actual webpart xml as follows:

<property name="QueryOverride" type="string"><![CDATA[<OrderBy><FieldRef Name='MomoOrder' Nullable='True' Type='Number' Ascending='True'/></OrderBy> <Where><Eq><FieldRef Name='Project'/><Value Type='LookupMulti'>Nelson</Value></Eq></Where>]]></property>

Dynamic Way, is done by creating class that inherits from sharepoint content query webpart, you override

protected override void CreateChildControls()

{

this.QueryOverride = customQueryOverride;

base.CreateChildControls();

this.QueryOverride = string.Empty;

this.CommonViewFields = string.Empty;

}

public override void ApplyChanges()

{

base.ApplyChanges();

// LabelValue is the value of the custom label

// that you added while constructing webpart

// to had ordering or filtering value

customQueryOverride= "<OrderBy><FieldRef Name='ListOrder' Nullable='True' Type='Number' Ascending='True'/></OrderBy><Where><Eq><FieldRef Name='Project' /><Value Type='LookupMulti'>" + LabelValue + "</Value></Eq></Where>";

}

Cheers

re: Subclassing Content Query Web Part to override CAML query

Michael — Sun, 21 Jun 2009 21:34:40 GMT

http://tinyurl.com/nuwzf4

re: Subclassing Content Query Web Part to override CAML query

sudha — Sun, 21 Jun 2009 16:22:29 GMT

please suggest me the approch that suits to my requirement. can you please send the sample code.

re: Subclassing Content Query Web Part to override CAML query

sudha — Sun, 21 Jun 2009 16:15:55 GMT

First time i am working on CQWP customization.

One more question i have,

How to expose the new properties like grouping and sorting.. how to use the newly exposed property in CAML query..

Not able to open this link, please send the full URL.

re: Subclassing Content Query Web Part to override CAML query

Michael — Sun, 21 Jun 2009 15:39:40 GMT

Where exactly you stuck?

You just read the user's properties from AD and then construct you CAML query to include that country.

See this sample www.helloitsliam.com/.../moss2007-–-redirect-using-profile-property-and-sharepoint-list.aspx

re: Subclassing Content Query Web Part to override CAML query

sudha — Sun, 21 Jun 2009 15:28:51 GMT

Michael, i am really waiting for your answer. please help me out.

thanks..

re: Subclassing Content Query Web Part to override CAML query

sudha — Sun, 21 Jun 2009 12:57:29 GMT

Our company employees located in Geographical areas(USA,UK,INDIA).

User profiles are dumped from AD to sharepoint.

that has a property named as Region holds the User Region. Ex: USA,UK,INDIA

I have news Document libray containing news articles and has one field named region, which indicated this artical related to that perticular region.

Ex: USA,UK,INDIA

i want to display the news articals based on loggedIN user region by pulling the region from user profile and map it with the field region of news artical located at news document librey.

i want to customize the CQWP. plese help me out.

re: Subclassing Content Query Web Part to override CAML query

Michael — Sun, 21 Jun 2009 12:37:56 GMT

What are the requirements to the "region" detection?

Do you want to detect it by IP - where user physically locates (but what to do in case of working over proxy or being in business trip),

or you want to detect the region based on the user's localizations settings?

See these links

1) www.west-wind.com/.../334.aspx

2) forums.asp.net/.../1052219.aspx

re: Subclassing Content Query Web Part to override CAML query

sudha — Sun, 21 Jun 2009 12:07:34 GMT

i want to display the items in CQWP based on logged in user region.

ex:

if logged in user belongs to Middel East, i want to display Middle East related news articals to the user.

user profile property holds the user Region and news artical has the field named as region.

i want to map these and display the related news articles.

Please help me out. thanks in advance.

re: Subclassing Content Query Web Part to override CAML query

Michael — Tue, 21 Apr 2009 05:33:30 GMT

I posted the code-snippet, what means that you need to write the additional code.

1) _filterProviders - please read a commends for the line 8. It says how to declare that variable

2) providerValues - check what filterProvider.ParameterValues returs, and create such field

re: Subclassing Content Query Web Part to override CAML query

Tee — Tue, 21 Apr 2009 05:21:15 GMT

Hi Micheal, I tried your code; however, I got the error when I compile it, here is the errors:

The name 'providerValues' does not exist in the current context

The name '_filterProviders' does not exist in the current context

It seems that it does not recognize these variables:

providerValues

_filterProviders

Could you tell me what need to be fixed to eliminate these errors. Thanks for your help, here is my code:

[skipped]

re: Subclassing Content Query Web Part to override CAML query

Michael — Wed, 24 Dec 2008 11:16:35 GMT

Nope. You need either to disable the cache or don't use checkout items.

Actually, it's not only checkout items, but items which are not published yet, are out of the CQWP results in standard mode. We had such issue before :)

I found this behavior very logical. Because checked items and not published items are private items, which are in work now, and you should not expose those data in most of cases.

So, just disable cache or revise your approach for shown data in CQWP

re: Subclassing Content Query Web Part to override CAML query

Haitao — Wed, 24 Dec 2008 07:50:37 GMT

My root CAML element is <Where>. So, the complete CAML is: "<Where><Eq><FieldRef Name='Author' LookupID='True' /><Value Type='User'><UserID /></Value></Eq></Where>".

I used this CAML in a SPQuery object. Then I tried to get items from a custom list with this SPQuery object. The fact is that this CAML works perfectly to filter all the items created by the current user in both edit mode and normal mode. So, I guess this problem is something related to CQWP only.

I googled lots of pages and found one post saying that the caching infrastructure of the CQWP does not cache checked-out items of individual users and we disable cache in edit mode. By following his suggestion, I set the UseCache property of the CQWP to false. This way, it works :)

Now, the problem is disabling the cache of CQWP because I don't think this is the right way of doing things. Do you have any ideas on this? Is there is another way of writting the CAML so that we can work around the cache issue?

re: Subclassing Content Query Web Part to override CAML query

Michael — Tue, 16 Dec 2008 12:14:46 GMT

Where is your root <Query> element for CAML?

re: Subclassing Content Query Web Part to override CAML query

Haitao — Fri, 12 Dec 2008 16:34:32 GMT

Hi Micheal,

I have created a subclass of CBQ web part and enable my CBQ's subclass with the ability of using custom CAML. Recently, I want to use a custom CAML which filters all the list item of created by the current user. The CAML is like

"<Eq><FieldRef Name='Author' LookupID='True' /><Value Type='User'><UserID /></Value></Eq>"

The problem is, when the page is in edit mode, the CAML works perfectly. But when I exit the edit mode, it cannot returieve any item out.

What probably is the problem? Can you give me any help?