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!

Generating a conditional link in an Interactive Report

HawkerHunterNov 20 2020

Hello Friends,
I am working on an Interactive Report in Oracle APEX 19.2 where I have a column containing Links to an edit/view page. Based on value of another column in the report I have to enable/disable the link.
I have used case statement in the sql query for the report region. For active link I have used the following:
'<a href=f?p'||:APP_ID||':10:'||'&SESSION.'||'::::P10_ID:'||ID||'>'||BOOK_NAME||'</a>'
In the above link, the target page number is 10 and I have to update P10_ID page item in the target page with the ID value of the selected row of the Interactive report.
And for the above link column I have disabled the "Escape special characters" under security section in the properties window.
When I run the page, the link is appearing properly, however when I click it, it gives an error saying "No checksum was provided to show processing for a page that requires a checksum when one or more request, clear cache, or argument values are passes as parameters."
Can anyone please let me know how can we provide a checksum in the link when we pass argument values as parameters.
Thanks & Regards
Hawker

This post has been answered by HawkerHunter on Nov 20 2020
Jump to Answer
Comments
Post Details
Added on Nov 20 2020
5 comments
6,906 views