hyperlink to data link drilldown

Permanently deleted user

October 17, 2012 01:54

Hi Everyone

 

 

Newb Essentials user, 3.10.1, SL viewer 1.6... Posted this in another thread but thought I might get more activity on it if I started a new thread... Hoping somebody has figured this out.

 

 

 

 

I created a data link to a SQL table for an external Asset management system. The data link was set up against one of the fields in our parcel layer. The data link works fine, returning records in a 1 to* as expected, two fields.

 

 

What I would like to do now is set one of these two fields to be a hyperlink that calls another data link that uses that value as a parameter in the SQL query that is passed by the data link. Sort of a drill down. The first data link returns a list of Addresses that are related to a parcel, there may be one or more. I want the user to be able to go to the data link tab in the identify window and then be able to click on one of the returned address records and it will  query for active construction permits for that address...

 

 

 

 

Thanks for any light you can shed

 

Todd Mayer

0

• 

  Permanently deleted user

  October 17, 2012 03:03

  Hi Todd

  if you add another field that is an url to your secondary search it will show up as a link in the linked data table

  ie

  SELECT     ValNum AS Valuation

   

  , Improvements

   

  , LegalDesc

   

  , AreaHa

   

  , Address

   

  , 'http://gisagsdev.rdc.govt.nz/launchOzone.html?arg=theozone://|/E|LIVE|/S|WINDOWS|/F|RT2000|/ID|' + RTRIM(ValNum) AS OzoneLink

   

  FROM         vw_GIS_Sue_Valuation

   

  WHERE     (SUE = @SUE) and CancelDate is null

  Let me know if that doesn't make any sense

  Ralph

  0
• 

  Permanently deleted user

  October 17, 2012 22:27

  Ralph

  Makes perfect sense, and with your help i have made alot of headway towards accomplishing this...Thanks!

   

  So my idea was to be able to call a different datalink via a hyperlink right?  So it dawned on me that I could call the rest end point of a datalink and pass a parameter to it.

  This example is calling the same data link, but I needed to verify that it would work before i went to the trouble of creating a view on my database and creating another datalink...

  SELECT ADDRKEY, PRCLKEY, 'http://vmgsbeta.ictlan.gov/Geocortex/Essentials/Todd/REST/sites/Todd1/map/mapservices/2/layers/0/datalinks/HansenData/link?maxRecords=&pff_PRCLID='+ RTRIM(PRCLKEY)+'&f=html' AS Permits FROM Hansen822.PROPERTY.ADDRPRCL WHERE PRCLKEY = @PRCLID

   

  And it works nicely, passing the PRCLKEY value as the needed PRCLID= parameter...

  The result looks like this:/customer/servlet/servlet.FileDownload?file=00P6000000e88IwEAI

   So now all i need is to figure out how to present the URL in Permits as just a single number or word... like "drilldown" or something instead of the long URL...

  Any ideas

   

  Thanks again!

  Todd

   

   

  0
• 

  Permanently deleted user

  October 18, 2012 01:59

  Hi Todd

  I am sure some people would say to use Feature Hyperlinks not I am not sure that it has improved when there is more than one feature as per my forum message here:

   

  (https://support.geocortex.com/essentialsGSCForum?id=906600000000AoEAAU) Hyperlink in Feature Long Description *  

   

  and here:

   

  (https://support.geocortex.com/essentialsGSCForum?id=906600000000AsOAAU) Hyperlink in Feature Long Description

   

  and here:

   

  (https://support.geocortex.com/essentialsGSCForum?id=906600000000AtbAAE) Remove Feature Hyperlink if field value is NULL

   

  and here:

   

  (https://support.geocortex.com/essentialsGSCIdeasDetail?c=09a6000000008RsAAI&id=087600000004MfCAAU&categ=&sub-nav=ideas&main-nav=essentials) Tab layout - Multirow rather than Single row

  Not all are exactly on the same issue but are around the issue of presenting related data to the user.

  I have also posted a request for some improvements with the issue you have here:

   

  (https://support.geocortex.com/GSCIdeas?c=09a6000000008RsAAI&sub-nav=ideas&main-nav=essentials&keyword=Linked%20data%20rendering%20URL%20improvements&page=1) Linked data rendering URL improvements

   

  You might like to add your vote for such an improvement

  regards

  Ralph

   

  0

Please sign in to leave a comment.