Queries with boolean field as condition are returning NULL results

Wappler General
1

i am making a query with a boolean field as condition. the query is not returning any result …

ProcessCompleted1
ProcessCompleted11028×364 24.7 KB
processcompleted2
processcompleted2993×331 11.4 KB
processcompleted3

2

Try a zero, instead of false.

3

I am using 0 and 1 … When i re-open the query builder it becomes true or false, i believe its the builder evaluating it to that, as an alternative i tried using a get variable, and passing 0 or 1 to the variable, the query result is still empty

4

@Teodor @patrick how do i solve the above issue?

5

What is your database type? What is your server model? What is your exact db field type and is the value entered inside it?

6

I am using postgres db, the server model is nodejs, and field type is boolean with no default value

7

So are you sure any of your records has a boolean field with a value of false or 0?
What results do you get when you run the query with no filter applied?

8

The field is boolean, when i run the query without the boolean field as filter, i see results

9

Can you post a screenshot of the result here please?

10

Ah i see your mistake now. You have a boolean field with no default value, so its value is null when not set to true or false. Postgresql accepts true, false and NULL as values in a boolean field.

Which means you need to use IS NULL condition, not equal false here. So change equal to IS NULL to return the records which are not set to true:

1 Like