Display a column in the SQL results as a link to an FTP site

Network_Services_Manager April 21, 2015

One of the columns I am returning from a SQL query is an link to a file on a FTP server.  Is there a way I can make the results be a hyperlink to the file?  I am using the Bob Swift SQL add-on

2 answers

1 accepted

2 votes
Answer accepted
Bob Swift OSS (Bob Swift Atlassian Apps)
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
April 22, 2015

Easiest thing to do is use wiki notation and output=wiki for the field:

select '[link text|' || link_field || ']' ...

or 

select '[' || text_field || '|' || link_field || ']' ...
sharukh shaik December 10, 2020

After generating link I required, how can I store it in a separate string 

for ex: 

my link to be redirected is 

https://wynk.in/music

But I need it as 

WYNK (clickable)

So when i click on WYNK, I should go to https://wynk.in/music

 

I this something possible in SQL? If Yes, can you write full query for me please.

 

Thanks,

Sharukh

0 votes
Lars Lysenstøen October 8, 2015

Hi!

I am using the described solution and it works fine but... the link text in my case is long and it dos not look so nice in my table.

My query:
select top 1 '[http://rem002/arsys/servlet/ViewFormServlet?form=HPD%3aHelp+Desk&server=REM001.politiet.master.net&eid=' + Entry_ID + ']' as test from sql008.arsystem.dbo.HPD_Help_Desk

My result:
http://rem002/arsys/servlet/ViewFormServlet?form=HPD%3aHelp+Desk&server=REM001.politiet.master.net&eid=INC000000002460

The result I would like to have:
INC000000002460

Is there a way to make the link shorter?

Bob Swift OSS (Bob Swift Atlassian Apps)
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
October 8, 2015

Yes, put in link text indicated in the answer. So something like: '[' || Entry_ID || '|' || ...

Lars Lysenstøen January 26, 2017

Finaly I got time to look at this again....

Thanks a lot for the feedback, I made some adjustment and now it works as expected.

Is there a easy way to force the link to open in a new window? I have been googling around found that a link can open a new window using javascript in a html-macro but I don' t see how I can use this together width the SQL-macro.

Bob Swift OSS (Bob Swift Atlassian Apps)
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
January 29, 2017

That seems a bit heavy handed, but you can use any macro for a column. Since you are already doing ouput=wiki, then the column would be like: 

select '{html} ... {html}' ...

 

 

Lars Lysenstøen March 12, 2017

Thanks a lot, this solved my problem smile

Gp Singh February 14, 2018

Hi...can you please share what you did....I have the same issue using hyperlink link in an SQL

Lars Lysenstøen December 4, 2018

Sorry for the late answer, I hope you have solved it out already... 
I did something like this: 

 select ' {html} <a href="https://info/pages/viewpage.action?pageId=139136550" target=_blank> HitMe </a> {html}' as 'TestUrl' from MyTable

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events