Content Query Web Part - query data w/special characters

Site Home | Login | Membership Signup

Maximizing Your Success with Microsoft SharePoint Technologies

DFW SharePoint User Group

Home

Members

Calendar

Who's On

Welcome Guest ( Login | Register )

Content Query Web Part - query data w/special...

Rate Topic

Display Mode

Topic Options

Author

Message

jmgscott

Posted 1/15/2008 11:45:42 AM

Forum Newbie

Group: Forum Members
Last Login: 11/12/2008 10:41:12 AM
Posts: 6, Visits: 31

I've managed to customize the CQWP to add columns to the Group & Filter drop-downs based on columns custom to the list. I am also aware of the requirement that when you have a special character, like a space, in a column, that must be replaced by "_x0020_" in the column name when referencing it in the .webpart file.

My problem is when performing a query on one of these columns in the 'Additional Filters' section when the data contains a special character. For instance, I have a column called 'Region' which is attached to a menu where "US/Canada" is one of the options. I select 'Region' from the filter menu and select "is equal to" and put "US/Canada" (without the quotes) in the text field. Every time I get a "This query has returned no items..." when I know for a fact a valid item exists.

Is there some sort of bug or requirement that data being queried through the CQWP cannot contain special characters either? I tried all sorts of variations "US Canada", "USCanada", even tried replacing with unicode like the column name, "US_x002f0_Canada"...nothing seems to work.

Thanks in advance for any suggestion.

-James

Post #129