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.