Bug with product margin

[Harmel Delphine (OpenERP)]

In the GTK Client,

install product_margin, then open product_margin but without specifying any date

=> you get the following error :

Environment Information :
System : Linux-2.6.32-26-generic-i686-with-Ubuntu-10.04-lucid
OS Name : posix
Distributor ID: Ubuntu
Description: Ubuntu 10.04.1 LTS
Release: 10.04
Codename: lucid
Operating System Release : 2.6.32-26-generic
Operating System Version : #48-Ubuntu SMP Wed Nov 24 09:00:03 UTC 2010
Operating System Architecture : 32bit
Operating System Locale : fr_BE.UTF8
Python Version : 2.6.5
OpenERP-Client Version : 6.0.0-rc1-1
Last revision No. & ID :1713 launchpad_translations_on_behalf_of_openerp-20101211044634-hs30hc0l5ufmah4a
Traceback (most recent call last):
  File "/home/openerp/trunk/server/bin/netsvc.py", line 489, in dispatch
    result = ExportService.getService(service_name).dispatch(method, auth, params)
  File "/home/openerp/trunk/server/bin/service/web_services.py", line 598, in dispatch
    res = fn(db, uid, *params)
  File "/home/openerp/trunk/server/bin/osv/osv.py", line 119, in wrapper
    return f(self, dbname, *args, **kwargs)
  File "/home/openerp/trunk/server/bin/osv/osv.py", line 203, in execute
    res = pool.execute_cr(cr, uid, obj, method, *args, **kw)
  File "/home/openerp/trunk/server/bin/osv/osv.py", line 193, in execute_cr
    return getattr(object, method)(cr, uid, *args, **kw)
  File "/home/openerp/trunk/server/bin/osv/orm.py", line 3019, in read
    result = self._read_flat(cr, user, select, fields, context, load)
  File "/home/openerp/trunk/server/bin/osv/orm.py", line 3130, in _read_flat
    res2 = self._columns[val[0]].get(cr, self, ids, val, user, context=context, values=res)
  File "/home/openerp/trunk/server/bin/osv/fields.py", line 782, in get
    res = self._fnct(obj, cr, user, ids, name, self._arg, context)
  File "/home/openerp/trunk/server/bin/addons/product_margin/product_margin.py", line 70, in _product_margin
    """, (val.id, states, invoice_types, date_from, date_to))
  File "/home/openerp/trunk/server/bin/sql_db.py", line 76, in wrapper
    return f(self, *args, **kwargs)
  File "/home/openerp/trunk/server/bin/sql_db.py", line 129, in execute
    res = self._obj.execute(query, params)
ProgrammingError: ERREUR: operator doesn't exist : date >= boolean
LINE 10: ... (E'in_invoice', E'out_refund') and i.date_invoice>=false an...
                                                              ^
HINT: No operator corresponds to given name and types of arguments.
We should add explicit types conversion.

[Mustufa Rangwala (Open ERP) (mra-tinyerp)]

Hello Harmel,

Fixed the problem in Addons3 branch with,

revision-id: mra@mra-laptop-20101214071321-ynyrnm0hrm5jbkkd

Thank you,
mustufa