AnsweredAssumed Answered

Archive Value Query Expression

Question asked by dcunningham on Jan 18, 2016
Latest reply on Jan 20, 2016 by dcunningham

Hello everyone,

 

I have a tag called "VEHICLE.LOC", which reports one of numerous MAC addresses or "Not-Associated". I want to perform queries with other tags and use the timestamps to determine where the vehicle was at that time. So I'd have "Tag1 Timestamp" "Tag 1 Value" "VEHICLE.LOC". I don't want the "Not-Associated" values, if the value is "Not-Associated" I want the last known location for that vehicle. I've found a way to remove the "Not-Associated" values for a compressed data query using the filter expression: Compare(String('VEHICLE.LOC'),"*Not-Associated*")=0. I tried this as an expression with an archive value query with the Retrieval Mode set to "previous" for a time that I know has a "Not-Associated" value, and I get a 0 value. I'm not sure what I've done wrong.

 

Does anyone have a solution to this problem?

 

Thanks in advance for any help you can provide.

 

Regards,

 

Dan

 

Message was edited by: Dan Cunningham Corrected filter expression.

Outcomes