AnsweredAssumed Answered

PI SQL Query for Compressed Data (Boundary Interpolated)

Question asked by RickSmithJr on Feb 20, 2019
Latest reply on Feb 23, 2019 by RickSmithJr

My PI SQL query below works fine for cases where there is data between the start and stop dates, but returns no records when there is no archived data between the time stamps... Is there a query modifier I can use to parallel the PI Datalink compressed call for boundary type = Interpolated?

 

SELECT time, tag, value, DIGSTRING(CAST(value AS Int32)) as sValue, DIGSTRING(status) as status

FROM piarchive..picomp2

WHERE tag in ('CR-CBIN_LVHCVENT_SOURCE.VENT','CR-DIG_VENTING_S.VENT','CR-EVAPS_VENTING_S.VENT','CR-SOG_VENTING_METH.VENT','CR-TURPD_VENTING_S.VENT')

AND time >= '03-Feb-2019 06:30:00' AND time <= '03-Feb-2019 07:30:00'

 

thanks

rick

Outcomes