Table transformer issue

[P Al]

Hello 

I am trying to use the table transformer to set backg colour based on value of a column. But I keep getting an unknown macro : "cell" Error ..

My table has 2 columns -

Status and Output. Status has the values BLOCKED & NEW

SQL query I am using in the table transformer is : 

SELECT T1.'Status',
FORMATWIKI("{cell.bgColour=" +
CASE WHEN T1.'Status' = "BLOCKED" THEN "#FA7E70"
ELSE "#8FCA7D"
END
+"}" + T1.'Output' + "{cell}")
AS 'Output'
From T1

Am using confluence 7.17

Please can you help.. thanks

[Katerina Rudkovskaya _Stiltsoft_]

Hi @P AI,

Your SQL query is not correct:

SELECT T1.'Status',
FORMATWIKI("{cell:bgColor=" +
CASE WHEN T1.'Status' = "BLOCKED" THEN "#FA7E70"
ELSE "#8FCA7D"
END
+"}" + T1.'Output' + "{cell}")
AS 'Output'
From T1

Please pay attention to the cell:bgColor function. In your variant it looked like cell.bgColour that causes errors and prevents the background coloring. Otherwise your query is good.

[P Al]

ohh many thanks for the spot :)