Reporting Dynamic Data Key Help

Ignition
1

Hi,

How do I get dynamic data keys to work with MS SQL Bit data types?

In the example below I'm trying to use the visible key to make the circle appear around the Yes or No if the SQL field is True or False.

image
image338×277 9.85 KB

I have tried query2.trailerCleanSafe == 1 and query2.trailerCleanSafe == 0, which will always make both items visible.

image

And query2.trailerCleanSafe == True and query2.trailerCleanSafe == False , which will always make both items not visible.

I can get it to work with other SQL data types.

My workaround has been to change the data type in my SQL query before using it in the data key.

2

Don't use == or != comparisons with values that are booleans. Just put value to check for true, and use !value to check for false.

1 Like
3

That worked!

Thanks, I’ve been trying to figure that out for 2 days :laughing: .

1 Like