Conditional Row Formatting for JQL Table displayed in Confluence

Tonja Davis

Hello,

We have a JQL table that we use to pull our testing effort tickets into an executive dashboard. 

I would like to apply conditional formatting to a row based on a value found in Labels. For instance, If I have "Good" in Labels, I want the row to be colored green, "Warning" I want yellow, and "Bad" I want red. 

I have tried with table transformer using SQL and I cannot get it to work. 

Any suggestions? 

Katerina Rudkovskaya _Stiltsoft_

Hello @Tonja Davis ,

Please wrap your source table with Table Transformer and use the SQL query like this:

SELECT
FORMATWIKI("{cell:bgColor=" +
CASE WHEN T1.'Labels'="Good" THEN "green"
WHEN T1.'Labels'="Warning" THEN "yellow"
WHEN T1.'Labels'="Bad" THEN "red"
ELSE T1.'Labels'
END
+ "}" + T1.'Labels' + "{cell}")
AS 'Lables',
FORMATWIKI("{cell:bgColor=" +
CASE WHEN T1.'Labels'="Good" THEN "green"
WHEN T1.'Labels'="Warning" THEN "yellow"
WHEN T1.'Labels'="Bad" THEN "red"
ELSE T1.'Labels'
END
+ "}" + T1.'column 2' + "{cell}")
AS 'column 2',
FORMATWIKI("{cell:bgColor=" +
CASE WHEN T1.'Labels'="Good" THEN "green"
WHEN T1.'Labels'="Warning" THEN "yellow"
WHEN T1.'Labels'="Bad" THEN "red"
ELSE T1.'Labels'
END
+ "}" + T1.'column 3' + "{cell}")
AS 'column 3'
FROM T*

Here are other examples of advanced table cells formatting you may find useful for your cases. 

Katerina
Stiltsoft