CAMLQuery with multiple and/or

Question

I want to be able to check if (1 = 1) AND (2=2 OR 3=3)

this is the following code i've tried so far:

"<View>" +
"<Query>" +
"<Where>" +
"<And>" +
"<Eq><FieldRef Name='Title'/><Value Type='Text'>" + namn + "</Value></Eq>" +
"<Or>" +
"<Eq><FieldRef Name='Prioritet'/><Value Type='Text'>Hög</Value></Eq>" +
"<Eq><FieldRef Name='Status'/><Value Type='Text'>Startad</Value></Eq>" +
"</Or>" +
"</And>" +
"</Where>" +
"</Query>" +
"</View>");

Please put parenthesis in what you want to check. It's not possible to provide answer as it differs whether you want to do "(1 = 1 and 2=2) or 3=3" or "1 = 1 and (2=2 or 3=3)". Currently your query does "1 = 1 and (2=2 or 3=3)". — Jussi Palo
– Jussi Palo, Commented Jun 4, 2015 at 8:53
It looks good to me, you getting some error that query is malformed, or not the desired result? — Jussi Palo
– Jussi Palo, Commented Jun 4, 2015 at 8:55
@JussiPalo Failed to load resource: The server responded with a status of 403(forbidden) — Dr Cox
– Dr Cox, Commented Jun 4, 2015 at 9:03

users1100 · Accepted Answer · 2015-06-04 09:24:54Z

0

Remove the view and query tags from the CAML, are you facing any error?

 "<Where>" +
"<And>" +
"<Eq><FieldRef Name='Title'/><Value Type='Text'>" + namn + "</Value></Eq>" +
"<Or>" +
"<Eq><FieldRef Name='Prioritet'/><Value Type='Text'>Hög</Value></Eq>" +
"<Eq><FieldRef Name='Status'/><Value Type='Text'>Startad</Value></Eq>" +
"</Or>" +
"</And>" +
"</Where>"

edited Jun 4, 2015 at 9:24

users1100

3,2307 gold badges63 silver badges116 bronze badges

answered Jun 4, 2015 at 9:04

Akshay Randive

2,8851 gold badge18 silver badges31 bronze badges

Add a comment |

Stack Exchange Network

CAMLQuery with multiple and/or

1 Answer 1

Your Answer

Hot Network Questions

CAMLQuery with multiple and/or

1 Answer 1

Your Answer

Sign up or log in

Post as a guest

Related

Hot Network Questions