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

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

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

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


select '[' || text_field || '|' || link_field || ']' ...


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:

The result I would like to have:

Is there a way to make the link shorter?

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

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.

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}' ...



Thanks a lot, this solved my problem smile

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

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
Community showcase
Posted Feb 06, 2019 in Confluence

Try out the new editing experience

Hi team, I’m Avinoam, a product manager on Confluence Cloud, and today I’m really excited to let the Community know that all customers can now try out the new editing experience and see some of the ...

801 views 38 5
Join discussion

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you