Hello,

 

I would like to subscribe to the CAML mailing list and ask the following question:

 

Is there a way to include a bitwise AND operator in a CAML query? I am trying to retrieve items from a SharePoint document library and I want to retrieve items which have particular bitwise values in an integer field for the library. For example, I have an int field called DOCSTATUS which holds various bitwise values and I want to write a CAML query on DOCSTATUS that would be equivalent to the SQL query below:

WHERE (DOCSTATUS & 8 = 0)
   AND
(DOCSTATUS & 1 = 1)

 

Thank you very much.

 

Vince Yotsukura
Software Engineer
Quadel Consulting Corporation
1200 G Street NW, Suite 700
Washington, DC 20005
Main: (202) 789-2500
Direct: (202) 513-6532
Fax: (202) 898-0632
www.quadel.com