Boolean value is undefined?

Ask the community
,
1

Hi,
I’m trying to get the value of a boolean from my dataset (true or false) but it is always returning as undefined.

I’m using the following code and it returns ‘firstName’ but not ‘approved’ (the boolean field)

Do I need to do something different as it is a boolean?

wixData.query("MembersOnly")
        .find()
        .then((results) => {
         let item = results.items[0]
         let valueFirstName = item['firstName']
         let valueApproved = item['approved']
         console.log(valueFirstName, valueApproved)
        })

Thanks,
Rachel

2

I could bore you with a long (1980´s) expose from IBM about tri-valued logic of booleans (checked, unchecked, not filled out), but basically, it´s the last that is the problem. You should check for undefined and if so, make a decision. That´s difficult: say you have a boolean for “Has been convicted for child abuse”. If there is no value (undefined), does that mean he/she hasn´t, or that the data has not been filled out/unknown? Assuming that undefined is ¨no" could have immense repercussion IRL.
Hope this helps. if not, check Stackoverflow. It´s a general, common problem.