AnsweredAssumed Answered

Not able to 'Preview' analysis results for table lookup

Question asked by Asle Frantzen Champion on Jun 28, 2016
Latest reply on Aug 4, 2016 by khaner

Hi

 

I have an AFTable where I do table lookups into my attribute 'Sum_Abonnemang', configured like this:

SELECT Sum(Abonnemang) FROM [AboTabell] WHERE Station = '%Element%' AND [Start time] <= #%Time%# AND [End time] > #%Time%#

 

Aditionally I have an expression analysis time scheduled at midnight, and configured like:

 

MyTime: ParseTime("t")

Output: TagVal('Sum_Abonnemang',MyTime)

 

If I evaluate this I get the current value of the 'Sum_Abonnemang' tag, but I don't get any results if I 'preview' the results. But it works if I manually change the MyTime variable to ParseTime("t-1d") or "t-5d". What am I doing wrong?

 

I'm on the latest and greatest version-wise here.

Outcomes