• 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

    Data rollup option in Report(via Legacy UI)

    User help
    2
    4
    1.1k
    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.
    • cwangvC
      cwangv
      last edited by

      Hi,
      I am trying to create a report in the Legacy UI on points (kWh) that required 'Delta' rollup options.
      I notice there is an option called 'Map Key'. Is this the option for rollup?
      How else would I be able to generate such report?

      Thanks!

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

        Hi cwangv,

        The "Map Key" is simply the variable name to be used in the FTL under the "mapped" object. In the FTL it would look something like, <#if mapped.mapKey??></#if> which would check if a point with the map key "mapKey" was in the context. Otherwise as in the reportChartl.ftl file one would have to loop over the points list, so it is not easy to get the point you want there.

        To get the delta you could do something like, ${ mapped.mapKey.stats.delta } in the FTL.

        cwangvC 1 Reply Last reply Reply Quote 0
        • cwangvC
          cwangv @phildunlap
          last edited by cwangv

          @phildunlap
          Hi, Phil
          Do you have more info on the syntax in the FTL that are available to use?

          Thanks.

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

            FTL itself has a lot of quality reference material on its website: https://freemarker.apache.org/

            If you mean what is included by Mango in the model passed to the template, the most authoritative place is the code: https://github.com/infiniteautomation/ma-modules-public/blob/main/Reports/src/com/serotonin/m2m2/reports/web/ReportChartCreator.java#L148

            So we'd have to look somewhere else to see what's available in a context other than the reports, like here's the email handler building its model: https://github.com/infiniteautomation/ma-core-public/blob/main/Core/src/com/serotonin/m2m2/rt/event/handlers/EmailHandlerRT.java#L269

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