Hi, I want to display a PDF in PDF viewer in perspective that is saved in DB in blob format using WebDev. this is the code I wrote in WebDev doget() my_pdf=system.db.runNamedQuery( "folderName/myNamedQuery" , {}) return {'contentType':'application/pdf','bytes':my_pdf} The above code doesn’t se…

Named queries return a dataset. You need to pull the blob content out of the dataset. Something like this: myds=system.db.runNamedQuery( "folderName/myNamedQuery" , {}) my_pdf = myds.getValueAt(0, 'myBlobColumnName') return {'contentType':'application/pdf','bytes':my_pdf}

Use PDF from DB to view in PDF viewer in perspective using WebDev

Ignition

pturmel May 12, 2022, 7:13pm 3

You might also find this helpful:

1 Like