Hello Daniel, I would like to know that what is type of the field unallocated_products?
I am testing few scenarios, but it fails only with Boolean fields. Thanks for reporting. -- You received this bug notification because you are a member of C2C OERPScenario, which is subscribed to the OpenERP Project Group. https://bugs.launchpad.net/bugs/677509 Title: Unquoted 0 in domain is converted to None when generating SQL Status in OpenObject Server: Confirmed Bug description: For an act_window definition, we have the following domain set: domain=[('unallocated_products', '!=', '0')] This works fine. However, if we have: domain=[('unallocated_products', '!=', 0)] (i.e. without the quotes around 0) then we end up with qu1 and qu2 in the search() method on osv.orm containining ((1=1) AND (made_batches_batch.stock_move_id in (%s,%s,%s,%s,%s,%s,%s,%s))) AND (made_batches_batch.unallocated_products != %s) and [43, 46, 49, 50, 51, 52, 53, 101, None] This will produce a WHERE clause including "(made_batches_batch.unallocated_products != None". Needless to say, this meant that nothing was working as expected, and should be fixed. _______________________________________________ Mailing list: https://launchpad.net/~c2c-oerpscenario Post to : [email protected] Unsubscribe : https://launchpad.net/~c2c-oerpscenario More help : https://help.launchpad.net/ListHelp
