Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How can I clear the values in select list after passing them to a query for a classic report?

L_a_u_r_aSep 9 2022

I am testing some apps in a Test instance that has been upgraded from APEX 20.2 to 22.1.3. One of my app has 4 select lists and the values are used in a SQL query Classic Report. I want to be able to see the results in the report and clear the select lists. Right now I have a Dynamic action on a button that (1) Submits page and gives me results and (2) Sets values for the select list to null. This worked fine in APEX 20.2. But in 22.1.3, it is not showing the results in the Classic Report. If I set the Server-side condition to 'Never' in the Set Value action in the Dynamic Action I get results, but it is keeping the values in the select list and not clearing them. Any ideas?

Comments
Post Details
Added on Sep 9 2022
2 comments
814 views