Data connection hyperlink
Hi,
In 3.4 Essentials recognizes a hyperlink field in an attribute table of a data layer. Does it also recognize a hyperlink that is in a data connection (linked table?)
Chris
-
This feature is currently under development and should be in the next version of Essentials if all goes well.
0 -
I'm also interested in this too. However, I prefer to be able to set a hyperlink field in the datalink. When the data has a one to many relationship and you see the datalink table, it would be best to be able to indicate on the datalink table that it is a hyperlink:
See the following example of a layer with a datalink that needs one of its fields hyperlinked:
/customer/servlet/servlet.FileDownload?file=00P6000000e87xdEAA
0 -
Hi
Has this happened yet?
Thanks
Caroline
0 -
This feature should be included in Viewer 1.3. Note that it is a feature of the Viewer, and not of Essentials, so this is what will need upgrading.
Please let us know if it doesn't seem to be working for you.
0 -
Jonathan,
I will endavour to answer this by a quick prototype but can you confirm if this is supported in the data link table or not?
I'm also intrigued if this (in datalink table) is also supported in the ADF viewer? We did quickly try to embed a href link in the table directly but the ADF doesn't appear to be recognising this.
Cheers
Brad
0 -
I also tried using the a href tag in essentials 3.8/silverlight 1.5 and it doesn't work. Using SQL
SELECT YEAR, '<a href="http://yourserver/' + ATTR1 + '>CLICK TO OPEN DOCUMENT</a>' from table1 where attr1 = @attr1
it doesn't resolve the a href tag
0 -
Hi Everyone
Newb Essentials user, 3.10.1, SL viewer 1.6... This thread seems to a good place to post this, 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
0 -
Our scanning system and data has a database table that relates the scan name to the feature_id. is it possible to set up a dataconnection between the feature_id in the map and a dataconnected table with the same feature id? That way we could build a data connection and retrieve the hyperlink and put it in the map tip or data table. I have seen this post, but was it ever resolved?
J
0 -
Hi Jeff
this currently works (for at least since 3.9?). The field contents just need to be an url. ie http....
It does mean currently that you get some pretty long fields showing depending on what your setup is.
Having valid html as shown earlier in the thread would be nice but not possible currently as far as I know.
Regards
Ralph
0 -
I'm using the Silverlight Viewer 1.9 with Essentials 3.14 and I still don't see an easy way to include a hyperlink to a datalinked value. A workaround has been suggested to include the hyperlink text as part of the SELECT statement for the datalink, but this gives you a long-winded value in the related table's tab.
SELECT LEGAL_ID, PROPERTY_NUMBER, LEGAL_TYPE, FOLIO, PID, PLAN_NUMBER,
'http://server.col.local/LPLocal/' + PLAN_NUMBER + '.tif' AS LEGAL_PLAN
FROM ...It would be preferable if a datalink hyperlink worked in the same way as a regular hyperlink and it appeared in the 'Links' tab alongside all the other hyperlinks for that feature.
Is this possible?
Thanks
Mark
0 -
+1 for having hyperlinks listed in a datalink
We concatenate "http//" on the SELECT statement as Mark mentions above. It would be really great if we could use the <a href=""></a> tag instead
0 -
Anyone have a work around to shorten the hyperlink?
0 -
Hi kenneth
I have made an intermediate page (.aspx) that has a short name ie htt://server/tiny/go.aspx which takes a code value argument. That page then figures out what to do with the code and redirects to the final target page. Not ideal and not easily distributable apart from as a concept but it does give plenty of options.
Hope that helps
Ralph
0 -
I added a new field to the data that has the whole <a href="FilePath">DisplayName</a> tag in it. It appears in the datalinked table as a hyperlink, and just shows the DisplayName.
0 -
Thx Ralph and Stephanie.
0 -
Hi Stephanie
it is great to see the hyperlink functionality there now having asked for it a fair while ago. Somehow I missed seeing it referred to in any release notes. I wonder what other valid html it is happy to render?
Anyway I am now making use of it as well as my intermediate tiny page.
Regards
Ralph
0
Please sign in to leave a comment.
Comments
16 comments