c2c-oerpscenario team mailing list archive

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

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,

** Project changed: openerp-web => openobject-server

** Changed in: openobject-server
     Assignee: OpenERP R&D Web Team (openerp-dev-web) => OpenERP's Framework R&D (openerp-dev-framework)

-- 
You received this bug notification because you are a member of C2C
OERPScenario, which is subscribed to OpenERP Project Group.
https://bugs.launchpad.net/bugs/861350

Title:
  bug with advanced  filters

Status in OpenERP Server:
  Confirmed

Bug description:
  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.

To manage notifications about this bug go to:
https://bugs.launchpad.net/openobject-server/+bug/861350/+subscriptions