← Back to team overview

c2c-oerpscenario team mailing list archive

[Bug 705739] Re: [Trunk] account: Group by doesn't work on Journal items

 

yes we have set domain on tree view of account.move.line (field=account
id).

And on search view we replace this domain with some other args. so with
normal searching/grouping on accounts it will work. But when you search
from => Press F2 on 'account' field of editable tree view. It will not
work.

We can not fix it for 6.0, but try to fix it for next version.

thanks,
mra

** Changed in: openobject-addons
       Status: Confirmed => Won't Fix

** Changed in: openobject-addons
   Importance: Low => Wishlist

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

Title:
  [Trunk] account: Group by doesn't work on Journal items

Status in OpenERP Modules (addons):
  Won't Fix

Bug description:
  Accounting>journal items> Press F2 on 'account' field of editable tree
  view

  I am getting new form then press any group by button give the
  following traceback

  [2011-01-21 10:53:53,768][test] ERROR:db.cursor:Programming error: column account_account.journal_id does not exist
  LINE 1: ...nt" WHERE (account_account.active = E'True') AND (account_ac...
                                                               ^
  , in query SELECT min(account_account.id) AS id, count(account_account.id) AS parent_id_count,"account_account".parent_id FROM "account_account" WHERE (account_account.active = %s) AND (account_account.journal_id = '2') AND (account_account.type <> %s) AND (account_account.type <> %s) GROUP BY "account_account".parent_id
  [2011-01-21 10:53:53,768][test] ERROR:web-services:Uncaught exception
  Traceback (most recent call last):
    File "/home/ara/workspace/trunk/openobject-server/bin/osv/osv.py", line 122, in wrapper
      return f(self, dbname, *args, **kwargs)
    File "/home/ara/workspace/trunk/openobject-server/bin/osv/osv.py", line 176, in execute
      res = self.execute_cr(cr, uid, obj, method, *args, **kw)
    File "/home/ara/workspace/trunk/openobject-server/bin/osv/osv.py", line 167, in execute_cr
      return getattr(object, method)(cr, uid, *args, **kw)
    File "/home/ara/workspace/trunk/openobject-server/bin/osv/orm.py", line 2186, in read_group
      cr.execute('SELECT min(%s.id) AS id, count(%s.id) AS %s_count' % (self._table, self._table, group_count) + (flist and ',') + flist + ' FROM ' + from_clause + where_clause + gb + limit_str + offset_str, where_clause_params)
    File "/home/ara/workspace/trunk/openobject-server/bin/sql_db.py", line 78, in wrapper
      return f(self, *args, **kwargs)
    File "/home/ara/workspace/trunk/openobject-server/bin/sql_db.py", line 131, in execute
      res = self._obj.execute(query, params)
  ProgrammingError: column account_account.journal_id does not exist
  LINE 1: ...nt" WHERE (account_account.active = E'True') AND (account_ac...





References