bug with advanced filters

[Aline (OpenERP)]

in a search view click on advanced filters _> bug :

Client Traceback (most recent call last):
  File "/home/aline/openerp/web/openerp-web/addons/web/common/dispatch.py", line 161, in dispatch
    response["result"] = method(controller, self, **self.params)
  File "/home/aline/openerp/web/openerp-web/addons/web/controllers/main.py", line 628, in search_read
    return self.do_search_read(req, model, fields, offset, limit, domain, sort)
  File "/home/aline/openerp/web/openerp-web/addons/web/controllers/main.py", line 653, in do_search_read
    ids = Model.search(domain, 0, False, sort or False, context)
  File "/home/aline/openerp/web/openerp-web/addons/web/common/openerplib/main.py", line 367, in proxy
    *args)
  File "/home/aline/openerp/web/openerp-web/addons/web/common/openerplib/main.py", line 244, in proxy
    result = self.connector.send(self.service_name, method, *args)
  File "/home/aline/openerp/web/openerp-web/addons/web/common/openerplib/main.py", line 214, in send
    raise fault

Server Traceback (most recent call last):
  File "/home/aline/openerp/server/trunk/openerp/netsvc.py", line 411, in dispatch_rpc
    result = ExportService.getService(service_name).dispatch(method, auth, params)
  File "/home/aline/openerp/server/trunk/openerp/service/web_services.py", line 575, in dispatch
    res = fn(db, uid, *params)
  File "/home/aline/openerp/server/trunk/openerp/osv/osv.py", line 119, in wrapper
    return f(self, dbname, *args, **kwargs)
  File "/home/aline/openerp/server/trunk/openerp/osv/osv.py", line 173, in execute
    res = self.execute_cr(cr, uid, obj, method, *args, **kw)
  File "/home/aline/openerp/server/trunk/openerp/osv/osv.py", line 164, in execute_cr
    return getattr(object, method)(cr, uid, *args, **kw)
  File "/home/aline/openerp/server/trunk/openerp/osv/orm.py", line 2138, in search
    return self._search(cr, user, args, offset=offset, limit=limit, order=order, context=context, count=count)
  File "/home/aline/openerp/server/trunk/openerp/osv/orm.py", line 4347, in _search
    cr.execute('SELECT "%s".id FROM ' % self._table + from_clause + where_str + order_by + limit_str + offset_str, where_clause_params)
  File "/home/aline/openerp/server/trunk/openerp/sql_db.py", line 153, in wrapper
    return f(self, *args, **kwargs)
  File "/home/aline/openerp/server/trunk/openerp/sql_db.py", line 215, in execute
    res = self._obj.execute(query, params)
ProgrammingError: ERREUR: l'opérateur n'existe pas : integer ~~* unknown
LIGNE 1 : ...er."user_id" = 1) AND ((sale_order."project_id" ilike E'%%...
                                                               ^
ASTUCE : Aucun opérateur ne correspond au nom donné et aux types d'arguments.
Vous devez ajouter des conversions explicites de type.

[Yogesh (SerpentCS) (yogesh-serpentcs)]

Hello,

This bug fixed on server side because click on advance filter then execute the search method and pass domain based on default field in advance filter. eg. :- If I clicked on advance filter in sale.order then default field analytic account selected and operator contains is selected and this domain pass to server side like :- [['project_id', 'ilike', '']] then server generate the exception. i.e if m2o field pass this type of domain then server generate exception.

Also This Exception generate on gtk-client. e.g. Open sale order view and add field of custom filter, default field is analytic account you need to change the operator contains and click on find button then generate exception from server side.

Thanks,

[Naresh(OpenERP) (nch-openerp)]

Well, This seems to be fixed from both the clients i.e GTK / web. The M20 with contains/doesn't contains with the 3rd arg i.e the string to be compared if its blank the clients should ignore them from the domain. As we do for the char case on main search view.

[Naresh(OpenERP) (nch-openerp)]

Hello,

Thanks for reporting !

It has been fixed at trunk client @ revision-info:1964 <email address hidden>

regards,

[Khushbu Modi(openerp) (kmo)]

Hello,

It has been fixed in lp:~openerp-dev/openerp-web/trunk-bug-861350-km.
Revision ID <email address hidden>

Thanks,
kmo.

[Khushbu Modi(openerp) (kmo)]

Fixed in lp:~openerp-dev/openerp-web/trunk-bug-861350-kmo.

[Nicolas Vanhoren (OpenERP) (niv-openerp)]

This error is caused by the openerp server throwing an exception when we specify an ilike with an empty string on a many2one.

[Nicolas Vanhoren (OpenERP) (niv-openerp)]

Code to reproduce this error, using the openerp client lib:

connection.get_model("sale.order").search([['user_id', '=', 1], ['project_id', 'ilike', '']])

[Olivier Dony (Odoo) (odo-openerp)]

Fix landed in server trunk at rev 3753 revid: <email address hidden>