SharePoint list CAML query using CONTAINS

Question

I'm trying to query a SharePoint list using the following CAML query in a webpart. I have tested the query in U2U CAML Query Builder and Stramit CAML Viewer and it works fine, only returning the matching records, but when I use it in my webpart it return all list items. It is driving me crazyyyyy. Here is the code:

string camlQuery = string.Format(@"<Query><Where><Contains><FieldRef Name='Title' /><Value Type='Text'>2</Value></Contains></Where></Query>"); SPQuery query = new SPQuery(); query.Query = camlQuery; SPListItemCollection items = Articles.GetItems(query); grid.DataSource = items.GetDataTable(); grid.DataBind();

Colin · Accepted Answer · 2009-12-08 22:58:57Z

25

Leave out the surrounding Query tag, just use:

<Where><Contains><FieldRef Name='Title' /><Value Type='Text'>2</Value></Contains></Where>

SPQuery adds the Query tag itself.

answered Dec 8, 2009 at 22:58

Colin

10.6k30 silver badges36 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Colin Over a year ago

I know... :-P. glad to be of help.

Collectives™ on Stack Overflow

SharePoint list CAML query using CONTAINS

1 Answer 1

1 Comment

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Linked

Related