How do I change text color for a row by FORMATWIKI?

[Kelly Chen]

I pulled out PIMS info from Jira and let it showed on Confluence. I want to change to text color to be grey for those PIMS which status is already closed.  

I've read some information on Advanced table cells formatting

It seems that I could use FOMATWIKI command for this case. However, there is no sample for changing text color for a row.  I want the table shows like below..

It will be much appreciated if someone could help me. Thank you.

[Alexey Mikhaylov _Stiltsoft_ · Accepted solution]

Hello Kelly,

When using Table Transformer (which is a macro from our Table Filter and Charts for Confluence app) you can use the following SQL query for the table as provided by you:

SELECT
FORMATWIKI("{cell:textColor=" + 'Color' + "}" + 'Keys' + "{cell}") AS 'Keys',
FORMATWIKI("{cell:textColor=" + 'Color' + "}" + 'Status' + "{cell}") AS 'Status',
FORMATWIKI("{cell:textColor=" + 'Color' + "}" + 'Created' + "{cell}") AS 'Created'
FROM
(SELECT *,
CASE
WHEN 'Status' = "Closed" THEN "lightgray"
ELSE "black"
END AS 'Color'
FROM T1)

Best regards,

Alexey

[Kelly Chen]

It works!!!

Thank you, Alexey :)

[Alexey Mikhaylov _Stiltsoft_]

Hello Kelly,

I am glad to hear it helps.

Best regards,

Alexey

[Megan]

Hi Alexey,

Thanks for providing the solution - I would like to do something similar, but want to remain the Key or Summary part clickable (can direct to the link of the Jira ticket). Would you be able to help on this please?

Many thanks in advance! :)

[Alexey Mikhaylov _Stiltsoft_]

Hello Megan,

You can use the query as above, just change pluses to commas for the parts you need to leave clickable, like in the line below:

FORMATWIKI("{cell:textColor=" , 'Color' , "}" , 'Key' , "{cell}") AS 'Key'

[Megan]

Hello Alexey, 

Much appreciated for your quick reply - thats very helpful and it works perfectly! :D