Skip to Main Content
Feature Request FR-4253
Product Area Shared Components
Status CLOSED

6 Voters

list of values with dynamic where clause

liran Public
· Feb 3 2025

Idea Summary
When using similar List of Values (LOVs), the only difference often lies in slight variations in the WHERE clause. It would be beneficial to have the ability to reuse the same LOV while applying additional filtering dynamically based on an extra field.

Use Case
For example, when using the EMPLOYEES_LOV, in Page 4, it is utilized as P4_EMPLOYEE_ID, with a filter applied where COMM IS NOT NULL. However, in Window 5, the same LOV should be used without any filtering conditions. This enhancement would allow for greater flexibility and reusability of LOVs across different scenarios.

Preferred Solution (Optional)

This request is likely a duplicate of FR-1988.

Comments

Comments