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!!!

Categories

ORACLE DEV
Oracle Applications
BI Beans
Oracle Call Interface ...
Database Mobile Server...
Business Intelligence ...
Service
Discrete Manufacturing
Customer Advisory Boar...
Communications and Media
PL/SQL XML Programming
SOA & Process Manageme...
JD Edwards EnterpriseO...
Data Guard
.NET Stored Procedures
Integration - Oracle BAM
Berkeley DB Family
Performance Tuning (Ko...
Oldies but Goodies (Ko...
Marketing
Hyperion System 9 BI+ ...
General CRM
BI for JDE (Archived)
Siebel Mobile
Enterprise Service Bus...
LCM: Oracle iSetup
Performance Testing
Business Process Manag...
SOA Governance
WebLogic Server - Secu...
Data Service Integrator
E-Business Suite Secur...
weblogic.developer.int...
weblogic.developer.int...
weblogic.developer.int...
weblogic.developer.int...
weblogic.developer.int...
AquaLogic BPM Newsgroups
WebLogic Event Server/...
WebLogic Server - Web ...
Primavera Portfolio Ma...
Primavera Contract Man...
小憩一会
WebLogic Server - Perf...
WebLogic Server - JCA
Performance Management...
Forums Moderator Migra...
Java 2D
Collections: Lists, Se...
Other Topics [ARCHIVE]
Systems Management Tas...
Virtual Desktop Infras...
Swing [Archive]
Sun Update Connection
Oracle VM Server for S...
Java Community Process...
Cloud Resource Model API
Oracle Net (SQL*Net、Ne...
Audit Vault and Databa...
Vdbench
Oracle WebCenter/Oracl...
Build
Java Sessions
Software-as-a-Service
Oracle Marketing Cloud...
Colorado Eloqua Users
Ohio & Kentucky Eloqua...
SiteCatalyst
Markies: Best Internat...
Business Intelligence ...
JDBC & UCP
OpenWorld & JavaOne La...
Oracle Marketing Apps
Interact 2014 Presenta...
OMC - Industry Solutio...
OMC - Industry Solutio...
Insurance
El Salvador
Oracle VM
AIOUG Social Group
Maintenance Management
Discussion - Accenture...
JavaOne
Oracle EMEA Partner Sales
Oracle Learning Library
Oracle SOA Suite 12c: ...
NightHacking
OTN Women in Technology
Containers, Docker, an...
Java Puzzle Ball
Dallas Eloqua Users
개발자 (Korean)
GRC General Discussion
Financial Consolidation
Budgeting & Planning
Tuxedo
weblogic.eventserver.g...
liquid.developer.inter...
dev2dev - BEA China
Telecom Technology (Ch...
Java Compiler (Develop...
Developer Studio C/C++...
Other Sun Hardware
Technical Questions
Oracle Cloud - General...
General FLEXCUBE Quest...
My Oracle Support - Li...
DevOps

Resources

Encrypt Message



code
soft
python
ios
c
html
jquery
cloud
mobile