Pretty Confluence Links from Jira Macro Tables?

[Jim Solomon]

Hi,

Is there any way to turn a table generated by a Jira Macro into a bulleted list of pretty-formatted Confluence links (Smartlinks?)?

See attached example. I'd like to use a Jira Macro to generate the table at the top, and then transform that into the bulleted list of links shown at the bottom.

Thanks.

[Jim Solomon · Accepted solution]

Success! This works really well:

SELECT 
    FORMATWIKI("[" , 'T' , " ", 'Key' , ": ", 'Summary', 'Status' , "|https://yoursubdomain.atlassian.net/browse/" , 'Key' ,"]") AS 'Combined'
FROM T1

I still have two issues left to solve:

1. I want to be able to embed this whole thing in a table cell, but it doesn't look like that's possible
2. I'd love to present the results as a bulleted list rather than individual rows of a table, and would like to remove the header

E.g., instead of this:

I would prefer to have this (embeddable in a table cell)

[Jim Solomon]

Thanks @Alex Koxaras _Relational_ . I've managed to get the fields concatenated using Table Transformer, but I can't figure out how to get them "pretty" or to carry forward the link from either they Key or the Summary field from the output of the Jira Macro. Any ideas?

SELECT 
CONCAT("[", 'T', "] ", 'Key', ": ", 'Summary', " [", 'Status', "]") AS 'Combined'
FROM T1

and it produces something that looks like this, but not as a link:

[Epic] XXX-1234: Do Something Awesome [Defining]

I'm guessing FORMATWIKI might be my friend here, but if someone could help me on the prettiness (if it's possible) or preserving the link (which I'm pretty sure is possible), that would be great. 

[Jim Solomon]

Oh, and also getting the output as a bulleted list.

[Alex Koxaras _Relational_]

Hi @Jim Solomon 

Out of the box you can't do that. First and easiest solution would be to search for an app. But what I'm thinking is an app which perhaps can concatenate columns and get a the smart link you want.