Caml Query for "Contain ALL Of" or "Contains Any Of"

Question

So as an example let’s take the Title field and assume i want to set up a web part to display documents related to the search term American Civil War.

The contains all of option would let me display documents that had all 3 words in the title i.e. the implied condition would be American AND Civil AND War
The contains any of option would give me any document where any of those words appear i.e. American OR Civil OR War

Both of these would be irrespective of the order of the words or any additional words that appeared

I need to create caml query in sharepoint 2010? Is there a direct way or better way to handle this above scenario?

tomasdeml · Answer 1 · 2013-08-15T06:56:11.520

1

I'm afraid you will have to create multiple AND clauses with CONTAINS operator to achieve the desired contains ALL of behaviour. The same applies to multiple OR clauses with CONTAINS operator needed to archieve the contains ANY of behaviour.

edited Aug 15 '13 at 06:56

answered Aug 14 '13 at 17:40

tomasdeml

339
2
7

Yes i have done in the same way, you have suggested, but OR clauses seems to give wrong results some times.. – user1899731 Aug 14 '13 at 18:37
@user1899731 What do you mean by wrong results? I have never experienced the OR clause to misbehave. – tomasdeml Aug 14 '13 at 19:15

Caml Query for "Contain ALL Of" or "Contains Any Of"

1 Answers1