Just 1 more comment about this problem, if I try to set "_order = 'name'" in object "hotel.room" to order rooms by name, I get below error message when viewing the list of Rooms.
IMHO, this feature is also good to have.
Thanks,
Tu
Traceback (most recent call last):
File "/home/tubui/source_code/trunk6-new/server/bin/netsvc.py", line 489, in dispatch
result = ExportService.getService(service_name).dispatch(method, auth, params)
File "/home/tubui/source_code/trunk6-new/server/bin/service/web_services.py", line 599, in dispatch
res = fn(db, uid, *params)
File "/home/tubui/source_code/trunk6-new/server/bin/osv/osv.py", line 122, in wrapper
return f(self, dbname, *args, **kwargs)
File "/home/tubui/source_code/trunk6-new/server/bin/osv/osv.py", line 176, in execute
res = self.execute_cr(cr, uid, obj, method, *args, **kw)
File "/home/tubui/source_code/trunk6-new/server/bin/osv/osv.py", line 167, in execute_cr
return getattr(object, method)(cr, uid, *args, **kw)
File "/home/tubui/source_code/trunk6-new/server/bin/osv/orm.py", line 1743, in search
return self._search(cr, user, args, offset=offset, limit=limit, order=order, context=context, count=count)
File "/home/tubui/source_code/trunk6-new/server/bin/osv/orm.py", line 4045, 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/tubui/source_code/trunk6-new/server/bin/sql_db.py", line 78, in wrapper
return f(self, *args, **kwargs)
File "/home/tubui/source_code/trunk6-new/server/bin/sql_db.py", line 131, in execute
res = self._obj.execute(query, params)
ProgrammingError: column "name" does not exist
LINE 1: SELECT "hotel_room".id FROM "hotel_room" ORDER BY name limi...
Hello Naresh,
Just 1 more comment about this problem, if I try to set "_order = 'name'" in object "hotel.room" to order rooms by name, I get below error message when viewing the list of Rooms.
IMHO, this feature is also good to have.
Thanks,
Tu
Traceback (most recent call last): tubui/source_ code/trunk6- new/server/ bin/netsvc. py", line 489, in dispatch getService( service_ name).dispatch( method, auth, params) tubui/source_ code/trunk6- new/server/ bin/service/ web_services. py", line 599, in dispatch tubui/source_ code/trunk6- new/server/ bin/osv/ osv.py" , line 122, in wrapper tubui/source_ code/trunk6- new/server/ bin/osv/ osv.py" , line 176, in execute tubui/source_ code/trunk6- new/server/ bin/osv/ osv.py" , line 167, in execute_cr tubui/source_ code/trunk6- new/server/ bin/osv/ orm.py" , line 1743, in search tubui/source_ code/trunk6- new/server/ bin/osv/ orm.py" , line 4045, in _search execute( 'SELECT "%s".id FROM ' % self._table + from_clause + where_str + order_by + limit_str + offset_str, where_clause_ params) tubui/source_ code/trunk6- new/server/ bin/sql_ db.py", line 78, in wrapper tubui/source_ code/trunk6- new/server/ bin/sql_ db.py", line 131, in execute execute( query, params)
File "/home/
result = ExportService.
File "/home/
res = fn(db, uid, *params)
File "/home/
return f(self, dbname, *args, **kwargs)
File "/home/
res = self.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/
cr.
File "/home/
return f(self, *args, **kwargs)
File "/home/
res = self._obj.
ProgrammingError: column "name" does not exist
LINE 1: SELECT "hotel_room".id FROM "hotel_room" ORDER BY name limi...