Skip to Main Content
Feature Request FR-4831
Product Area Page Components
Status OPEN

1 Voters

Enhance Popup LOV search with wildcard functionality

christoph.hillinger Public
· Mar 13 2026

Idea Summary
We replaced old Autocomplete Plugins with Popup LOVs. The customer was used to use % as a wildcard in the searches, something that does not work in the new Popup LOVs. 

Use Case
If you have a bigger search string it would be nice to use for example given name and part of the surname and still be able to find something. Same goes for a full address where you want to search for part of the street name and the postal code.

Preferred Solution (Optional)
I would propose a declarative option to active a wildcard search. If this is activated, you can use % and _ same as in an SQL LIKE statement.

This idea is open.

Comments

Comments

  • vincent morneau Admin OP 2 days ago

    APEX 24.2 added a new Popup LOV search attribute that addresses much of the same use case: Match Type, with options for Starts With and Contains. Does your requirement go beyond that?

  • christoph.hillinger OP 2 days ago

    My requirement goes beyond that.

    It is actually only relevant for „contains“. 
    What I propose is a Parameter that will treat % not as a literal character but as a wildcard.

    At the moment the search string „sesa%str“ will only match values that actually contain this exact string. I would love for it to also match „sesame street“.

  • vincent morneau Admin OP 44 hours ago

    Thanks, will reevaluate soon.