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.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello Kelly,
I am glad to hear it helps.
Best regards,
Alexey
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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! :)
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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'
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello Alexey,
Much appreciated for your quick reply - thats very helpful and it works perfectly! :D
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.