Hello Community,
I have following issue, that I just can't find a solution for.
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 number 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 the value of form id.
I tried these both methods:
Building own url DECLARE
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;
2. apex_page.get_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 :=apex_page.get_url(p_page => l_branch_page,p_items=>l_id)||:P8_ID;
end;
One important note, the :P8_ID is set, so the value is known here.
Can you please help me here?