I have created a SimpleType for formatting currency fields with the correct decimal formatting. That works fine on the client side, however, when using those fields in a FilterBuilder the criteria gets passed to the server correctly, but it doesn't end up creating the expected SQL WHERE clause.
DataSource field definition is <field name="IRET" title="Book Retail" type="currency"/>
Server log showing the criteria was received correctly, but the generated WHERE clause is WHERE ('1'='1'). Is there something I need to do on the server side to tell the framework how to handle fields of type="currency"?
DataSource field definition is <field name="IRET" title="Book Retail" type="currency"/>
Server log showing the criteria was received correctly, but the generated WHERE clause is WHERE ('1'='1'). Is there something I need to do on the server side to tell the framework how to handle fields of type="currency"?
Code:
=== 2011-01-23 12:17:26,777 [0-33] INFO SQLDataSource - [builtinApplication.ItemSummary_fetch] Performing fetch operation with criteria: {operator:"and",criteria:[{fieldName:"IRET",operator:"greaterOrEqual",value:"20"}]} values: {operator:"and",criteria:[{fieldName:"IRET",operator:"greaterOrEqual",value:"20"}]}
Comment