Problem with “where” clause on yes/no field

Hi

I created a pods (name : campagne) with a ‘active’ field of type yes/no.
I created several instances of the pods with active yes or no.
Now, I want to display them using a template (name : Liste campagnes), and in two groups :
– a group of active
– a group of inactive

i’m using the following blocks. Unfortunately, they both display the list of all the pods instances, bypassing the yes/no field value. I tried with 1 and 0, ‘Yes’ and ‘No’, and ‘Oui’ and ‘Non’ as I’m french ??

What did I do wrong ?

[pods name=”campagne” template=”Liste campagnes” where=’active.meta_value = ‘1″‘ orderby=”DATE(date_campagne.meta_value) DESC” limit=”-1″]

[pods name=”campagne” template=”Liste campagnes” where=’active.meta_value = ‘0″‘ orderby=”DATE(date_campagne.meta_value) DESC” limit=”-1″]

• This topic was modified 2 years, 8 months ago by Herve Kabla.