Home > CMS- Content Management System > How to write Complex CAML Query with Nested AND Conditions

How to write Complex CAML Query with Nested AND Conditions

Ranjit Pokale CMS- Content Management System, Sharepoint 0

1 Condition CAML query

One and caml query
1
2
3
4
5
6
7
8
<Query>
<Where>
<And>
<Eq><FieldRef Name='Month'/><Value Type='Text'>July</Value></Eq>
</And>
</Where>
<Query>

2 Condition CAML query

1
2
3
4
5
6
7
8
9
<Query>
<Where>
<And>
<Eq><FieldRef Name='Month'/><Value Type='Text'>July</Value></Eq>
<Eq><FieldRef Name='Year'/><Value Type='Text'>2017</Value></Eq>
</And>
</Where>
<Query>

3 Condition CAML query

Note: We can use two conditions only with in Operator

1
2
3
4
5
6
7
8
9
10
11
<Query>
<Where>
<And>
                        <Eq><FieldRef Name='Title'/><Value Type='Text'>Demo Page</Value></Eq>
<And>
                                <Eq><FieldRef Name='Month'/><Value Type='Text'>July</Value></Eq>
<Eq><FieldRef Name='Year'/><Value Type='Text'>2017</Value></Eq>
</And>
</And>
</Where>
<Query>

4 Condition CAML query

1
2
3
4
5
6
7
8
9
10
11
12
13
14
<Query>
<Where>
<And>
                     <Contains><FieldRef Name='PageUrl' /><Value Type='Url'>WWW.MSN.COM</Value></Contains>
     <And>
                          <Eq><FieldRef Name='Title'/><Value Type='Text'>Demo Page</Value></Eq>
  <And>
                               <Eq><FieldRef Name='Month'/><Value Type='Text'>July</Value></Eq>
       <Eq><FieldRef Name='Year'/><Value Type='Text'>2017</Value></Eq>
  </And>
      </And>
</And>
</Where>
<Query>

5 Condition CAML query

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
<Query>
<Where>
<And>
                     <Eq><FieldRef Name='Title'/><Value Type='Text'>Demo Page</Value></Eq>
     <And>
                          <Contains><FieldRef Name='URL' /><Value Type='Text'>WWW.MSN.COM</Value></Contains>
  <And>
                               <Eq><FieldRef Name='Month'/><Value Type='Text'>July</Value></Eq>
<And>
     <Eq><FieldRef Name='Quarter'/><Value Type='Text'>Q1</Value></Eq>
     <Eq><FieldRef Name='Year'/><Value Type='Text'>2017</Value></Eq>
</And>
</And>
    </And>
      </And>
</Where>
</Query>

 

This Article is TAGGED in , , . BOOKMARK THE permalink.

Avatar photo
Ranjit Pokale

Related articles

How to Set Value in URL column using SharePoint 2013 Designer Workflow

URL column type is consists of two part, one is Actual URL

Custom validation on default list form in SharePoint 2013

In SharePoint, there is requirement where we need to apply custom validation

Sample search term query’s of result search web part

Sample search term query's to search result through result search web part Search

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code class="" title="" data-url=""> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong> <pre class="" title="" data-url=""> <span class="" title="" data-url="">