You've been invited into the Kudos (beta program) private group. Chat with others in the program, or give feedback to Atlassian.
View groupJoin the community to find out what other Atlassian users are discussing, debating and creating.
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
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 || ']' ...
After generating link I required, how can I store it in a separate string
for ex:
my link to be redirected is
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
The result I would like to have:
INC000000002460
Is there a way to make the link shorter?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Yes, put in link text indicated in the answer. So something like: '[' || Entry_ID || '|' || ...
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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}' ...
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi...can you please share what you did....I have the same issue using hyperlink link in an SQL
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Community! We're thrilled to share that Team Calendars for Confluence is now a built-in feature for Confluence Data Center releases 7.11 and beyond. A long time favorite, Team Cale...
Connect with like-minded Atlassian users at free events near you!
Find an eventConnect with like-minded Atlassian users at free events near you!
Unfortunately there are no Community Events near you at the moment.
Host an eventYou're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.