c2c-oerpscenario team mailing list archive

["Jay \(OpenERP\)" <jvo@xxxxxxxxxxx>]

Field if put on groupby,should be a field in DB.
Putting store=True should solve the issue.
Make a better check though.
Thanks.

** Changed in: openobject-addons
   Importance: Undecided => Medium

** Changed in: openobject-addons
       Status: New => Confirmed

** Changed in: openobject-addons
     Assignee: (unassigned) => OpenERP R&D Addons Team 2 (openerp-dev-addons2)

-- 
Purchase module : problems in group by in seach view
https://bugs.launchpad.net/bugs/670921
You received this bug notification because you are a member of C2C
OERPScenario, which is subscribed to the OpenERP Project Group.

Status in OpenObject Addons Modules: Confirmed

Bug description:
Following bugs are founded : 

Purchases/Receive Products/Incoming Shipments : Group By Partner Have following error


2010-11-04 18:48:09,988][trunk] ERROR:db.cursor:Programming error: column "partner_id" does not exist
LINE 1: SELECT min(stock_picking.id) AS id,partner_id,sum(weight) as...
                                           ^
, in query SELECT min(stock_picking.id) AS id,partner_id,sum(weight) as weight,sum(weight_net) as weight_net FROM "stock_picking" WHERE (stock_picking.type = %s) AND (stock_picking.state = %s) GROUP BY partner_id
[2010-11-04 18:48:09,989][trunk] ERROR:web-services:Uncaught exception
Traceback (most recent call last):
  File "/home/vir/erog/openobject-server/bin/osv/osv.py", line 57, in wrapper
    return f(self, dbname, *args, **kwargs)
  File "/home/vir/erog/openobject-server/bin/osv/osv.py", line 140, in execute
    res = pool.execute_cr(cr, uid, obj, method, *args, **kw)
  File "/home/vir/erog/openobject-server/bin/osv/osv.py", line 130, in execute_cr
    return getattr(object, method)(cr, uid, *args, **kw)
  File "/home/vir/erog/openobject-server/bin/osv/orm.py", line 2245, in read_group
    cr.execute('SELECT min(%s.id) AS id,' % self._table + flist + ' FROM ' + from_clause + where_clause + gb + limit_str + offset_str, where_clause_params)
  File "/home/vir/erog/openobject-server/bin/sql_db.py", line 75, in wrapper
    return f(self, *args, **kwargs)
  File "/home/vir/erog/openobject-server/bin/sql_db.py", line 122, in execute
    res = self._obj.execute(query, params)
ProgrammingError: column "partner_id" does not exist
LINE 1: SELECT min(stock_picking.id) AS id,partner_id,sum(weight) as...