• Recent
    • Tags
    • Popular
    • Register
    • Login

    Please Note This forum exists for community support for the Mango product family and the Radix IoT Platform. Although Radix IoT employees participate in this forum from time to time, there is no guarantee of a response to anything posted here, nor can Radix IoT, LLC guarantee the accuracy of any information expressed or conveyed. Specific project questions from customers with active support contracts are asked to send requests to support@radixiot.com.

    Radix IoT Website Mango 3 Documentation Website Mango 4 Documentation Website Mango 5 Documentation Website

    I'm stuck in writing problems.

    Dashboard Designer & Custom AngularJS Pages
    2
    2
    986
    Loading More Posts
    • Oldest to Newest
    • Newest to Oldest
    • Most Votes
    Reply
    • Reply as topic
    Log in to reply
    This topic has been deleted. Only users with topic management privileges can see it.
    • J
      JoHn-Beer
      last edited by

      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

      1 Reply Last reply Reply Quote 0
      • phildunlapP
        phildunlap
        last edited by phildunlap

        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 * * ?

        1 Reply Last reply Reply Quote 0
        • First post
          Last post