Boolean in OQL where clauses

1
Hi all, I came across a strange problem with OQL datasets, which also referenced here: https://forum.mendixcloud.com/link/questions/100328 If you write an OQL expression in a dataset with ‘WHERE some.boolean = false’ , the false is denoted with an error “cannot resolve path”, While evaluating the same with the OQL module this works fine. On the other hand, something like ‘WHERE NOT some.boolean’ doesn’t work when executed, but is not shown as an error in the Dataset. Can anyone explain what’s going on there? regards, Fabian 
asked
1 answers
1

Here’s the answer for later reference:

In a DataSet

WHERE some.boolean = 'false'

With OQL module as escaped literal

'WHERE some.boolean = ''false'' '

 

answered