error when reordering of Customers based on Country
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Odoo Server (MOVED TO GITHUB) |
New
|
Undecided
|
Unassigned |
Bug Description
Using trunk as of today ie Openerp-server rev 3014
I consistently get this error with a newly created clean database. I get same error with gtk client too.
To reproduce
1. Go to Sales, Address Book, Customers
2. Click on Column header 'Country'
Then you get the error.
Ordering on City doesn't order correctly, but doesn't give an error. I have reported this previously as bug https:/
Environment Information :
System : Linux-2.
OS Name : posix
Distributor ID: Ubuntu
Description: Ubuntu 10.10
Release: 10.10
Codename: maverick
Operating System Release : 2.6.35-22-generic
Operating System Version : #35-Ubuntu SMP Sat Oct 16 20:45:36 UTC 2010
Operating System Architecture : 64bit
Operating System Locale : en_GB.UTF8
Python Version : 2.6.6
OpenERP-Client Version : 6.0.0-rc1-1
Last revision No. & ID :Bazaar Package not Found !Traceback (most recent call last):
File "/home/
result = ExportService.
File "/home/
res = fn(db, uid, *params)
File "/home/
return f(self, dbname, *args, **kwargs)
File "/home/
res = pool.execute_cr(cr, uid, obj, method, *args, **kw)
File "/home/
return getattr(object, method)(cr, uid, *args, **kw)
File "/home/
return self._search(cr, user, args, offset=offset, limit=limit, order=order, context=context, count=count)
File "/home/
order_by = self._generate_
File "/home/
order_by_clause = self._generate_
File "/home/
assert order_field_
AssertionError: Many2one function/related fields must be stored to be used as ordering fields
Hello Julian,
This is because some dynamically computed fields cannot be used as sort criterions, and this bug is thus a duplicate of bug 629332, so I will mark it as so.
We don't know yet if this will stay as a limitation or if we will implement a workaround for this.
Thanks for the report