c2c-oerpscenario team mailing list archive

["gpa\(Open ERP\)" <gpa@xxxxxxxxxxx>]

Hello Daniel,

I tried with the function field store ={}, but not able to produce the
error.

It give the same result in both the case, when I give
domain=[('unallocated_products', '!=', '0')] or
domain=[('unallocated_products', '!=', 0)].

I would like to request you to please elaborate this with the suitable
steps.

Thanks

** Changed in: openobject-server
       Status: In Progress => Incomplete

-- 
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 OpenERP Server:
  Incomplete

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.