Hi, I'm trying to fetch data by perspective tag history binding. Although I set "As Stored" Query Mode with fixed begin date and end date the results set always returns the next record after the end date.
Here are the settings:
This is the result:
And this is the raw data in the database (in reverse time order):
I played with system.tag.queryTagHistory with the following parameters:
ds = system.tag.queryTagHistory(
paths = paths,
startDate = value.begin,
endDate = value.end,
aggregationMode = "LastValue",
ignoreBadQuality = True ,
returnFormat = "Tall",
includeBoundingValues = False,
returnSize = -1,
noInterpolation = True,
But this give the same results.
I'm wondering if Ignition returns this additional records by design or I miss something. I just need to fetch the records with timestamps later than beginDate and earlier than endData.