Skip to Main Content
Feature Request FR-3800
Product Area Page Components
Status ROADMAP

29 Voters

Popup LOV Filter Option Value% Vs %Value%

jon dixon Public · May 18 2024

Idea Summary
Currently, when filtering a Popup LOV, the default is to search across the entire field. If you have values 000123 and 123000 and start typing 000, both values will be included in the filter result. While in many cases, this is preferred, in many other use cases, it is preferable to have a value% filter rather than a %value% filter.

Use Case
In situations where end users typically know the value they want to enter (e.g., when entering financial account values, project numbers, cost center numbers, etc.), it is much faster for them to enter the values if the filter works from left to right, i.e., value %. This can also improve performance, as the value% filter will use indexes. I have encountered this requirement with several customers where the input speed is essential for end users.

Preferred Solution (Optional)
Ideally, there would be a declarative selector for Popup LOV page items, where you can select the filter style as value% or %value%. As a bonus, it would be nice to also have an option to decide if the filter should ignore the case of the entered filter criteria.

This is planned for a future APEX release.

Comments

Comments

  • juancarlos OP 7 months ago

    Perfect.

  • divisi0n OP 7 months ago

    Not in the field settings, but in the LOV column settings (search => yes (Value%), yes (%value%), no) instead of a checkbox.

  • carlos.ramirez OP 7 months ago

    Additionally, it would be great if the search could update dynamically as one types in the box, ensuring a dynamic display of search results.

  • vincent morneau Admin OP 6 months ago

    Hi @jon dixon 

    With APEX 24.1 out, I'd like to circle back to this idea. Now that APEX has Combobox, Select One and Select Many, and they all support an attribute called “Match Type” 

    Do you think that fulfills your requirement if you were to switch your Popup LOV item to one of those new components?

  • jon dixon OP 6 months ago

    Hi Vincent,

    Select One with the ability to return the ID, search by the Value, and display anything you want on the drop-down list is perfect. Add to that the fact that it also defaults the value if you tab out and only have one value in the list and you have the perfect Item Type. Wow!

    It would still be nice to have Match Type on the Popup LOV :)