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
Have you found a solution? I would like to implement the same request.
Emily
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.