Is there a way to format a DataLink field result to automatically display as a hyperlink?

Sean McClurkan

March 24, 2016 18:15

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

• 

  Permanently deleted user

  March 24, 2016 18:52

  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
• 

  Permanently deleted user

  March 24, 2016 18:58

  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

Please sign in to leave a comment.