Download BLOB - dynamic text link
Hi apex users,
I have a report with a standard blob download columns, using the following SQL:
select a, b, filename, minetype, dbms_lob.getlength(blob_column) report_length
from table
*where [...]*
and the following format is applied to the "report_length" column:
DOWNLOAD:BLOB_TABLE:BLOB_COLUMNS:BLOB_ID::MIMETYPE:FILENAME:::inline:Download
It's work fine, but i'd like te personalized the "Download" link, and make it change dynamically:
I've read in the documentation that the link text supports substitutions strings, and try to test with:
DOWNLOAD:BLOB_TABLE:BLOB_COLUMN:BLOB_ID::MIMETYPE:FILENAME:::inline:#OWNER#
and it's work fine.
But what I want is to diplay the a column of my sql query:
DOWNLOAD:BLOB_TABLE:BLOB_COLUMN:BLOB_ID::MIMETYPE:FILENAME:::inline:#A#
DOWNLOAD:BLOB_TABLE:BLOB_COLUMN:BLOB_ID::MIMETYPE:FILENAME:::inline:#COL01#
But doesn't work. Am i missing something?
AkA