AnsweredAssumed Answered

SQL data extracted keep constant in time, don't fall to 0

Question asked by Pablo_M_R on Jul 13, 2020
Latest reply on Jul 20, 2020 by Pablo_M_R



Hi i have a doubt how could i avoid that the data coming from the sql query for fill the tag do no keep freeze during the time until the  next value, this is data came from a batch truck dump, i want that the tag behavior do the same, from 0 to 500 and from 500 to 0 to waiting the next dump...

 

I have use this SQL Sentence: 
/SQL= "select CAST(ENDTIME AS DATETIME) as PI_TIMESTAMP, TONNS AS PI_VALUE, 0 as PI_STATUS FROM [Databasename].[Pi].[V_TRUCKCRUSHER] where ENDTIME >? and SECONDARYMACHINENAME = 'Truckname'  order by PI_TIMESTAMP ASC;" P1=TS

 

Outcomes