Building a query with a boolean refiner

Ask the community
,
1

Hi everyone ! I need to refine my query using a boolean field, however it seems that there is no query refiner that can correctly handle it.
I tried .eq(“isSuper”, true) but the query returns 0 items, even though I have items where isSuper is true.
This is an external database and I suspect that there might be something with the JSON format as wixData.query usually not returns a false boolean field, and here it actually does return “false”.
Any idea ?

Thanks!

2

What you could do is query the database as a whole and then filter the results array.

Something like this -

wixData.query("DBNAME)
.find()
.then((results)=> {
  let items = results.items
  let filteredData = items.filter(item => item.isSuper = true)
})