Needed help to build caml Query with multiple

Question

I am getting a query from list view by view.Query i got the following

<QUERY><GroupBy Collapse="TRUE" GroupLimit="100"><FieldRef Name="AlertGrp" /></GroupBy>       <OrderBy><FieldRef Name="PriorityNoLink" Ascending="FALSE" /><FieldRef Name="match_time"   Ascending="FALSE" /></OrderBy><Where><And><And><And>
<Neq><FieldRef Name="Category" /><Value Type="Text">ACH Alert</Value></Neq>
<Neq><FieldRef Name="Category" /><Value Type="Text">Check Fraud</Value></Neq>
</And>
<IsNull><FieldRef Name="Close_x0020_Reason" /></IsNull></And>
<Eq><FieldRef Name="AlertType" /><Value Type="Text">Alert</Value></Eq>
</And>
</Where></QUERY>

I want to add one more condition something like

<Geq><FieldRef Name="Created" /><Value Type="DateTime"><Today OffsetDays="-5" />    </Value></Geq>

I added after AlertType

<Eq><FieldRef Name="AlertType" /><Value Type="Text">Alert</Value></Eq>
</And>

and start tag < And> added in the beginning along with "< And>< And>< And>"

But showing wrong result. Kindly help me where i can add the new condition.

regards jhanani

By the way, you can use "[CAML Builder][1]" to construct your CAML query :-) [1]: http://sharepoint.stackexchange.com/questions/72164/where-can-i-download-the-u2u-caml-query-builder-for-sharepoint-2010/72165#72165 — AymKdn, Jul 31 '13 at 18:22
After upgrade my version now am able to get the correct lis view query.Now pls tell me where to add New condition And>Check FraudAlert — user2518802, Aug 05 '13 at 11:22
Use Caml Builder to build your CAML syntax (see my previous comment) — AymKdn, Aug 05 '13 at 14:19

score 1 · Answer 1 · answered Jul 31 '13 at 11:06

1

All your filters will be AND?

Try This:

<Where>
  <And>
    <And>
      <And>
        <And>
          <Neq>
            <FieldRef Name="Category" />
            <Value Type="Text">ACH Alert</Value>
          </Neq>
          <Neq>
            <FieldRef Name="Category" />
            <Value Type="Text">Check Fraud</Value>
          </Neq>
        </And>
        <IsNull>
          <FieldRef Name="Close_x0020_Reason" />
        </IsNull>
      </And>
      <Geq>
        <FieldRef Name="Created" />
        <Value Type="DateTime"><Today OffsetDays="-5" />
        </Value>
      </Geq>
    </And>
    <Eq>
      <FieldRef Name="AlertType" />
      <Value Type="Text">Alert</Value>
    </Eq>
  </And>
</Where>

answered Jul 31 '13 at 11:06

Tiago

2,156
2
18
27

Hi sorry for the late reply. just now i upgrade the site and got the exact query. Please let me know where can i addd one more condtion – user2518802 Aug 05 '13 at 10:20
And>Check FraudAlert where to add new condition " " – user2518802 Aug 05 '13 at 10:31
I got the correct query of list view now (after creating new site), kindly help me in the above query where to add Created codition – user2518802 Aug 05 '13 at 10:36
your query would be this: Name="AlertType" />Alert me="Created" /> – Tiago Aug 05 '13 at 13:18

Needed help to build caml Query with multiple

1 Answers1