c2c-oerpscenario team mailing list archive

["Naresh\(OpenERP\)" <nch@xxxxxxxxxxx>]

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.




** Project changed: openobject-server => openobject-client

** Changed in: openobject-client
       Status: Confirmed => In Progress

** Changed in: openobject-client
     Assignee: OpenERP's Framework R&D (openerp-dev-framework) => OpenERP sa GTK client R&D (openerp-dev-gtk)

** Also affects: openerp-web
   Importance: Undecided
       Status: New

** Changed in: openerp-web
       Status: New => Confirmed

** Changed in: openerp-web
   Importance: Undecided => Medium

** Changed in: openerp-web
     Assignee: (unassigned) => OpenERP R&D Web Team (openerp-dev-web)

-- 
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 Web:
  Confirmed
Status in OpenERP GTK Client:
  Fix Released

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/openerp-web/+bug/861350/+subscriptions