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

3 Voters

Allow multiple search patterns in select List/Popup LOV

vaishnavi.vaidya Public · Jan 29 2024

Idea Summary
Allow multiple search patterns in select List/Popup LOV

Use Case
When we use select list/Popup LOV to search certain record, it shows all records that “contain” the value we have typed in. Sometimes when the count is too high, it becomes difficult for the user to scroll down and look for the exact record. 

If the Select List/Popup LOV has an option to decide search pattern like “starts with”, “Ends with” or “contains” helps developer selecting the appropriate one as the business needs.

This is a great idea! You can already achieve this in APEX today with a slightly different approach.

Comments

Comments

  • ronny.weiss2 OP 1.3 years ago

    Hi @vaishnavi.vaidya thank you for submitting this idea! Today we closed it because you can achieve this by using Oracle Text for your Popup LOV Item. You need for this a shared LOV that you can create in Shared Component => List of Values. There you can set an Oracle Text Search Column. After this you can set a Oracle Text Function in your App Definitions and this function can provide the desired behaviour. There also a good sample for such a function in the page designer help of this attribute. With Oracle Text you can also support a Fuzzy search that provides a much better user experience for end users.

    Kind regards

    Ronny

  • saurabhshirke1441 OP 7 weeks ago

    @ronny.weiss2 do you have post, demo explaining above steps