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
October 15, 2019, 12:59 PM

This is still reproducible in 6.2z

Diego Ruiz
May 9, 2020, 3:59 PM

Triaged as reproducible in 7.1z

Carlos Ruiz
May 19, 2020, 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"

Assignee

Unassigned

Reporter

Nelson Chan

Tested By

None

Components

Affects versions

Priority

Major
Configure