Maximo 7.6.1.1/Spatial 7.6.0.5
I have URLs in my GIS layers in Maximo Spatial:
Is there a way to display a URL as a hyperlink so that a user can open it in a new tab/window in the browser?
(Or invoke a URL REST request on the server-side -- whatever applies.)
Keyword: Maximo Spatial
The solution was to use HTML in the URL.
<a href='http://maps.google.com/maps?q=&layer=c&cbll=43.000000,-78.000000'> Link </a>
The SQL behind this is:
'<a href=''http://maps.google.com/maps?q=' ||chr(38)|| 'layer=c' ||chr(38)||
'cbll=43.000000,-78.000000''> Link </a>' as description,
Hint:
In Toad, the ampersand was being interpreted as a variable. I had to escape/replace the ampersand with
||chr(38)||
.More info here: Escaping ampersand character in SQL string