Is there a way to format a DataLink field result to automatically display as a hyperlink?
Essentials 4.4.3 HTML5 2.5.2
I've got a UNC filepath stored in a database column and I'm selecting that value in a Datalink. I'd like for the DataLink result to automatically display the filepath as a hyperlink to the document on the network. Example:
SELECT '<href a="file:' || a.dospath || ' target="_blank">' || a.attacmentdesc || '</>' "Document"
FROM attachment a
WHERE ....
Which returns this in the database:
<href a="file:\\COACD.ORG\DFS\PIERIMAGES\SitePlan\2016\SP-2016-0091DS_0\SPL-SP-2016-0091DS_0~001.PDF target="_blank">SPL-SP-2016-0091DS_0~001</>
But Essentials Manager won't let me save a Datalink with that SELECT clause - I think it sees it as a SQL/Markup Injection threat. Is there a way to select these values in a Datalink so they are readable as a hyperlink?
If there were only one document per feature, I'd just put the field in the Feature Description, or use a Feature Hyperlink, but there are many documents for a given feature, so I'd like to present a list of hyperlinks instead.
Thanks!
0
-
using href I believe only works in the feature description. If you want a link to work from a field in the database, it needs to start with "http://" and will likely require your network.server guys to create a virtual directory to use in the URL. 0 -
As an example, this value can be found in one of my layers:
http://imaps.ci.santa-rosa.ca.us/img/SewerPDFs/HH2801.pdf
Not sure you can build a URL on the fly based on linked in data, but if the value is in the table already, it can be used in a one to many join.0
Bitte melden Sie sich an, um einen Kommentar zu hinterlassen.
Kommentare
2 Kommentare