# Tree background color not displaying

**URL:** <https://forum.inductiveautomation.com/t/tree-background-color-not-displaying/39541>\
**Category:** Ignition\
**Tags:** ignition80\
**Created:** [October 9, 2020, 3:13pm UTC](https://forum.inductiveautomation.com/t/tree-background-color-not-displaying/39541 "2020-10-09T15:13:50Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![bkarabinchak.psi](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/bkarabinchak.psi/32/83567_2.png) [@bkarabinchak.psi](https://forum.inductiveautomation.com/u/bkarabinchak.psi)\
**Post date:** [October 9, 2020, 3:13pm UTC](https://forum.inductiveautomation.com/t/tree-background-color-not-displaying/39541/1 "2020-10-09T15:13:50Z")

</div>

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 -

```auto
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](https://us1.discourse-cdn.com/inductiveautomation/original/3X/a/9/a9b691f6ff45f5ddacb74ec7a6a5553f779876a3.png)

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?

---

<div class="post-metadata">

**Author:** ![bkarabinchak.psi](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/bkarabinchak.psi/32/83567_2.png) [@bkarabinchak.psi](https://forum.inductiveautomation.com/u/bkarabinchak.psi)\
**Post date:** [October 9, 2020, 5:21pm UTC](https://forum.inductiveautomation.com/t/tree-background-color-not-displaying/39541/2 "2020-10-09T17:21:49Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![dtrottier](https://avatars.discourse-cdn.com/v4/letter/d/b5a626/32.png) [@dtrottier](https://forum.inductiveautomation.com/u/dtrottier)\
**Post date:** [February 12, 2021, 12:51pm UTC](https://forum.inductiveautomation.com/t/tree-background-color-not-displaying/39541/3 "2021-02-12T12:51:57Z")

</div>

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