SQL Query for color in Equipment Schedule component

I would like to use the Equipment Schedule component, and base the data in the Items and Scheduled Events properties off a SQL query. How do I get a color into the Foreground and Background fields of the Items property, for example? I tried putting something like ‘BBBBBB’ but it didn’t recognize it as a color. I am using SQL Server, if that matters.

Thanks for your time and help!

Before assigning a color to a component property, you will likely need to convert the desired color string to a color using the script function: system.gui.color(color)

Try formatting the string to this:

java.awt.Color[r=255,g=23,b=23,a=100]

[quote=“jpark”]Try formatting the string to this:

java.awt.Color[r=255,g=23,b=23,a=100]

That worked! Thank you so much!