I’m looking for a little advice.
I’m setting up a history transaction group in which I would like to include some averages (for the last 5 minutes from the time the transaction group is running) queried from SQLtags history. However, I’ve noted that the history data will be partitioned into multiple tables.
Robert has an excellent post on parsing the partitions table:
but I’m not sure how best to integrate logic like this into a transaction group that uses the expression language.
Things get a little complicated because the transaction group is also calculating the tag name that we will be looking up.
I thought I’d check in here before going to far into it…
Thanks for reading…