CAML query for boolean column is not working

c# sharepoint caml
Nirushan Ferdinand Chandran picture Nirushan Ferdinand Chandran · Jun 27, 2012 · Viewed 39.6k times · Source

Hi I have a SharePoint list to be queried for my Desktop App and I want to retrieve only the Active Members but when I queried I got only the users who aren't active. What is wrong with my CAML query?

camlQuery.ViewXml = "<<"View">><Query><Where><Eq><FieldRef Name='Active'/><Value Type='Boolean'> " + true + "</Value></Eq></Where></Query></View>"";

I tried the following as well

camlQuery.ViewXml = "<View><Query><Where><Eq><FieldRef Name='Active'/><Value Type='Boolean'> true</Value></Eq></Where></Query></View>";

and

camlQuery.ViewXml = "<Query><Where><Eq><FieldRef Name='Active'/><Value Type='Boolean'> true</Value></Eq></Where></Query>";

Please help as I'm new to CAML.

Answer

Ryan picture Ryan · Jun 27, 2012

Save yourself some grief and use a tool to help build up CAML queries such as U2U's Caml Query Builder.

You need to use 1 and 0 (not true and false) in the query, so

<Query><Where>
   <Eq><FieldRef Name="Active" /><Value Type="Boolean">1</Value></Eq>
</Where></Query>

Related questions

CAML query to a SharePoint list, order by a lookup field

I'm attempting to pull a list from SharePoint via CAML and I want the list returned ordered by a specific field. The field is a lookup field. The query comes back unordered when I set the OrderBy to be the …

Read More
Getting field names of a listItem - (Strongly typed?) in SharePoint 2010 Client API

I'm very new to SharePoint, using 2010. Trying to see what we can do with it, in particular with Lists. And I have a feeling I'm missing something pretty obvious, but can't find it..... In a Sharepoint site I created a …

Read More
Datetime comparison in CAML Query for Sharepoint

i'm trying to have some item from a sharepoint list, depends on date in a custom column. I've created my query with U2U Caml Builder, and that's worked but when I put it in my own code in my …

Read More