How to bind data for multistate indicator from SQL query

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.


SQL query

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.

1 Like

Hello David_Stone

Thanks for reply,

It's a Vison module.

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

1 Like