imqs

How to change PI AF retrieval mode with SQL to get previous compressed time value?

Discussion created by imqs on Nov 22, 2013
Latest reply on Dec 9, 2013 by cramsey

In this video I see mention of a retrieval mode http://www.youtube.com/watch?v=L43IPKXVopI.

 

What SQL query can I use to change the retrieval mode?

 

I want to get the previous compressed tag time before some specific time.

 

More detail:

A normal SQL query like select top 1 order by time where time < x takes way too long (times out), there must be some function I can use.

InterpolateDiscrete almost does what I want but it returns the timestamp I give as a parameter instead of the timestamp that the value changed.

I want non-interpolated values.

Outcomes