AnsweredAssumed Answered

Questionable values longer then 1 hour

Question asked by igreguri Champion on Mar 16, 2018
Latest reply on Mar 21, 2018 by igreguri

I've created a query for list questionable data...

I want to show only points with data in questionable status continuously for more than an hour.

How to do this?

 

SELECT tag, time
FROM [piarchive]..[picomp2]
WHERE tag like '*.PV' and Questionable = True and time >= '*-1h'
--GROUP BY tag
OPTION (FORCE ORDER)

 

Questionable data longer then 1 hour.jpg

Outcomes