While querying yes/no column using caml query JSOM sharepoint 2013 getting "value doesnot fall in the excpeted range".
<ProjectedFields>
<Field Name="DateColumn" Type="Lookup" List="Employee_Table" ShowField="DateColumn" />
<Field Name="yes_noColumn" Type="Lookup" List="Employee_Table" ShowField="yes_noColumn" />
</ProjectedFields
<FieldRef Name="DateColumn"/>
<FieldRef Name="yes_noColumn"/>
<Query>
<Where>
<Or>
<Eq><FieldRef Name="yes_noColumn"/><Value Type="Boolean">true</Value> </Eq>
<Leq><FieldRef Name="DateColumn"/><Value Type="DateTime"><Today OffsetDays="-180" /></Value></Leq>
</Or>
</Where>
</Query>
</View>
If I remove this yes/no column type from condition and put some "text" type column it is working. Am getting error for thr type "yes/no" column.
I tried with
Boolean --> true
Boolean --> True
Boolean --> TRUE
Boolean --> 1
Integer --> 1
bit --> 1
None of them are working.