When you are dealing with huge data, you need to limit your end user loading all the data from database without applying any parameter to the report.
Here we have an option to do it. There is parameter in IG that calls “apex$x” where x is the number of columns in your IG.
select EMPNO, ENAME,
JOB, MGR, HIREDATE,
SAL, COMM, DEPTNO
where (1=2 or upper(“ENAME”) like :apex$1 or upper(“JOB”) like :apex$2)
The first setup of an application is always a time consuming activity. To reduce that for all APEX developers I have create a template application with custom login functions.
The package includes all tables and functions you need to up and run you complete APEX application with a few clicks.
You can download the complete app
User the below code to get your own username en password
l_user_pwd := APP_SECURITY_PKG.get_hash('firstname.lastname@example.org','Welcome01');
usr_name = l_user_name,
usr_pwd = l_user_pwd
usr_id = 1;
Any question? drop a comment.