Table Transformation content as URL

[erzn]

Hello,

i have used within my confluence page a jira-issues-macro, which shows me all issues to a specified JQL.

I use the result (as a Table) within the macro "Table Transformation" to use further SQL query/reporting and have a SQL selection to extend the jira-issues-macro-table with one more column.

the first column is the key, second the summary and third (generated column via CONCAT) should be an url.

For example:

########

Key | Summary  | URL (concat)

KEY-123 | Summary 1 | http://www.xyz.com/KEY-123

KEY-456 | Summary 2 | http://www.xyz.com/KEY-456

########

Unfortunately the result of the concat column is hard-written and not clickable. I just want to get the result as a link to make the user more comfortable to click on it, to get to the page requested. I tried to make the concat like "[http://www.xyz.com/KEY-123]" but it didn't converted the text into a clickable url.

Do you have any ideas?

My SQL Query within the table-Transformation macro: 

SELECT 'Key', 'Summary', CONCAT("https://www.xyz.com", 'Key') FROM T*

Thank you!

Best Regards

Ersin

[Emily Berg]

Have you found a solution?  I would like to implement the same request.

Emily