[SOLVED] how can i view a PDF Attachment directly from the Grid?

Jaymer

If I have a simple table that stores a PDF in the database, and I'm showing those lines on a grid...
normally you drill down to the Form, then click the attachment Widget and the attachment is shown in a popup.

I'd like to popup a window directly from the grid (to save a step) - lets say from a row operation button (or I could get fancy and trap a click on a grid column)

If it was an image, and it was in the filesystem, I could popup a window with an html cell using <img> and show the image like that.

How can I show the PDF directly from the grid?
Screen Shot 2021-11-22 at 11.41.26 AM.png

Without having to bring up a form and clicking in the widget:
Screen Shot 2021-11-22 at 11.42.54 AM.png

johntalbott

AwareApp.viewDocument might do what you are looking for.

To test it out, you could use an operation button that executes JavaScript with some hardcoded values.

AwareApp.viewDocument (BOName, BOID, BOAttributeStoringPDF)

Jaymer

johntalbott wrote
To test it out, you could use an operation button that executes JavaScript with some hardcoded values.

Yes, this works quite nicely:
Screen Shot 2021-11-22 at 6.09.06 PM.png

But I need to dynamically get the ID in there. Tried several things.

johntalbott

This should do the trick.

const id = parser.m_highlightedRow.refValue.split(":")[1];

AwareApp.viewDocument ("ReqLines", id, "ReqAttachment");

Jaymer

yep, thx!

karelh

Hey Jaymer,

We simply have a process that runs the following command.
DOWNLOAD DOCUMENT BO.DocAttr

If its a PDF it will open in the browser.

Jaymer

Thx K
Yes, thats more what I was originally thinking. I rarely (if ever) use DOWNLOAD DOCUMENT. Early on, I was thinking I'd make a report with the Document inside it, then DISPLAY DOCUMENT. Less than ideal. So I asked here thinking I was missing something obvious - which I was.

I tried it, but I like it my original way... for these reasons:
1) Even on my machine, it downloaded the file, requiring a click to open it. Would hate to hassle with a group of users and make them install the viewer plugin (or whatever settings allow it to auto display)
2) Opened in new tab - vs. Popup. I actually like the popup in this case to briefly view the PDF.

My Code (with help from John):

var theID = parser.m_highlightedRow.refValue.split(":")[1];
AwareApp.viewDocument ('ReqLines', theID , 'ReqAttachment')

--> JaymerTip Display PDF directly from Grid