In the SQL bridge, I am trying to use an hour meter which is based on the expression: if({[.]DOWNTIME_TRIGGER}=0,0,1), which causes the meter to be active when the DOWNTIME_TRIGGER=0, and resets the meter to 0 when the DOWNTIME_TRIGGER=1.
DOWNTIME_TRIGGER is an OPC item. If I lose communication with that item, i.e., the power is shut down to that PLC, it evaluates as N/A. No matter what I have tried with expressions for my hour meter, I always get N/A when the DOWNTIME_TRIGGER is N/A.
Is there a good way around this?
Thanks.
The problem is when the device is disconnected the quality of the tag or expression is bad. So, you can just force the quality to be good using the forceQuality expression function:forceQuality(if({[.]DOWNTIME_TRIGGER}=0,0,1), 192) I hope this helps.
Yes. That solves it. Thanks!