c2c-oerpscenario team mailing list archive

["Olivier Dony \(OpenERP\)" <629332@xxxxxxxxxxxxxxxxxx>]

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.

** Changed in: openobject-server
   Importance: Medium => Wishlist

** Summary changed:

- Function,related fields do not get sorted
+ Function,related fields that are not stored cannot be used to sort

-- 
Function,related fields that are not stored cannot be used to sort
https://bugs.launchpad.net/bugs/629332
You received this bug notification because you are a member of C2C
OERPScenario, which is subscribed to the OpenERP Project Group.

Status in OpenObject Server: Confirmed

Bug description:
base_contact installed

sales / address book / contacts 

clicking on each  field does not sort the date