Change value displayed for boolean fields

Ask the community
,
6

Hi Brett:

When you are dealing with boolean values in the data collection you can only really rely on counting true values. false , is the negative although unless you specifically set the value to false the value could also be returned as null.

So to address this problem you need to use .eq(‘propertyName’, true) to find true values see the following:

wixData.query('NewYearSurvey')
 .eq('cardioSculpt', true)
 .count()
 .then((num) => { cardioCount = num; })

or to get negative (false) values you need to check for the opposite of .eq, so .ne(‘propertyName’, true)

wixData.query('NewYearSurvey')
 .ne('cardioSculpt', true)
 .count()
 .then((num) => { 
     cardioCount = num;
 })

NOTE: the work true in the above examples is without quotes of any kind because the words true and false are special words known as primitives in javascript.

Hope this helps.
Good luck