SharePoint list CAML query using CONTAINS

sharepoint wss caml
Ali_Abadani picture Ali_Abadani · Dec 8, 2009 · Viewed 53.4k times · Source

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();

Answer

Colin picture Colin · Dec 8, 2009

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.

Related questions

Sharepoint Deleting an Item from a list using UpdateListItems WebService

I am trying to delete an item from a list and have the following xml <Batch PreCalc='TRUE' OnError='Continue'> <Method ID='1' Cmd='Delete'>\ <Field Name='ID'>185</Field> </Method&…

Read More
Update Sharepoint List Item

I got following error... System.NullReferenceException: Object reference not set to an instance of an object. at Microsoft.SharePoint.SPListItem.get_UniqueId() at ConsoleApplication1.Program.Main(String[] args) in Program.cs:line 21 running following code using (SPSite site = new SPSite("…

Read More
SharePoint interview questions

Let's have a list of some good interview questions for SharePoint developers. Please provide one question per entry, and if possible, the answers. Also, please feel free to suggest corrections if the provided answers are wrong. I will go first: …

Read More