Discussions
Categories
- 385.5K All Categories
- 5.1K Data
- 2.5K Big Data Appliance
- 2.5K Data Science
- 453.4K Databases
- 223.2K General Database Discussions
- 3.8K Java and JavaScript in the Database
- 47 Multilingual Engine
- 606 MySQL Community Space
- 486 NoSQL Database
- 7.9K Oracle Database Express Edition (XE)
- 3.2K ORDS, SODA & JSON in the Database
- 585 SQLcl
- 4K SQL Developer Data Modeler
- 188K SQL & PL/SQL
- 21.5K SQL Developer
- 46 Data Integration
- 46 GoldenGate
- 298.4K Development
- 4 Application Development
- 20 Developer Projects
- 166 Programming Languages
- 295K Development Tools
- 150 DevOps
- 3.1K QA/Testing
- 646.7K Java
- 37 Java Learning Subscription
- 37.1K Database Connectivity
- 201 Java Community Process
- 108 Java 25
- 22.2K Java APIs
- 138.3K Java Development Tools
- 165.4K Java EE (Java Enterprise Edition)
- 22 Java Essentials
- 176 Java 8 Questions
- 86K Java Programming
- 82 Java Puzzle Ball
- 65.1K New To Java
- 1.7K Training / Learning / Certification
- 13.8K Java HotSpot Virtual Machine
- 94.3K Java SE
- 13.8K Java Security
- 208 Java User Groups
- 25 JavaScript - Nashorn
- Programs
- 667 LiveLabs
- 41 Workshops
- 10.3K Software
- 6.7K Berkeley DB Family
- 3.6K JHeadstart
- 6K Other Languages
- 2.3K Chinese
- 207 Deutsche Oracle Community
- 1.1K Español
- 1.9K Japanese
- 474 Portuguese
Dynamic download text for Download Blob

This issue rings a bell, though I thought it would either be fixed already, or my search-foo is failing me.
Classic report on a table with a blob, so I include a column type 'Download Blob'
I'd like the download text to be the filename, but this attribute doesn't seem to accept row-level substitutions. I can substitute a &P1_ITEM., but I have rows of data. I'd like the substitution to be relevant to the data within the row.
&FILENAME. syntax returns null, and alone it would be replaced by the 'Download' text
I also tried :FILENAME, which is cleared on save; and #FILENAME#, which returns verbatim.
An alternative, which I'm sure I've done before but couldn't find the example, was to embed the data within another column.
<span class="filename" data-filename="#FILENAME#">#CREATED_BY#</span>
Then run this JavaScript After Refresh of the region.
$('.filename').each(function() { $(this).closest('tr').find('td[headers=OUTPUT_BLOB] a').text( $(this).data('filename'));});
Is there a better way?
This is with APEX 18.2
Answers
-
Scott Wesley wrote:This issue rings a bell, though I thought it would either be fixed already, or my search-foo is failing me.Classic report on a table with a blob, so I include a column type 'Download Blob'I'd like the download text to be the filename, but this attribute doesn't seem to accept row-level substitutions. I can substitute a &P1_ITEM., but I have rows of data. I'd like the substitution to be relevant to the data within the row.
As would most people, but it doesn't seem to have been obvious or a high priority to Oracle. Nothing has changed since this confirmation that it is not supported: BLOB Support in Reports - Download Text
-
Hi Scott,
Have you got a better solution for using the filename as download text. I have a similar requirement. Pls let me know if you got any.
Thanks,
Renu
-
There is a feature request for this: FR-1574
-
Found a workaround :)
Just put following in “Download Text” attribute:
OPTION 1: Custom text based on the other column value (you can put FIle name):
<span>#COLUMN_NAME#</span></a>
OPTION 2: Image:
<img src="# WORKSPACE_IMAGES#.image1.png" height="16" width="16"> </a>
-
What version are you trying this in? Because it wasn't previously an option.
-
Hi Scott, in case this was not resolved yet, in APEX 21.1.3 the below worked:
<span aria-hidden="true" class="fa fa-arrow-circle-o-down"></span>
-
in case this was not resolved yet, in APEX 21.1.3 the below worked:
It looks visually ok. But APEX escapes and includes string from "Download Text" to anchor tag title and alt attributes.
If you hover mouse over icon, you should also see it.
-
Hi jariola, yes I noticed that the link text is showing when you hover over it. That's not pretty, but I guess it's the best we can do for now.
-
but I guess it's the best we can do for now.
True.
Just wonder what is function to have title attribute in anchor if it just same as text inside tag? Also why there is that alt attribute that is not valid for anchor if I understand correctly.