Filter Fields using Caml Query

Question

Normally I have this query, filtered with MostrarHome eq 'No'

 var queryGallery = "$select=Title,Description,Enlace,EncodedAbsUrl,Categoria/Title&$expand=Categoria/Title&$orderby=Title asc&$filter=MostrarHome eq 'No'";

So I try to do it in Calm Query and it returns values but the filter doesn´t works:

 queryStringGaleria += string.Format("<Query><Where><Eq><FieldRef Name='MostrarHome'/><Value Type='Boolean'>0</Value></Eq></Where></Query><RowLimit>1000</RowLimit>");
               queryStringGaleria += "<ViewFields>";
               queryStringGaleria += "<FieldRef Name='FileRef' />";
               queryStringGaleria += "<FieldRef Name='Categoria' />";
               queryStringGaleria += "<FieldRef Name='Categoria_x003a_English' />";
               queryStringGaleria += "<FieldRef Name='Title' />";
               queryStringGaleria += "<FieldRef Name='TitleEnglish' />";
               queryStringGaleria += "<FieldRef Name='Enlace' />";
               queryStringGaleria += "<FieldRef Name='DescriptionEnglish' />";
               queryStringGaleria += "<FieldRef Name='Description' />";
               queryStringGaleria += "</ViewFields></View>";

How can I filter it correctly?

Are you opening the <View> tag somewhere not shown above?

Erin L
– Erin L

2016-08-18 23:32:55 +00:00
Commented Aug 18, 2016 at 23:32 — Erin L
– Erin L, Commented Aug 18, 2016 at 23:32

Mohamed El-Qassas MVP · Accepted Answer · 2016-08-18 23:54:02Z

I think that that issue related to MostrarHome type value it's should be integer rather than Boolean

Details:

The <Value Type='Boolean'> take value 0 for false and 1 for true

Regarding Yes / No field contains integer data (1 for Yes and 0 for No option), so your query should look like,

queryStringGaleria += string.Format("<Query><Where><Eq><FieldRef Name='MostrarHome'/><Value Type='Integer'>0</Value></Eq></Where></Query><RowLimit>1000</RowLimit>");
               queryStringGaleria += "<View><ViewFields>";
               queryStringGaleria += "<FieldRef Name='FileRef' />";
               queryStringGaleria += "<FieldRef Name='Categoria' />";
               queryStringGaleria += "<FieldRef Name='Categoria_x003a_English' />";
               queryStringGaleria += "<FieldRef Name='Title' />";
               queryStringGaleria += "<FieldRef Name='TitleEnglish' />";
               queryStringGaleria += "<FieldRef Name='Enlace' />";
               queryStringGaleria += "<FieldRef Name='DescriptionEnglish' />";
               queryStringGaleria += "<FieldRef Name='Description' />";
               queryStringGaleria += "</ViewFields></View>";

Note : I also put in mind , you might miss <view> tag as @ErinL said in her comment.so I put it at the above-modified query.

Both Type='Integer' and Type='Boolean' are valid for Yes/No fields — Erin L
– Erin L, Commented Aug 18, 2016 at 23:27
Thanks @ErinL for this info , I tried to do that for integer and worked properly , I think he may be miss <view> as you told him in your comment but if he has error in his query it's should not work but he said he return data but not filtered so let us wait for him,I am also will update my answer Thanks again :) — Mohamed El-Qassas MVP
– Mohamed El-Qassas MVP ♦, Commented Aug 18, 2016 at 23:48

Gaurravs · Accepted Answer · 2018-12-05 04:58:11Z

0

1 for Yes(true) and 0 for No (false)

var queryGallery = "$select=Title,Description,Enlace,EncodedAbsUrl,Categoria/Title&$expand=Categoria/Title&$orderby=Title asc&$filter=MostrarHome eq 0"; //false

or

var queryGallery = "$select=Title,Description,Enlace,EncodedAbsUrl,Categoria/Title&$expand=Categoria/Title&$orderby=Title asc&$filter=MostrarHome eq 1"; //true

edited Dec 5, 2018 at 4:58

Gaurravs

3,55612 gold badges25 silver badges33 bronze badges

answered Dec 4, 2018 at 21:28

Michelle Rodrigues

1

Add a comment |

Stack Exchange Network

Filter Fields using Caml Query

2 Answers 2

Your Answer

Hot Network Questions

Filter Fields using Caml Query

2 Answers 2

Your Answer

Sign up or log in

Post as a guest

Related

Hot Network Questions