How to bind data for multistate indicator from SQL query

[Govind_Suthar1]

Hello Friends,

I want to bind data for multistate indicator using SQL query, I tried that, but it's an error occurred. So, I found the root cause of the error, if using SQL query doesn't bind the data for multistate indicator, because it is the colour object, you can use scalar query to bind the data.

How to use a scalar query for multistate indicator colour binding through DB?

PFA pictures for your ref.

Error

SQL query

[David_Stone]

Is this in Vision or Perspective?

I would suggest making an SQL Tag and place this query in the tag settings.
Then bind the tag to change colours like you would any other tag values.

[Govind_Suthar1]

@David_Stone

Then bind the tag to change colours like you would any other tag valu

Hello David_Stone

Thanks for reply,

It's a Vison module.

I applied that query in the tag setting and it's working now.