Version française
Home     About     Download     Resources     Contact us    
Browse thread
A question about bitwise AND in a CAML SharePoint query
[ Home ] [ Index: by date | by threads ]
[ Search: ]

[ Message by date: previous | next ] [ Message in thread: previous | next ] [ Thread: previous | next ]
Date: -- (:)
From: Vince Yotsukura <vyotsukura@q...>
Subject: A question about bitwise AND in a CAML SharePoint query
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