Oracle APEX takes a value from a function and uses it to open a new page-CodePudding

I have a function that returns a value (e.g.27). I am put this value to my page item (P2120_SYMPTOM_ID) and i want with this value to open with button another page (P2140).

I am going to button Link builder - target and i am using P2120_SYMPTOM_ID like this:

but unfortunatendly this value doesn't pass to my new page criteria. How can i use this value?

CodePudding user response：

This is a common question, and relates to the fact the link uses values during page render, not what may have happened during interaction with the page

A common solution is presented in the Oracle forums here https://community.oracle.com/tech/developers/discussion/3725149/pass-client-side-state-to-modal-dialog

Alternatively, there is a free & supported FOEX Redirect plugin that also solves this problem https://fos.world/ords/f?p=10000:1080

CodePudding user response：

If you're just navigating to another page (as opposed to opening a modal window) then use action "Submit" on your button and create a branch to the new page. That is how navigation is supposed to be done. The link builder links are generated when the page is rendered and do not pick up session values.