Search Dialog Columns are duplicated when table is present in multiple window tabs.

Description

I thought it would be a good idea to have the same table in a parent and a child tab in the same window.
This way I can display the child items (if present) in the child tab which IMO is actually a useful thing to have.

This causes an error that can currently be reproduced at test.idempiere.org

The key column of the table is accessed through a foreign key from another table column that uses a search reference.
What happens is that the columns are duplicated in the search dialog grid.
Menu > Item Search Test > Two Tab Test > Search Dialog

Window setup that causes the error:
Menu > Two Tab Test

Group Thread with Details: https://groups.google.com/g/idempiere/c/SFLpEkl7uic

Environment

None

Attachments

4
  • 21 Jan 2021, 10:43 AM
  • 21 Jan 2021, 10:39 AM
  • 20 Jan 2021, 02:24 PM
  • 20 Jan 2021, 11:25 AM

Activity

Carlos Ruiz 
January 21, 2021 at 10:52 AM

The problem is just multiple tabs within the same window defined as zoom window in table.

In core the case is just visible in C_City (same field configuration in both tabs).

The SQL you provided in pull request doesn't use standard SQL syntax so it cannot be integrated in core, I'm looking for a standard SQL.

Andreas Sumerauer 
January 21, 2021 at 10:43 AM

modified the testbed to include the fringe case of the tabs having different field order.

 

Fixed

Details

Assignee

Reporter

Components

Fix versions

Affects versions

Priority

Created January 20, 2021 at 11:27 AM
Updated March 1, 2021 at 12:17 PM
Resolved January 21, 2021 at 4:30 PM