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

1 Voters

Field showing LOV to store the original value

derik.tran Public · Jan 4 2024

Idea Summary
Can we have the field from LOV to store its original value even if the value's been end dated.

Use Case
Let's say I have a field called “Employee name” and it's a List of Value.  The query shows just a pick list of active employees.  User starts picking an active employee and everything works great.  The minute the employee record is no longer active, it just shows the employee_id instead of the name because the LOV dropped that record.

Preferred Solution (Optional)
Can we store the original display value until it's been updated?  Currently, we have to keep all employee records on the LOV because of this issue.

This request is likely a duplicate of FR-1988.

Comments

Comments

  • fac586 OP 1.7 years ago

    Duplicate of FR-1988

  • vincent morneau Admin OP 5 months ago

    @derik.tran thanks for pushing back, we will re-evaluate this idea.

  • vincent morneau Admin OP 5 months ago

    The team discussed this idea again and we decided to close again for the same reason: duplicate of FR-1988. With LOV parameters you would be able to design your LOV such as

    select name, id
  from employees
 where active_yn = 'Y' or id = :p_id

    This idea pertains to a SQL design challenge. There is likely many ways to solve the use case you describe, however FR-1988 is going to be the answer.

    I should also reiterate that this is doable today if the LOV is referencing a page item or an application item

    select name, id
  from employees
 where active_yn = 'Y' or id = :P1_ID