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