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

2 Voters

Select One/Many item to allow wildcards

reto.tschan2 Public
· Aug 5 2025

Idea Summary
In the Select One/Many item, Live Search does not interpret % or _ as SQL wildcards.  It would be helpful to have the option to choose how they should be interpreted, whether as part of the text or as a wildcard.

Use Case
If I have many values in my LOV result that follow a specific pattern, I want to be able to narrow the search using wildcards. Example values: bp_aml_report_internal, bp_aml_report_external, asset_aml_report, account_aml_report_internal, bp_aum_report_internal, bp_aum_report_external, some_other_value,… I would like to search, e.g. with “bp%internal” to return only values that follow the “like ‘bp%internal’" criterion.

Preferred Solution (Optional)
Have the option (checkbox?) to declaratively choose if % and _ should be interpreted as wildcards. Ideally, an escape character could be defined as well. This could be placed in the “Settings” section of the item.

This is currently on the roadmap for a future release of Oracle APEX.