nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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.

confluence pretty links.png

Accepted answers

Jim Solomon

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:

I want to be able to embed this whole thing in a table cell, but it doesn't look like that's possible
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:

confluence pretty links 3.png

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

confluence pretty links 2.png

All comments

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.

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.

Jim Solomon

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:

I want to be able to embed this whole thing in a table cell, but it doesn't look like that's possible
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:

confluence pretty links 3.png

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

confluence pretty links 2.png

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

confluence

cloud

confluence-cloud