Skip to Main Content
Feature Request FR-2974
Product Area Page Components
Status CLOSED

5 Voters

LOV item with two different queries, one for displaying and one for selecting values

tasos Public
· Feb 14 2023

Idea Summary
It would be nice, the LOV item have two different queries, or where statements. One for displaying already saved values and one for the pop up or drop down select list

Use Case

I have an IG region that contains a LOV item with the employee id as value and the employee name as display. This IG region is displaying every employee, both active and retired. i want the pop up list to display only the active employees, but the item when not opened should show the display name  for every employee. If I reduce the LOV query to select only the active employees, the field for the retired employees will show the “other values” aka the employee id or it will be null.

Preferred Solution (Optional)

Add two source query parameters for the LOV item. Use the one query for rendering the popup or drop down list of available values. Use the other query to show the display value for any saved value.

This request is likely a duplicate of FR-1988.

Comments

Comments