Configure a layer feature description to search and replace text from a field

Permanently deleted user

January 09, 2014 07:22

I would like to embed a hyperlink in a Feature Description and for the hyperlink I need to use a filename stored in a layer field AND I need to strip off the file extension for the name that is stored in the field.  So, is there a way to configure a Feature Description to use a text search and replace?

Thanks.

-Tim

0

• 

  Permanently deleted user

  January 09, 2014 07:59

  Hi Tim

  depending on where  the data is stored you could create a 1:1 datalink for this so that you do all of the required formatting in the SQL statement ie something along these lines:

  SELECT     RFS_Id, CC_MAST_TYPE AS RfsType, CC_MAST_TYPE_SUBTYPE AS RfsSubType, CONVERT(NVARCHAR(25), RfsDate, 103) + N' - ' + CONVERT(NVARCHAR(25),

   

                        RfsTime, 108) AS RfsDateStr, '<a href=' + CHAR(34) + 'http://geo.rdc.govt.nz/BOPLASS/tiny/go.aspx?ORF' + RFS_Id + CHAR(34) + '> Open</a>' AS OzoneLink,

   

                        CS_PAR_SUE AS SUE, RfsDate

   

  FROM         dbo.vw_GIS_Sue_RFS

  The OzoneLink field then renders as follows:

  /customer/servlet/servlet.FileDownload?file=00P6000000eltozEAA

  regards

  Ralph

   

  0

Please sign in to leave a comment.