I'm using the SQL Table Transformer macro to output a list of Epics from JIRA that are currently in progress and in our project there is a custom field being used which outlines a parent Initiative (linked issue) as a Key.
When I bring this field through the SQL transformer it comes out as plain text in Confluence but ideally I would want it to be a URL link back to the JIRA issue. Can this be done by somehow re-adding the HTML URL to the text inside the SQL code?
If so I would also love to be able to create two extra columns which have direct links back to the Epic Burndown and Epic Report pages in JIRA for each of the Epic records output in the table.
I've tried to do this here:
SELECT
T1.'T',
T1.'P',
T1.'Key',
T1.'Summary',
T1.'Status',
T1.'Assignee',
CASE
WHEN T1.'parent initiative' IS NULL THEN "N/A"
ELSE T1.'parent initiative' END AS 'Initiative',
"https://jira.com/secure/RapidBoard.jspa?rapidView=23257&projectKey=IMDT&view=reporting&chart=epicReport&epic=" + T1.'Key' As 'Epic Burndown'
FROM T*