Is there a way to make a column of clickable hyperlinks?

[Ethan Treece]

I'm using the SQL macro the query through a set of data including defects for specific products. I'm creating graphs and charts using this data, and one thing I would like is for the user to be able to click on one of the values and it brings them to the page where that item is described in great detail.

I currently have this column for the link that brings the user to the item's page, but it's not formatted as a hyperlink. I don't want require the user to copy/paste the link each time they would like to inspect a specific defect.

I'm wondering if there's any way to make that link clickable through SQL or any Confluence tools.

[Michael Kuhl {Appfire} · Accepted solution]

Hi Ethan - You can set the output format of the macro to Wiki and then modify your SQL to append wiki markup for links to the column.

Like this:

select bug_id,component,product,'['+link+']',created,age,age_range from some_table

[Ethan Treece]

The worked perfectly, thank you!