JQL Table macro in Confluence - Color a row based on a JIRA tag value?

Shantharam May 24, 2023

I am extracting JIRA tickets into a Confluence page using JQL Table macro, using JIRA tags as filters. For example, following query pulls in JIRA cards that have the label 'pgperf-performance'


However, many of the JIRA cards also have another label - 'pgperf-blockers', along with 'pgperf-performance'. Now, I want to highlight the cards that have both of these tags in red. So that the final table lists ALL JIRA tickets that have the label 'pgperf-performance', AND, the rows that have the cards with 'pgperf-blockers' label are marked in red color.

Is there any way to format a row based on the output of a JQL query?



1 answer

4 votes
Katerina Rudkovskaya _Stiltsoft_
Marketplace Partner
Marketplace Partners provide apps and integrations available on the Atlassian Marketplace that extend the power of Atlassian products.
May 24, 2023

Hi @Shantharam,

If you have the Table Filter and Charts for Confluence app (that is our add-on) installed for your instance, you may use its Table Transformer macro and the FORMATWIKI function for the case.
Please check this part of our documentation (navigate to the “Conditional formatting” section).
The Table Transformer macro supports the Jira Issues macro as a source table, so your case can be easily implemented.

Suggest an answer

Log in or Sign up to answer