From mboxrd@z Thu Jan 1 00:00:00 1970 Return-Path: Received: from mail2-relais-roc.national.inria.fr (mail2-relais-roc.national.inria.fr [192.134.164.83]) by yquem.inria.fr (Postfix) with ESMTP id 6DFD7BC37 for ; Thu, 14 Jan 2010 18:35:50 +0100 (CET) X-IronPort-Anti-Spam-Filtered: true X-IronPort-Anti-Spam-Result: AooAAArlTktAEgMakWdsb2JhbACCFplhAQEBAQkLCgcTBbEYCYs+gkaBagQ X-IronPort-AV: E=Sophos;i="4.49,276,1262559600"; d="scan'208,217";a="41458809" Received: from exprod8og113.obsmtp.com ([64.18.3.26]) by mail2-smtp-roc.national.inria.fr with SMTP; 14 Jan 2010 18:35:48 +0100 Received: from source ([64.213.197.136]) by exprod8ob113.postini.com ([64.18.7.12]) with SMTP ID DSNKS09V8zDAQoOLA1Nkme453c+jGpEPkCrg@postini.com; Thu, 14 Jan 2010 09:35:49 PST X-MimeOLE: Produced By Microsoft Exchange V6.5 Content-class: urn:content-classes:message MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01CA953F.E7F87FC2" Subject: A question about bitwise AND in a CAML SharePoint query Date: Thu, 14 Jan 2010 12:35:04 -0500 Message-ID: X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: A question about bitwise AND in a CAML SharePoint query Thread-Index: AcqVP+gR0Up7ql9FSquuwJvdceb/eg== From: "Vince Yotsukura" To: X-Spam: no; 0.07; sharepoint:98 sharepoint:98 333333:98 333333:98 integer:01 integer:01 int:01 int:01 caml:02 caml:02 arial:96 arial:96 library:03 library:03 1200:94 This is a multi-part message in MIME format. ------_=_NextPart_001_01CA953F.E7F87FC2 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable Hello,=20 =20 I would like to subscribe to the CAML mailing list and ask the following question:=20 =20 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:=20 WHERE (DOCSTATUS & 8 =3D 0) AND=20 (DOCSTATUS & 1 =3D 1) =20 Thank you very much.=20 =20 Vince Yotsukura=20 Software Engineer=20 Quadel Consulting Corporation=20 1200 G Street NW, Suite 700=20 Washington, DC 20005=20 Main: (202) 789-2500 Direct: (202) 513-6532=20 Fax: (202) 898-0632 www.quadel.com=20 =20 ------_=_NextPart_001_01CA953F.E7F87FC2 Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

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 =3D 0)
AND
(DOCSTATUS & 1 =3D 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

------_=_NextPart_001_01CA953F.E7F87FC2--