Skip to Main Content
Feature Request FR-4836
Product Area Page Components
Status OPEN

1 Voters

In an interactive report, when a column is based on a LOV, filter on the LOV value instead of the name

tduin Public
· Mar 19 2026

Idea Summary
When a column in a Interactive Report is based on a List of Value, and you filter on a specific value in that list, filter on the return value instead of the display value

Use Case
In our system, we use the Interactive Reports extensively. When a column is defined as ‘Plain Text (based on List of Values)’, and use a static list of values, these display values are entered in the application main language (English). We also translate the application in Dutch, thus these display values, are also translated. When an application manager adds a Public report on an Interactive Report, containing a filter on such a column, the filter works by comparing the display value instead of the return value. So when a filter is added as: Status = ‘Confirmed’, and a colegue, the report doesn't work for a collegue that uses the application in Dutch (because the display value is translated into 'Bevestigd' in Dutch.
in the query, this is added: nvl( "APX$LOV12"."DISP", d."STATUS") “STATUS”
and the filter is executed by: and "STATUS"=:apex$f1

Preferred Solution (Optional)
When a filter is added using the equal operator, filter on the return value of the static LOV

This idea is open.