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

  • Re: Excel reports post processing script question

    Just wondering if this functionality has been deployed? @phildunlap mentioned it in the linked thread a few months ago. I can't seem to access it in the post processing script. Running 3.6.0.

    On this topic, would it be possible to allow the post processing script access to the report template's name and the time period name?

    Thanks,
    C


  • Hi cbyrne,

    This has been added at runtime, yes, but it does not appear to be available while doing validation currently. I will make a git issue for this.

    You should be able to get the template name via

    var excelReportTemplate = com.infiniteautomation.mango.excelreports.dao.ExcelReportTemplateDao.instance.get(report.getReportTemplateId);
    print( excelReportTemplate.getName() );
    print( report.getFilename() );
    

    I will perhaps also create git issue for putting the Excel Report Template into context, instead of only the run report. But, report.getTimeSeries() will get the periods the report was actually run over, as opposed to getting something like a relative definition as the template would have. Thanks for bringing this to our attention.


  • Perfect, thanks @phildunlap !