CAML Query Issue A or B and C

Question

I'm trying to write a CAML query with the following parameters and I'm not having much luck. It should be simple enough but I can't figure it out.

WHERE (X) EQUALS (A or B) And C

I'm hoping someone might be able to point me in the right direction. Thanks in advance.

Answer 1

You should write query like below:

<Where>
   <And>
      <Or>
         <Eq><FieldRef Name="X" /><Value Type="Text">A</Value></Eq>
         <Eq><FieldRef Name="X" /><Value Type="Text">B</Value></Eq>
     </Or>
     <Eq><FieldRef Name="X" /><Value Type="Text">C</Value></Eq>
  </And>
</Where>

Also, try using some CAML Query Builders that will help you:
CAML Query Tools suggested by Microsoft
Caml Query Helper
U2U CAML Query Builder

Answer 2

The basic structure you want will be something like:

<Query>
   <Where>
      <And>
         <Or>
            <Eq>
                A
            </Eq>
            <Eq>
                B
            </Eq>
         </Or>
         <Eq>
             C
         </Eq>
      </And>
   </Where>
</Query>

A, B, and C will each be a <FieldRef /> and <Value></Value> set.

Hope that makes sense.

Edit

As Arsalan suggested, Karine Bosch's U2U Caml Builder for 2003 and 2007 is available here. It makes building the structure of more complex queries a lot easier.

To use it with SP 2010 (unsure about 2013) you can connect via web services as seen here.