I am sorry to bothering you with this again..
But I'm just not getting anywhere with the following.
The issue is that a user logs in and should be redirected to the corresponding page when clicking the 'Go to last status' button.
The corresponding page is stored in a table together with the ID and is always updated when the status changes.
In order to know which page should be redirected to for this form ID, I use a function that outputs the page as a return value.
I use this result to build the URL and save it in a page element.
I use URL Identified by Item as the type for the branching process.
Unfortunately I always get an error no data found.
Here I am not sure how to pass on the ID of the form.
I tried these both methods:
- Building own url
DECLARE l_branch_page number; l_id number; begin select ID into l_id from TABLE1 where ID=:P8_ID; l_branch_page:= FORWARDING_TO_PAGE(:P8_ID); :P8_URL :='f?p=&APP_ID.:l_branch_page'|| ':&APP_SESSION.::NO::l_id'|| ':'||:P8_ID; END;
DECLARE l_branch_page number; l_id number; begin select ID into l_id from TABLE1 where ID=:P8_ID; l_branch_page:= FORWARDING_TO_PAGE(:P8_ID); :P8_URL :=apex_page.get_url(p_page => l_branch_page,p_items=>l_id)||:P8_ID; end;
Perhaps an important note, the :P8_ID is set, so the value is known here.
Can you please help me here?