CAML query for boolean column is not working

Question

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.

Try to search in google, there is a lot samples of caml query in sharepoint. Things that you have written doesn't look like caml query — Alexander, Jun 27 '12 at 07:50
For some reason that I don't know, I'm sure that sharepoint has a bug, because I have two boolean columns configured by the same way (column "Returned" and column "Checked") and if I use a CAML code to query the spList by the column "Returned" it works, but when I JUST change this CAML code to query by the other column "Checked", just changing the attribute name to the column "Checked", where we set the internal field name only, the code doesn't bring me any spListitem as result, but it should return some items. very weird Column "A" (Returned) — Antonio Augusto, May 10 '17 at 15:20

score 48 · Accepted Answer · answered Jun 27 '12 at 07:59

48

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>

answered Jun 27 '12 at 07:59

Ryan

23,871
24
86
132

3

Weirdly enough, for some Boolean columns you have to put value as "true" and not "1" - I am yet to figure out why – Andrey May 22 '13 at 18:21
4

If you keep Type="Integer", you will always have to use 1 and 0 – Arsalan Adam Khatri Feb 19 '14 at 07:27

score 2 · Answer 2 · edited Mar 25 '14 at 17:20

2

This Works for me

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

edited Mar 25 '14 at 17:20

user692942

16,398
7
76
175

answered Mar 25 '14 at 16:59

DevTard

464
3
11

1

Why do you concatenate the query string like this? – Patric Feb 14 '17 at 10:34
@Patric I was taught to do it this way. – DevTard Jan 04 '18 at 08:40

score 1 · Answer 3 · edited Jun 10 '13 at 11:57

1

Use the value type Bool and it works with "true", "True" or "TRUE"

edited Jun 10 '13 at 11:57

Intermernet

18,604
4
49
61

answered Jun 10 '13 at 11:34

user2470731

29
1

3

I do't think such type exists, can you post link to documentation showing it? – Shadow The GPT Wizard Jun 10 '13 at 11:37
1

Just use this method via Caml Query Builder and it work just fine! – Jalali Shakib Jan 25 '14 at 08:31
Heh, it really works. And looks like it is a better option as it takes 1, true, True and TRUE while Boolean only 1. Tested on SP Online – Adrian Stanisławski Sep 02 '21 at 13:13

CAML query for boolean column is not working

3 Answers3