Tree background color not displaying

Ignition
1

I have a tree component where the highest level items have a conditional background color based on a column. Here is the relevant part of the query -

SELECT
        '' AS `path`,
        `listcustomers`.`name` AS `fullPath`,
            `listcustomers`.`name` AS `text`,
            `listcustomers`.`active` AS `active`,
            IF(`listcustomers`.`active`, 'tree/CustomerActive.png', 'tree/CustomerInactive.png') AS `icon`,
            IF(`listcustomers`.`active`, 'tree/CustomerActive.png', 'tree/CustomerInactive.png') AS `selectedIcon`,
            IF(`listcustomers`.`creditHold`=True,'color(255,80,80,255)','color(255,255,255,255)') AS `background`,
            '' AS `border`,
            '' AS `tootltip`,
            '' AS `selectedText`,
            '' AS `selectedTooltip`,
            '' AS `selectedBorder`,
            'color(0,0,0,255)' AS `foreground`,
            'color(250,214,138,255)' AS `selectedBackground`,
            'color(0,0,0,255)' AS `selectedForeground`,
            `listcustomers`.`idx` AS `customerId`,
            NULL AS `locationId`,
            NULL AS `areaId`,
            NULL AS `assetId`,
            NULL AS `projectId`,
            NULL AS `projectNum`,
            NULL AS `salesOrderId`,
            NULL AS `invoiceId`,
            NULL AS `purchaseOrderId`,
            NULL AS `priority`
    FROM
        `listcustomers`

and here in the designer, when I look at tree customizer, the condition does seem to come through correctly -

image
image1272×227 38.1 KB

But as you can see in the tree itself, the background of AAK and Abox are not red, despite the tree customizer says it should be. What am I missing here? How can i fix this?

2

Oddly enough if I do

IF(listcustomers.creditHold=True,'color(255,80,80,255)','color(255,255,255,255)') AS foreground,

in my query, that DOES affect the foreground color.

3

Same problem here, foreground color is working, background color changes will not affect the color

1 Like