query to match if boolean field is not True

[David Zejda]

Hi :)

Intuitively I would expect that these queries are equivalent ways to match if boolean_field is not True:

~(db.mytable.boolean_field == True)

(db.mytable.boolean_field != True)

((db.mytable.boolean_field == None) | (db.mytable.boolean_field == False))

But only the last one works as expected.

David

[Massimo Di Pierro]

I would expect that too but it is not a web2py issue. It is a database issue. web2py simply translate those in

NOT mytable.boolean_field = 'T'

[David Zejda]

On Sunday, 11 February 2018 05:52:44 UTC+1, Massimo Di Pierro wrote:

I would expect that too but it is not a web2py issue. It is a database issue. web2py simply translate those in

Hi Massimo, thank you for explanation!

David