I'm stuck in writing problems.
-
Hi All,
I want to write a script in Meta Data Source.What I Want
I want to get the last value of every 30 days, for example
2019-01-01 8:00 to 2019-01-02 8:00 equals 1 day
...
2019-01-30 8:00 to 2019-01-31 8:00 equals 1 day
And I will make all the values together.But I don't know how to write the script as I need them.help me please -
Hi JoHn-Beer,
It sounds like a time to use the PointValueQuery.
var endDate = CONTEXT.getTimestamp(); var startDate = endDate - CONTEXT.millisInPast(DAY, 30); //handles DST shenanigans var results = []; var callback = function(idValueTime) { results.push(idValueTime); }; var pointsToQuery = [ p1.getDataPointWrapper().getId() ]; PointValueQuery.rollupQuery( pointsToQuery, startDate, endDate, callback, LAST, 1, DAY); print(results); //Do want you want now with the results, or in the callback function
Run on cron
0 0 8 * * ?