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.
Message was edited by: Dan Cunningham Corrected filter expression.