Hello ,
We have a table with id and a blob file that stores pdf, docx etc
We want to create a report in BI Publisher like the following
id Download-Link
---------------------------
1 Link1
2 Link2
.. Linkxx
When clicking at Link1 Link2 ..etc a download of the blob ( pdf or docx ) must start.
Although i got an answer that BI does not support this feature (only images not pdf) i found an unofficial hack at the following address.
https://support.oracle.com/epmos/faces/DocumentDisplay?_afrLoop=357738351345703&id=2106746.1&displayIndex=7&_afrWindowMode=0&_adf.ctrl-state=165xa8gsmc_4
However i can't understand how i can achieve this. I am new to BI and i know to create data models and reports but i cannot understand how to set the following
Prefix:
<a href="" id="myLink">Download File Again</a>
Narrative:
<script>
var fname= '@2';
var hexdata= '@4';
Postfix:
var byteArray = new Uint8Array(hexdata.length/2);
for (var x = 0; x < byteArray.length; x++){
byteArray[x] = parseInt(hexdata.substr(x*2,2), 16);
}
var blob = new Blob([byteArray], {type: "application/octet-stream"});
var a=document.getElementById("myLink");
a.href = window.URL.createObjectURL(blob);
a.download = fname;
a.click();
</script>
Thank you
