AnsweredAssumed Answered

how can i get the time when two tag value specified (e.g. one tag 'digital1' value '0' and the other tag 'digital2' value '1') ?

Question asked by cnzyan on Sep 25, 2017
Latest reply on Sep 27, 2017 by Eugene Lee

how can i get the time when two tag value specified (e.g. one tag 'digital1' value '0' and the other tag 'digital2' value '1')  by using sql sentences? thanks a lot.

and i am wondering how can i get a timestamp when a tag value reaches a line(eg. all the timestamps this week when tag 'cdt158' go up above 100 and timestamps when tag 'cdt158' go down below 100) by using sql sentences.

now i can only use 'select timeq ' like "select timeeq('pump1runing','*-7d','*','open') as result" to get the timespan.

thanks a lot again.

Outcomes