My CollorPallete expression is not working when using LIKE

Bleepie — Tue, 10 Aug 2021 09:36:41 GMT

Dear community,

When using a CollorPallete expression on a statistics table the following code works:

<format type="color" field="myField"> <colorPalette type="expression">if (value == "DEBUG", "#f54242","#65A637") </colorPalette> </format>

#F54242 = RED

#65A637 = GREEN

Because the data in myField is not exactly "DEBUG" , the table collumns are all green. So in order to make the collumns with "DEBUG" red and the rest green, I tried the following piece of code:

<format type="color" field="myField"> <colorPalette type="expression">if (like(value,"%DEBUG%", "#f54242","#65A637") </colorPalette> </format>

This piece of code is not working at all. I am trying to use the wildcard to find any occurance of "DEBUG" inside myField. Not only are the fields not red, they are not even green, making me think my code is incorrect.

What am I doing wrong?

Thanks.

Re: My CollorPallete expression is not working when using LIKE

ITWhisperer — Tue, 10 Aug 2021 10:04:10 GMT

You need to close the brackets of the like function

if (like(value,"%DEBUG%"), "#f54242","#65A637")

If that doesn't work, try the match function.

Re: My CollorPallete expression is not working when using LIKE

Bleepie — Tue, 10 Aug 2021 10:11:42 GMT

Whoops. Small mistake. Got it working. Thanks!

topic My CollorPallete expression is not working when using LIKE in Dashboards & Visualizations

My CollorPallete expression is not working when using LIKE

Re: My CollorPallete expression is not working when using LIKE

Re: My CollorPallete expression is not working when using LIKE