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!

How to open pop up or dialog for a pdf from a link defined in a global page report query?

Hello everyone,
I have defined in a global page a report with llink to open a pdf. This is already working. The link captures the file from an application process.
But I would like to open the pdf file in a pop up or dialog. I could define a javascript function but the global page has no function option and declaration of global variables.
I have my link defined as follows in the report query:

select ID,
       '<a href="'||apex_util.prepare_url('f?p=&APP_ID.:&APP_PAGE_ID.:&APP_SESSION.:APPLICATION_PROCESS=GETFILE:NO::FILE_ID:'||ID)||'">View</a>' view,
       ...
from ERP_FILES

This opens another page to show the pdf file, but how do I get it to open in a pop up or dialog?
A reinforcement note is that I'm doing this on a global page where the report is used on other pages. I'm using apex 21.2.
Thanks.

This post has been answered by Joseph Upshaw on Feb 8 2022
Jump to Answer
Comments
Post Details
Added on Feb 8 2022
8 comments
2,609 views