Function,related fields that are not stored cannot be used to sort

[Ferdinand]

base_contact installed

sales / address book / contacts

clicking on each field does not sort the date

[Julian Robbins (joolsr)]

Ordering on Products is still broken. ie ordering Products by 'Real Stock', Virtual Stock, List Price columns

[Olivier Dony (Odoo) (odo-openerp)]

Hello all,

Function fields (related fields are a kind of function field) that are not marked as "stored" cannot be sorted, because doing it would either:
- provide inaccurate or misleading data to the user (as was the case in v5, due to sorting only visible data)
- or be extremely and needlessly expensive (computing the function for *all* records in the database, potentially of a very large size!)

This is because the data is not in the database and is computed on-the-fly, so we cannot sort on what is not there.

A workaround is to mark as "stored" the fields for which you absolutely need to be able to sort.

We will keep this issue in mind for improvement after v6.0, either by providing a more intuitive feedback to users about it, or finding another solution, but this will not be changed in v6.0

Thanks for reporting.

[Ferdinand (office-chricar)]

Please keeep in mind end users:
their experience is that clicking on a column header is to get a sorted result
if the programm does not provide the functionality a popup should say so.
doing nothing is not self explanatory and causes endless requests.

[Ferdinand (office-chricar)]

trunk - now we see the sort indicator - but records are not sorted

[Ferdinand (office-chricar)]

we at camptocamp have included a patch in
https://code.launchpad.net/~c2c/openobject-server/6.0-c2c-official
please read blog entry
http://www.camptocamp.com/fr/component/wordpress/?author=87

[Florent (florent.x)]

Thank you for the fix.

I did port the fix for the 6.1 branch (see related branch above).

https://code.launchpad.net/~florent.x/openobject-server/6.1-fallback-search-sort/+merge/124963

[Ferdinand (office-chricar)]

sort for function and related fields still not working - it's a shame..

a patch for this was already available for 6.0

[Ferdinand (office-chricar)]

credits to Panos