| Hi all,
I'm have a boolean (in the DB as a VARCHAR(5), using the Wonder boolean prototype) attribute that I want to be able to search on. When I search using a text field (like you get on the default Query All page(ERMODQueryEntitiesPage) it works as expectd. Typing true, True or TRUE all work just fine for searching.
But if I use the D2WQueryBoolean or ERD2WQueryBooleanRadioList on the normal Query page it doesn't work.
When searching for true, the DB query has: WHERE t0."IS_DUPLICATED" > '0' When searching for false, the DB query has: WHERE t0."IS_DUPLICATED" = '0' So it's converting the boolean to 0 and 1, and then searching in the DB for that number as a string. Uhg.
When I do an update, it does: "IS_DUPLICATED" = 'true' And since that column is a locking column, the WHERE clause has: "IS_DUPLICATED" = 'false'
So it appears that the D2WEditBoolean is properly converting the boolean to a String.
Why don't either D2WQueryBoolean or ERD2WQueryBooleanRadioList?
Is there a rule I'm missing?
Dave |