Query for value with longest time in a time range

Discussion created by Werum on Apr 10, 2014
Latest reply on Apr 30, 2014 by Gregor



I am trying to get the value with the longest duration in a tag for a given time frame.


For example:


I know the start and end time that i would like to query. I know the tag name. But I need the value within this time frame which has the longest duration in total.


I am using PI OLEDB provider.