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

Openbravo Issue Tracking System - Openbravo ERP

View Issue Details

Project

Category

View Status

Date Submitted

Last Update

0037097

Openbravo ERP

A. Platform

public

2017-10-18 11:04

2018-02-07 14:12

Reporter

caristu

Assigned To

platform

Priority

high

Severity

minor

Reproducibility

always

Status

closed

Resolution

open

Platform

OS Version

Product Version

Target Version

Fixed in Version

Merge Request Status

Review Assigned To

caristu

OBNetwork customer

Web browser

Modules

Core

Support ticket

Regression level

Regression date

Regression introduced in release

Regression introduced by commit

Triggers an Emergency Pack

Summary

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.

Additional Information

Tags

No tags attached.

Relationships

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