SmartGWT.mobile Boolean Criteria not translated right in the WHERE clause

[bda@celerity.be]

Using a boolean criteria in fetch operation generates an SQL WHERE clause with value false (0) whatever the actual value is.

In the following log, we see that the criteria on statusIs_final field is "true" but this is translated in the where clause of the SQL as statusIs_final=0.

=== 2012-12-14 14:40:45,378 [46-0] INFO  SQLDataSource - [builtinApplication.ui_grid_prospects_fetch] Performing fetch operation with
	criteria: {statusIs_final:"true",person_samCode:"ygo"}	values: {statusIs_final:"true",person_samCode:"ygo"}
=== 2012-12-14 14:40:45,397 [46-0] INFO  SQLDataSource - [builtinApplication.ui_grid_prospects_fetch] derived query: SELECT $defaultSelectClause FROM $defaultTableClause WHERE $defaultWhereClause
log4j:WARN No appenders could be found for logger (org.apache.Velocity).
log4j:WARN Please initialize the log4j system properly.
=== 2012-12-14 14:40:45,645 [46-0] INFO  SQLDataSource - [builtinApplication.ui_grid_prospects_fetch] Executing SQL query on 'Mysql': SELECT ui_grid_prospects._statusAge, ui_grid_prospects._temperature, ui_grid_prospects._warnings, ui_grid_prospects.companyName_short, ui_grid_prospects.countryCode, ui_grid_prospects.icon, ui_grid_prospects.id, ui_grid_prospects.name_short, ui_grid_prospects.person_samCode, ui_grid_prospects.sectorGroupName, ui_grid_prospects.sectorName, ui_grid_prospects.sectorSortkey, ui_grid_prospects.statusBudget_total, ui_grid_prospects.statusBudget_weighted, ui_grid_prospects.statusCurrency, ui_grid_prospects.statusDate_close, ui_grid_prospects.statusIs_final, ui_grid_prospects.statusLikelihood, ui_grid_prospects.statusName FROM ui_grid_prospects WHERE (ui_grid_prospects.statusIs_final=0 AND ui_grid_prospects.person_samCode='ygo')
=== 2012-12-14 14:40:45,754 [46-0] DEBUG PoolableSQLConnectionFactory - [builtinApplication.ui_grid_prospects_fetch] Initializing SQL config for 'Mysql' from system config - using DataSource:  com.mysql.jdbc.jdbc2.optional.MysqlDataSource
=== 2012-12-14 14:40:45,806 [46-0] DEBUG PoolableSQLConnectionFactory - [builtinApplication.ui_grid_prospects_fetch] Returning pooled Connection
=== 2012-12-14 14:40:45,834 [46-0] INFO  SQLDriver - [builtinApplication.ui_grid_prospects_fetch] Executing SQL query on 'Mysql': SELECT ui_grid_prospects._statusAge, ui_grid_prospects._temperature, ui_grid_prospects._warnings, ui_grid_prospects.companyName_short, ui_grid_prospects.countryCode, ui_grid_prospects.icon, ui_grid_prospects.id, ui_grid_prospects.name_short, ui_grid_prospects.person_samCode, ui_grid_prospects.sectorGroupName, ui_grid_prospects.sectorName, ui_grid_prospects.sectorSortkey, ui_grid_prospects.statusBudget_total, ui_grid_prospects.statusBudget_weighted, ui_grid_prospects.statusCurrency, ui_grid_prospects.statusDate_close, ui_grid_prospects.statusIs_final, ui_grid_prospects.statusLikelihood, ui_grid_prospects.statusName FROM ui_grid_prospects WHERE (ui_grid_prospects.statusIs_final=0 AND ui_grid_prospects.person_samCode='ygo')
=== 2012-12-14 14:40:45,995 [46-0] INFO  DSResponse - [builtinApplication.ui_grid_prospects_fetch] DSResponse: List with 50 items
=== 2012-12-14 14:40:45,997 [46-0] DEBUG RPCManager - Content type for RPC transaction: text/html; charset=UTF-8
=== 2012-12-14 14:40:45,998 [46-0] DEBUG RPCManager - non-DMI response, dropExtraFields: false

The field is declared in the ds as Boolean stored as integer:

        <field name="statusIs_final"		title="F"					type="boolean"	sqlStorageStrategy="integer"/>

[Isomorphic]

Please remember to provide all the version information that the forums asks for. This looks like a long-ago fixed bug where "true" was not treated as a boolean (because it's a String).

[bda@celerity.be]

smartgwt-mobile-1.0d_2012-12-13 (not so old ...)
and
smartgwtpro-3.0p 2012-06-12

[bda@celerity.be]

Tested now with new version of smartgwt (smartgwtpower-3.1p) and it works.