hyperlink to data link drilldown
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
-
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 nullLet me know if that doesn't make any sense
Ralph
0 -
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 -
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 rowNot 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 improvementregards
Ralph
0
Du måste logga in om du vill lämna en kommentar.
Kommentarer
3 kommentarer