Hello Sir,
I have the following issue.
I have an interactive grid, when clicking on the columns the user is directed to the form. There he can edit the form, e.g. accept or reject it. Depending on this, the user is redirected to another page. I would now like that the next time the person clicks on a column in the interactive grid, this person is redirected to the corresponding page. That is, if he has already edited the form, he should be redirected to the page to which he was redirected when he accepted or rejected the form.
I have read your blog on a similar topic https://www.foxinfotech.in/2019/10/create-delete-row-button-for-interactive-report-in-oracle-apex.html
and wonder if it would also work for this case or what I would have to change here.
I proceeded as described in this tutorial.
I use the value of the status from interactive report to redirect to the corresponding page.
I use this code snippet from the blog in the interactive report.
5 case when nvl(STATUS,'APPROVED')='APPROVED' then 6 'f?p=&APP_ID.:100:8:&APP_SESSION.::::P8_ID'||ID 7 elsif nvl(STATUS,'REQUESTED')='REQUESTED' then 8 'f?p=&APP_ID.:100:9:&APP_SESSION.::::P9_ID'||ID 9 else 10 '#' 11 end LINK
But I always get the error: ORA-00905: missing keyword in line 6. Is something wrong with the URL?
Vinish Kapoor
Usage of elsif with the case is wrong. Below is the right syntax:
Ana
Hello Vinish thank you for your fast answer!:)
The redirection takes place when I only have one case, when I insert a second one I unfortunately get the error I already described.
Ana
Ok it works I just have to change the second it to:
case when......(first case)
when....(second case)
Thank you so much for this blog post!
Vinish Kapoor
You are right....