Thanks for sharing! :-) It has been very useful for me! A quick remark regarding the code shared for the filename link (2:24 in the video), there is a comma missing after 'PDFViewer' in the highlighted code - correct version below. javascript:apex.event.trigger(document, 'PDFViewer', [{id:'#ID#'}]);void(0); Thanks again for sharing!
Hi Nuno Belo, I'm new to Apex, at 3:20 in video there's a query in that mimetype and essay selected as columns. If I don't have such columns in my table shall I select any other columns in query? Kindly help me here
@@harikanth4336 Hi, first and foremost I'm not an APEX expert either :-) Nonetheless, this video, as far as I can tell, assumes that the PDF that you want to display is already stored in the database as a BLOB - as mentioned at the beginning . If that is not your case then I don't know if this approach (exactly as described in the video) would apply to you. But, as long as you have a REST endpoint that returns the PDF in the correct format based on the provided ID it should work but, the steps to set it up would obviously be different. Regarding the BLOB and the MIMETYPE columns that you're referring to, they don't have to be in the same table; you can have a separate table for this data as long as you can leverage the ID of your parent table to perform a lookup. In this case your REST service would reference the table that you like and the where clause would still need to consider the ID to make sure that you're pulling the correct PDF. regards, NB
Thanks for the useful video! Question: how can we restrict access to the restful service and still use its link as a source of ? As of now it seems that our pdf will be available to anyone when pasting Restful Service link a in browser string.
Thanks for sharing, I am getting error If I chose Media Resource in RESTFULL (Handler), If I change to collection query I getting raw data, What is missing with Media Resource as Source Type?
Hi Amazing video.... !!! Thanks for sharing... quick help ===> I have 2 sources of TXT & PDFs files one is a directory folder and Bucket in oracle cloud.... is it feasible to do something similiar what you explain here? please some tips!
I'm getting "404 Not Found". Is ORDS related issue I believe. I couldn't find the code in the description so I had to type it from the Video. Maybe I got something. Your help will be very much appreciated. Cheers.
The request could not be processed because an error occurred whilst attempting to evaluate the SQL statement associated with this resource. Please check the SQL statement is correctly formed and executes without error. SQL Error Code: 1722, Error Message: ORA-01722: invalid number
In the Link URL, you need to pass three parameters in apex.event.trigger: pSelector,pEvent, and pData. comma is missing between the second and the third parameters in the code shown in the popup at @2:23. Use this code javascript:apex.event.trigger(document,'PDFViewer',[{id:'#ID#'}]);void(0); Here replace #ID# with the primary key column of your report.
Thanks for sharing! :-) It has been very useful for me!
A quick remark regarding the code shared for the filename link (2:24 in the video), there is a comma missing after 'PDFViewer' in the highlighted code - correct version below.
javascript:apex.event.trigger(document, 'PDFViewer', [{id:'#ID#'}]);void(0);
Thanks again for sharing!
Hi Nuno Belo,
I'm new to Apex, at 3:20 in video there's a query in that mimetype and essay selected as columns. If I don't have such columns in my table shall I select any other columns in query? Kindly help me here
I got it for mimetype but please help me on essay column
@@harikanth4336 Hi, first and foremost I'm not an APEX expert either :-) Nonetheless, this video, as far as I can tell, assumes that the PDF that you want to display is already stored in the database as a BLOB - as mentioned at the beginning . If that is not your case then I don't know if this approach (exactly as described in the video) would apply to you. But, as long as you have a REST endpoint that returns the PDF in the correct format based on the provided ID it should work but, the steps to set it up would obviously be different.
Regarding the BLOB and the MIMETYPE columns that you're referring to, they don't have to be in the same table; you can have a separate table for this data as long as you can leverage the ID of your parent table to perform a lookup. In this case your REST service would reference the table that you like and the where clause would still need to consider the ID to make sure that you're pulling the correct PDF.
regards,
NB
Hi NB, thanks a lot for taking time to explaining in detail. I have understood now.
I HAVE ERROR, PAGE NOT FOUND. DO U HAVE AN IDEA WHAT COULD BE PROBLEM? THE CODE IS THE SAME AS IN EXAMPLE. THANKS
Thanks for the useful video!
Question: how can we restrict access to the restful service and still use its link as a source of ? As of now it seems that our pdf will be available to anyone when pasting Restful Service link a in browser string.
Nice short tips for this! Thanks for posting this video
Thanks for sharing, I am getting error If I chose Media Resource in RESTFULL (Handler), If I change to collection query I getting raw data, What is missing with Media Resource as Source Type?
Thanks for sharing, it really helped. One thing, you are missing a coma on the code that you are sharing in the minute 2:23
What is the best way or recommendation to design, and create a PDF report to view database data and deploy from Oracle APEX?
Thanks for sharing!
3:21 what is the ESSAY column does ?
your blob column
Hi Amazing video.... !!! Thanks for sharing... quick help ===> I have 2 sources of TXT & PDFs files one is a directory folder and Bucket in oracle cloud.... is it feasible to do something similiar what you explain here? please some tips!
I'm getting "404 Not Found". Is ORDS related issue I believe. I couldn't find the code in the description so I had to type it from the Video. Maybe I got something. Your help will be very much appreciated. Cheers.
The request could not be processed because an error occurred whilst attempting to evaluate the SQL statement associated with this resource. Please check the SQL statement is correctly formed and executes without error. SQL Error Code: 1722, Error Message: ORA-01722: invalid number
hello thanks for your efforts, please how can i prevent download file ?
I want to open pdf url in new page
May I've got some documentation about?
Excellent
has anyone here succeeded or made it work? followed the video and failed twice. Getting a javascript error.
Nice blog...but getting javascript error on File_Name column link click...! Can anyone able to help me?
In the Link URL, you need to pass three parameters in apex.event.trigger: pSelector,pEvent, and pData. comma is missing between the second and the third parameters in the code shown in the popup at @2:23. Use this code javascript:apex.event.trigger(document,'PDFViewer',[{id:'#ID#'}]);void(0); Here replace #ID# with the primary key column of your report.
Hi, Do you fixit? Because I think that I have the same problem.
Please Share your code
WOOOOOW
how to disable download and save buttons in PDF viewer...if any one know please share the link of the video or code
i am search for that if you have video please send to me
shere the code ..........
Share your code with us