How to embed a hyperlink into Data Link SQL command

Yvette Ostrovsky

7. November 2020 00:32

Hi,

I have the following command in a Data Link

SELECT PID as [PID Number]

, DPAREA1 as [DP Area (1)]

, DPAREA2 as [DP Area (2)]

, DPAREA3 as [DP Area (3)]

, ALR

, FLOODPLN as [Flood Plain]

,Zoning as [Zoning]

, CONCAT(CONCAT('https://gis.mycity.ca/Utilities/ZoningPDF/', ZONING), '.pdf') as [Zoning PDF] 

FROM ZONING WHERE PID = 1

 

I would prefer that Zoning PDF column doesn't show a full URL but rather appears as a hyperlink for Zoning.

something like <a href=" https://gis.mycity.ca/Utilities/ZoningPDF/{ZONING}">Zoning PDF</a>

 

How to format the Command in this case to embed a hyperlink into Data Link SQL command ?

 

thanks

 

? 

0

• 

  Cam Barnard

  18. November 2020 00:21

  Hi Yvette,

   

  I think you are looking for the Geocortex Essentials / Geocortex Viewer for HTML5 forum.

  Check it out here: https://support.geocortex.com/essentialsGSCForum?feedtype=RECENT&dc=Geocortex_Viewer_for_HMTL5&type=html5&sub-nav=forum&main-nav=essentials&page=1

  0

Bitte melden Sie sich an, um einen Kommentar zu hinterlassen.