0037097: Adaptive Filter by ID not working properly with table references using a not ID column as key column

Description

Adaptive filter by ID is not working properly with those fields based in table references that are using as key column a column which is not the ID column of the table.

The clearest example is the AD_Language table reference which is using the AD_Language (not the AD_Language_ID) as the key column.

Steps To Reproduce

1) As F&B Group Admin go to the Client window. Switch into the grid mode.
2) Click on the Language field filter drop down. Select a language in the list. As all the data is already loaded, adaptive filter will be performed.
3) Notice that no records are displayed --> ERROR
4) Click on the refresh button. Notice that the filter is now applied properly.

Proposed Solution

The problem is that the criteria applied by the filter uses the AD_Language_ID:

criteria:{"fieldName":"language","operator":"equals","value":"192","_constructor":"AdvancedCriteria"}

But due to the table reference configuration the value of the language in the local data is not the AD_Lnaguage_ID ("192") but the AD_Language ("en_US").

To fix this problem, the criteria generated by the filter should use the value of the key column in the table reference or transform it properly when applying the adaptive filtering.

Tags

No tags attached.

Attached Files

Relationships [ Relation Graph ] [ Dependency Graph ]

related to	design defect	0030312	acknowledged	Triage Platform Base	adaptive filtering is not working in selectors
related to	design defect	0025211	closed	AugustoMauch	Filter by selected value in FK uses identifier instead of ID
has duplicate	defect	0037452	closed	platform	Language filter is not working properly when there are few records on the grid.
has duplicate	defect	0037451	closed	AugustoMauch	Adaptive filtering is not applying the Country.Language filter properly

Notes
There are no notes attached to this issue.

Issue History
Date Modified	Username	Field	Change
2017-10-18 11:04	caristu	New Issue
2017-10-18 11:04	caristu	Assigned To	=> platform
2017-10-18 11:04	caristu	Modules	=> Core
2017-10-18 11:04	caristu	Triggers an Emergency Pack	=> No
2017-10-18 11:08	caristu	Relationship added	related to 0030312
2017-10-18 11:09	caristu	Relationship added	related to 0025211
2017-11-23 16:29	caristu	Status	new => acknowledged
2017-12-11 19:06	caristu	Relationship added	has duplicate 0037452
2018-02-07 14:11	caristu	Status	acknowledged => scheduled
2018-02-07 14:12	caristu	Review Assigned To	=> caristu
2018-02-07 14:12	caristu	Status	scheduled => closed
2018-02-07 14:12	caristu	Relationship added	has duplicate 0037451