Now when you change the select list value you will get alert message with the value of it.
APEX_ITEM.SELECT_LIST_FROM_QUERY(3,job,'SELECT DISTINCT job FROM emp','onchange="alert(this.value);"')
user13153795 wrote:Okay, give more details like how do you want to apply filter?
Thanks for your answer.
Yes I have done that and when I change one of the select lists it gives a alert with the ID of the selected value. So that seems ok.
The report is now a interactive report, so I want to dynamically filter that report based on these values of the select lists.
And just under that Add this item name into Page Items to Submit
where id = :P1_MYID
user13153795 wrote:your question is wrong...a because the region is already refreshing.
Thanks it's working!!
Do you also know a solution how to refresh the report based on multiple select lists because it is now only working with one?