Oracle Apex Search in Report

1:15 PM

You can search in the Report with the following method :

TOP LEVEL PAGE LOAD:

$('#P31_SEARCH').keyup
(
function(evt)
{
$('#sid').trigger('apexrefresh');
}
);

Static ID : sid (In search region)

Where Condition in Query :

UPPER(LTRIM(RTRIM(NAME))) LIKE '%'||UPPER(LTRIM(RTRIM(:P31_SEARCH)))||'%';