Oracle Application Express (APEX)
Popup LOV Search properties
I created an application in APEX 4.0. On several of the pages I placed popup LOVs. The displayed value is a document number concatenated with a character string description. When I search for a value based on document number I want to be able to enter it with a wild card such as '60%'. When I click the Search button on the LOV dialog I get everything with '60' anywhere in the displayed value but what I want is everything beginning with '60'. Does the serach feature on LOVs ignore wildcards and is there a way to enable it?
Hi The standard Popup LOV searches exactly like you have described. I believe it uses the CONTAINS clause meaning that as long as the character you typeis somewhere in the string, it will be selected. I have not found any way to customize this using APEX properties - so do not believe this is possible. What you can do instead, is use a plugin, like the "Select2" :https://apex.world/ords/f?p=100:710:9001516121925::::P710_PLG_ID:BE.CTB.SELECT2
Related Links
Procedure call results in timeout when called from APEX but runs fine from SQL Developer
Dynamic page
Translate Inline Validation Errors
custom Authentication Schemes in apexea.oracle.com
Oracle XE 11.2 Tablespaces
How to get non-duplicate numbers in the scale of the Y-axis of a chart
Not all columns appear in IR search list
Migration from development to production environment
apex
APEX Chart Links
How to hide the "Edit Pivot" box in interactive report with pivot
APEX Demo applications CSS location ?
Barcode IDAutomationHC39M implementation in apex 5
Cannot connect remotely to APEX5 server anymore after upgrade from APEX424
How to set Title of Popup Lov in V5.0
Take too much time to load 3000+ data in "Select list" item in APEX!!!