re: sql-query macro
I am able to conditionally format individual cells in a table by updating a query to incluide smth like:
, CASE WHEN abc = 1 THEN '<span style="background: #9e9; border: 1px solid #999;padding: 1px 12px;">one</span>' WHEN abc = 0 THEN '<span style="background: #e99; border: 1px solid #999;padding: 1px 12px;">zero</span>' ELSE '--' END AS ABC
+ I set query output format as "html"
but would like to conditionally format the entire row = color it red, please :)
anyone has any ideas? Bob? :)
just thinking outloud... maybe storing a tr class in the last column and not display it?
Hello!
For conditional formatting in Confluence you may use CelesteCS Conditions for Confluence.
Thanks!
@CelesteCS- Please could you have a read of the vendor guidelines before posting again?
Thanks!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Look at the css and related parameters like columnAttributes and rowStyles. See Common parameters - they are shared by the SQL macros.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
thanks for your response. not sure how to apply this for condiitonal formatting though. I get the idea of applying a background for all rows or adding repeating patterns, but what if I need to color one particular row red if one of the fields triggers this condition? for example - this might be row number 14 out of 100.
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.