Hello,
I have an interactive report based on a quite huge underlying table and fulltext search (without specifying any criteria) takes quite a long time, but I would like to keep the builtin IR functionality without writing any complicated custom filtering. If I create an IR on an EMP table, the underlying query without parameter specification looks like this:
select * from (
select EMP.EMPNO as EMPNO,
EMP.ENAME as ENAME,
EMP.JOB as JOB,
EMP.MGR as MGR,
EMP.HIREDATE as HIREDATE,
EMP.SAL as SAL,
EMP.COMM as COMM,
EMP.DEPTNO as DEPTNO
from EMP EMP
where ((instr(upper("EMPNO"),upper(:APXWS_SEARCH_STRING_1)) > 0
or instr(upper("ENAME"),upper(:APXWS_SEARCH_STRING_1)) > 0
or instr(upper("JOB"),upper(:APXWS_SEARCH_STRING_1)) > 0
or instr(upper("MGR"),upper(:APXWS_SEARCH_STRING_1)) > 0
or instr(upper("HIREDATE"),upper(:APXWS_SEARCH_STRING_1)) > 0
or instr(upper("SAL"),upper(:APXWS_SEARCH_STRING_1)) > 0
or instr(upper("COMM"),upper(:APXWS_SEARCH_STRING_1)) > 0
or instr(upper("DEPTNO"),upper(:APXWS_SEARCH_STRING_1)) > 0
Let's say that columns SAL, COMM and DEPTNO are not important for my searching but I would like to expose them in search results. Is there any way how to specify what columns I want to search and if not, can I disable the fulltext search at all and force users to specify the search criteria?
If non of that is possible, what would you suggest?
Any help would be highly appreciated.
Regards,
Pavel