"does not contain" in CAML?

sharepoint caml listitem
user4531 picture user4531 · Dec 4, 2008 · Viewed 15.2k times · Source

In CAML I can query SharePoint Listitems using the "Contains"-element, but there is no "does not contain"-element I could use.

So what is the best way to get the items that do not contain a string? Is there a better way than to loop through each and every item?

Answer

Michael Stum picture Michael Stum · Dec 4, 2008

The same restriction applies to BeginWith. I do not know any good solution sadly. What you could do: Do a Contains-Query, loop through each item and get the IDs, then do another big query for "ID NotEqual 1 or ID NotEqual 2 or ID NotEqual 3......" Since ID is indexed as far as I know, that should have a smaller impact on the database, but it still smells really bad.

For small list it does not matter, for larger lists i'd use the SQL Server Profiler to see what the impact is.

Related questions

CAML query with nested ANDs and ORs for multiple fields

I am working on proof-of-concept code to dynamically generate CAML based on keywords provided to a highly-specific search web service that I am writing. I am not using the SharePoint-provided search web service for this proof. I have done so …

Read More
One or more field types are not installed properly. Go to the list settings page to delete these fields

CamlQuery query = new CamlQuery(); query.ViewXml = @"<View>" + "<Query>" + "<Where><Eq><FieldRef Name='Name' /><Value Type='Text'>" + fileName + "</Value>" + "</Eq>" + "</Where>" + "</Query&…

Read More
Getting list item field values from a SP List using Client Object Model

What is the optimal way to get a list items and their properties from a SP list using Client object model? Here is the code I'm using. string server = "http://localhost"; ClientContext context = new ClientContext(server); Web web = context.Web; …

Read More