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
from EMP
where (1=2 or upper(“ENAME”) like :apex$1 or upper(“JOB”) like :apex$2)
Hey, Rafael here.
And when/how does “:apex$1” or “:apex$2” get populated? Do you have an input on your page to set them?
I didn’t get the functionality you point here.
Nice blog though 🙂
Hi Rafael,
The “:apex$1” is getting populated by the search Item in your IG (It is the value of the default search item)
In the “$1”, the sequence is the column number in your report.
Please let me know if it not clear, I will send you the example.
Regards,
Mazin