0

I am wondering if the following CAML query structure is correct: I appreciate your help.

<Query>
  <CalendarDate><Today/></CalendarDate>
  <Where>
    <And>
      <And>
        <IsNotNull>
          <FieldRef Name="Unit" />      
        </IsNotNull>
      </And>    
      <DateRangesOverlap>
        <FieldRef Name="EventDate" />
        <FieldRef Name="EndDate" />
        <FieldRef Name="RecurrenceID" />
        <Value Type="DateTime">
          <Today />
        </Value>
      </DateRangesOverlap>
    </And>
    <And>
      <IsNotNull>
        <FieldRef Name="Primary_x0020_Expertise" />              
      </IsNotNull>
      <Or>
        <IsNotNull>
          <FieldRef Name="Secondary_x0020_Expertise" />
        </IsNotNull>
      </Or>
    </And>
  </And>
  </And>
  </Where>
  <OrderBy>
    <FieldRef Name="EventDate" />
  </OrderBy>
</Query>

CAMLQueryOptions:
<QueryOptions>
  <CalendarDate><Today/></CalendarDate>
  <RecurrencePatternXMLVersion>v3</RecurrencePatternXMLVersion>
  <ExpandRecurrence>TRUE</ExpandRecurrence>
</QueryOptions>
1
  • I have read people using caml query builder, may be for you also it might help. Commented Nov 19, 2013 at 4:49

1 Answer 1

0

Is this the complete CAML query?

There seems to be two extra </And> before </Where>

If you can share your List structure (with data types), then I can try it from my end.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.