CODEWITHSUNDEEP
sharepointwindows-sharepoint-servicescaml
c_y
c_y

Reputation: 560

CAML Query with Contains and Or Clause Issue

What I want to achieve : Take a keyword array as input and query Sharepoint List to return all rows which contain the keywords in the list.

I have built a simple CAML query to query my list with one keyword (pdf) . 

<Query><Where><Contains><FieldRef Name='Keyword'/><Value Type='Text'>pdf</Value></Contains></Where></Query>

This works fine.

But, when I try to use Or clause in the CAML query(see below), I get the following error

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

<Query><Where><Or><Contains><FieldRef Name='Keyword'/><Value Type='Text'>pdf</Value></Contains></Or></Where></Query>

I googled for the syntax and everything looks good. Please let me know what is missing.

Thanks in advance.

Upvotes: 1

Views: 8276

Answers (2)

zen00
zen00

Reputation: 1

The field reference name must be the internal name. You can find this by going to the colmn page in list/library settings and the name is the end of the URL. Spaces and underscores in the name must be handled differently.

Upvotes: 0

bhargava
bhargava

Reputation: 16

In CAML Query if you want to use OR you must and should have 2 conditions.

Upvotes: 0

Related Questions