Grab your copy of our Anatomy of Confluence Cloud macros guide
To vote on the idea, please sign in with your personal or social account (Facebook or Google).
To watch the idea, please sign in with your personal or social account (Facebook or Google).
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:
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'
Drop files to attach them