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.