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!

Oracle APEX 20.2 - Clearing display only page item

Srini-SJan 12 2022

I have a page item (PX_MAIN) that is display only, send on submit set as no and it draws its value (it is set) whenever current page is accessed from other pages using a link in the IG or clicking on button etc. Once we are into the page, we have other page items, buttons etc. that use this page item PX_MAIN as parent to display other relevant data. Also, while loading the page, the page item PX_MAIN is used in many regions' queries.
We now have a requirement to clear this page item , query another value using another page item(PX_MAIN_ALTERNATE) . Once a value of PX_MAIN_ALTERNATE is selected, PX_MAIN again gets populated and drives all other page items as usual. Here, instead of using a value that was set in another page , we would like to use a value that is selected in this page itself. This works well without any problem.
Once page items gets cleared, user may want to visit another page and re-visit this page and at that instance, this page item's value seem to be re-appearing. Du to that, all the queries that use the page item also use the previous value during page load which is un-necessary. Also, user has to choose to clear again.
How do I ensure that the cleared page item's value doesn't re-surface?

This post has been answered by fac586 on Jan 12 2022
Jump to Answer
Comments
Post Details
Added on Jan 12 2022
2 comments
2,152 views