enhanced order clause

Registered by Ferdinand

V5: it is not possible to sort product lists by name (in forms, reports?)
the _order should accept also columns from the other table like
_order: "product_template.name","product_product.variants" (or similar)

IMHO not being able to fully control the order of the returned resources is one of the big draw backs.
users expect sorted resources with visible keys.
the list fields should be arranged in the sort order.

an additional problem
if the field is translated the user expects to get resources sorted in his/her language
so we need sort_translated

IMHO this is a major usability issue as many lists (products,task) give the impression to be "unsorted" (from users perspective) and the user has to click on the column header to get it sorted. Together with the fact that GTK/WEB only sort visible/fetched rows this is a major concern. ( I addressed this matter already frequently)
Koo handles the "sort all records" issue better, but does currently not allow to sort all columns
see
https://bugs.launchpad.net/openobject-client-kde/+bug/394711
and especially
https://bugs.launchpad.net/openobject-client-kde/+bug/394711/comments/3

IMHO we also need form/report level sort options - same table different sort depending on requirements

Blueprint information

Status:
Not started
Approver:
None
Priority:
Undefined
Drafter:
None
Direction:
Needs approval
Assignee:
None
Definition:
New
Series goal:
None
Implementation:
Unknown
Milestone target:
None

Related branches

Sprints

Whiteboard

there is a usable workaround implemented here for products

most lists geet sorted by produckt name + variants

http://bazaar.launchpad.net/~openerp-commiter/openobject-addons/chricar_price_unit/annotate/head:/product/product.py

(?)

Work Items

This blueprint contains Public information 
Everyone can see this information.

Subscribers

No subscribers.