InfoPanel column sorting is not based on the display

Description

When someone tries to sort a column in the info panel (e.g., Order Info) by clicking on the column header (e.g., Business Partner), the sorting is based on the actual column value (i.e, C_BPartner_ID), not the identifier (i.e., "name" from the C_BPartner table).

This can be reproduced easily using GardenWorld:
1. Login to GardenWorld
2. Open a info window (e.g., Order Info)
3. Search some records
4. Click on the "Business Partner" header

Expected behaviour: Sorting is based on what is displayed in the column, not the underneath ID.

Environment

iDempiere 3.1 running in CentOS 7 with Postgresql 9.2

Activity

Show:

Carlos Ruiz May 19, 2020 at 11:47 AM

Workaround as suggested by here:
https://groups.google.com/d/msg/idempiere/Am8uU_Lr56Y/2xBIhpqaBQAJ

"create 2 fields 1 for filter (only filter ) and the linked field ( Name of BP ) for display"

Diego Ruiz May 9, 2020 at 3:59 PM

Triaged as reproducible in 7.1z

Carlos Ruiz October 15, 2019 at 12:59 PM

This is still reproducible in 6.2z

Duplicate

Details

Assignee

Reporter

Components

Affects versions

Priority

Created June 24, 2016 at 5:43 PM
Updated August 1, 2023 at 5:26 PM
Resolved June 29, 2023 at 9:16 PM