enable IR Search field to search in the hidden columns
Hello friends,
I am using apex 4.1.
I must hide phone number columns in my IR report, but at the same time the values of that columns should be available to search for using IR Search Field. is there a way to do this ????
if not, that means I have to :
1- Add a text filed P1_PHONE
2- edit my report query to something similar to
> Select * from Table where :P1_phone in (mobile1,mobile2) or :p1_phone is null
3- add button to refresh the report.
but the item P1_PHONE should be on the header of the Report region. is there a way to do this.
I am using theme 23
page template without sidebars
Report template : Reports Region.
Or maybe you can direct me how to put the item P1_PHONE on the tab of the page. Just similar to the Search item of in the Application Builder.
Best Regards,
Fateh