CODEWITHSUNDEEP
oracle-databaseplsqloracle-apex
Muhammad Bekette
Muhammad Bekette

Reputation: 1434

Add Extra criteria to Interactive Report Oracle Apex

I need to add extra parameter to the interactive report for searching criteria. and I need it to be processed when I press the Go button in the interactive report. what I have is the text box but when searching the values entered never reflects in the report when I press the Go button. Any Help?

Upvotes: 1

Views: 272

Answers (1)

Jeffrey Kemp
Jeffrey Kemp

Reputation: 60312

If you have a text item, e.g. :P1_SEARCH, you can refer to it in the query in your interactive report, e.g.

SELECT ...
FROM   mytable t
WHERE  INSTR(UPPER(t.mycolumn), UPPER(:P1_SEARCH)) > 0;

To have the report pick up the value whenever it is refreshed (e.g. from the Go button), make sure to add the item name to the Page Items to Submit attribute, i.e. P1_SEARCH.

Upvotes: 1

Related Questions