I'm facing an issue when querying all records of a table in my database and trying to apply filters. When I use a boolean to filter, it only works if the value is true and has no effect if it's false. I have the ignore empty values option checked. It seems like Xano treats false as an empty value, which doesn't make sense. (It would maybe make sense if it said ignore falsy values)
How can I create a filter that doesn't require an input to be filled but still allows filtering with false?
Screenshots:
Current behavior: Without any filters, around 100 records are returned. When I set property==true, I get 10 records. When I set property==false, I still get 100 records.
Expected behavior: After setting property==false, I should get 100 - 10 = 90 records.