I need to modify apex report sql query before it's execution. I need to fetch filter criteria provided by user. Then modify query according to filter criteria and then execute it.
Please provide any pointers on this.
Thanks in advance.
first comes to mind is using binding variables in your report query
page x has filter items Px_ITEM1 and Px_ITEM2
user enter values in these items and click on a search button (assuming you're not refreshing report dynamically)
have your report query like this will filter the query results
select * from table1 where col1 =:Px_ITEM1 and col2 =:Px_ITEM2;
hope that helps