CAMLquery nested AND

Question

I want to get all the items from my list, like this (A&B) AND (C&D), but my CAMLquery doesn't seem to work, here is what I've tried so far:



var camlQuery = new SP.CamlQuery();
    camlQuery.set_viewXml(
"<View>" +
"<Query>" +
"<Where>" +
"<And>" +
"<And>" +
"<Eq><FieldRef Name='Prioritet'/><Value Type='Text'>A</Value></Eq>" +
"<Eq><FieldRef Name='Status'/><Value Type='Text'>B</Value></Eq>" +
"</And>" +
"<And>" +
"<Eq><FieldRef Name='Prioritet'/><Value Type='Text'>C</Value></Eq>" +
"<Eq><FieldRef Name='Status'/><Value Type='Text'>D</Value></Eq>" +
"</And>" +
"</And>" +
"</Where>" +
"</Query>" +
"</View>");

This won't work since this CAML query is checking if the column Prioritet and Status have 2 different values in an item i.e. it's checking if Prioritet has values A and C for the same item which is impossible. I'd suggest reformulating your query. — Akhoy
– Akhoy, Commented Aug 10, 2015 at 14:36
as say @uberz91, this should be Or instead an AND For example: <Or><And></And><And></And></Or> — Marco
– Marco, Commented Aug 10, 2015 at 14:49

WantToDo · Accepted Answer · 2016-07-27 11:41:16Z

-1

the syntax is each < and> statement content 2 queries.

section <and> is one query in another <and> statement

change the query to:

"<View>" +
  "<Query>" +
    "<Where>" +
        "<And>" +
            "<And>" +
                "<And>" + <------first
                    "<Eq><FieldRef Name='Prioritet'/><Value Type='Text'>A</Value></Eq>" + <----- 1
                    "<Eq><FieldRef Name='Status'/><Value Type='Text'>B</Value></Eq>" + <------2
                "</And>" +
                "<Eq><FieldRef Name='Prioritet'/><Value Type='Text'>C</Value></Eq>" + <----- second
            "</And>" +
            "<Eq><FieldRef Name='Status'/><Value Type='Text'>D</Value></Eq>" +
        "</And>" +
    "</Where>" +
  "</Query>" +
"</View>"

answered Jul 27, 2016 at 11:41

WantToDo

1961 gold badge1 silver badge10 bronze badges

The query syntax is correct. Main <And> contains two child <And> tags, and both child tags contain two <Eq> tags. Only problem is in contradictory conditions which your answer doesn't fix.

dstarkowski
– dstarkowski

2016-07-27 12:30:35 +00:00
Commented Jul 27, 2016 at 12:30

Add a comment |

Stack Exchange Network

CAMLquery nested AND

1 Answer 1

Your Answer

Hot Network Questions

CAMLquery nested AND

1 Answer 1

Your Answer

Sign up or log in

Post as a guest

Related

Hot Network Questions