Multi-Row search in interactive report within APEX

Doolius

Problem: I need to be able to search for multiple items within the same column of an Interactive Report.

I know there is a "Filter" that I can choose the column name from the first drop down, select "in" from the second drop down, and then either type or select the values I would like to show.

Is there a way to either:

1. Make the "Filter" box automatically show when the page loads so the User doesn't have to try and find it?

or

2. Make a new search box that will basically do the same thing as the "Filter" option?

AlexAA

Hi, Doolius

1. Make the "Filter" box automatically show when the page loads so the User doesn't have to try and find it?

Create DA with event "Page Load" and execute this javascript: gReport.dialog2('SHOW_FILTER');

You can create button, what will execute this javascript.

---

English is not my native language; please excuse my errors.

AlexAA

Hi, Doolius

1. Make the "Filter" box automatically show when the page loads so the User doesn't have to try and find it?

Create DA with event "Page Load" and execute this javascript: gReport.dialog2('SHOW_FILTER');

You can create button, what will execute this javascript.

---

English is not my native language; please excuse my errors.

Goran_1976

2. Make a new search box that will basically do the same thing as the "Filter" option?

It is possible using apex_ir.add_filter on item change or button click or ....

APEX_IR

Doolius

Thanks for the help AlexAA!

One more question, is it possible to automatically set the "Operator" to "in"?