bug on the filter to create view with boolean

[oswaldB]

I have two rows one is "paye" at true and the other one is "paye" at false.

I created 2 views based on the boolean value of the "paye" attribute:

The view with the true filter is working but not the one with value false.

[mjashanks]

Yea - i see this now, I can recreate it. A workaround is to create the filter paye notEquals true !

I can make it happen by adding a Boolean column, after data already exists in the table. Underneath, the value defaults to null, so technically null is not true. We need to default it to false, or possibly ask for a default value when the column is added.

[oswaldB]

i think the problem is more global.

I changed the true/false by a 0 and 1.

And even with 0 and 1 the filter is not working.

[mjashanks]

I have logged this here: #2042 - thanks for reporting!