Upgrade semver version from 5.7.1 to 5.7.2 and 6.3.0 to 6.3.1
Version 4.5.0
Upgraded for Mango 4.5.0
Version 4.4.0
Upgraded for Mango 4.4.0
Version 4.3.0
Upgraded for Mango 4.3.0
Fix bug where Mango logo was not inserted into email template
Version 4.2.2
Fix bug where report has multi cell named ranges
Version 4.2.1
Fix another NPE and allow Excel reports to be generated with the “Location for time values” field blank
Version 4.2.0
Upgraded for Mango 4.2.0
Adding validation to fix a NPE and allow Excel reports to be generated with the “Location for time values” field blank
Version 4.1.1
Upgraded for Mango 4.1.1
Allow time named range to be null
Version 4.1.0
Upgraded for Mango 4.1.0
Version 4.0.0
Upgraded to work with core version 4.0.x
Add create permission that defaults to all users allowed to create
Add help about Excel Event Handler
Add sorting to finished reports table
Add record count column to finished reports table
Improve validation feedback for invalid inputs when creating a template
Remove the concept of an owner for a template and report use the read and edit permissions for control
Upgrade to ensure the owner’s roles are set on the edit permission and report execution permission so they retain access
Add new setting to templates to control what roles the report runs with
Freemarker (FTL) templates should now be placed in overrides/ftl/excelReports, any existing custom .ftl files must be manually moved from overrides/web/modules/excelReports/web/ftl
Version 3.7.2
Add queue for running reports and max queue size system setting to limit memory use when running concurrent reports
Version 3.7.1
Change wording on Schedule button to be Configure and run
Fix bug where reports were not running on a schedule
Fix UI bugs when using Configure and run action
Clean up help for running reports
Version 3.7.0
Upgraded to work with core version 3.7.x
Expose report template to both post processing and email scripts
Ensure script validation context mocks all objects available during runtime
Allow running either the post processing script, email script or both
Use file extension of template for generated report file
Version 3.6.2
Fix bug where copying report would change the existing one, not make a copy
Fix multiple notifications when deleting reports
Fix repeated permission group REST requests
Fix display of errors for dateRangeType input
Show messages for named range input when form is submitted
Version 3.6.1
Fix NPE when emailing a report with no script context defined
Version 3.6.0
Upgraded to work with core version 3.6.x
Moving /v1/excel-report-templates/upload to /v2/excel-report-templates/upload
Expose reportInstance object to post processing script under var name ‘report’
Make drop downs for named ranges searchable
Improve validation messages for time periods
Adding Excel Report Event Handler to run a report on event
Added independent file store permissions for read / write on the excel reports file store
Version 3.5.1
Fix running a report modifying the underlying template file
Version 3.5.0
Upgraded to work with core version 3.5.x
Change resulting report filename scheme from runtime_templateName to reportName_runtime
Substring error message to first 512 characters for database column width
Bugfix for new UI to resolve error message about help translation being from dashboard designer
Modify statistics to use bookend query to handle edge case where there is a value exactly at report from time.
Add XLSM file extension into template selector in new UI
Validate template when POST’ed to /run endpoint with a time series to be applied
Bugfix in TimeSeriesModel translation
Bugix to ensure template file is closed after generating a report
Version 3.4.1
Fix logic checking if any events ranges exist
New Angular UI
Version 3.4.0
Upgraded to work with core version 3.4.x
Expanding end time of report to end of rollup period if using rollups
Version 3.3.5
Prevent NPEs in json import, use class defaults if valid
Version 3.3.4
Single GET template endpoint returns with allNamedRanges=null instead of 404 with missing template file.
Version 3.3.3
Check Mango/overrides/web/modules/excelReports/web/ftl/ for persistent email templates.
Version 3.3.2
Fixed bug where final quantized period of statistics was not getting generated.
Version 3.3.1
Fixed bug with one one value in series in named range getting blanked.
Removed cell blanking through advancement or the named range lacking data.
Version 3.3.0
Upgraded to work with core version 3.3.x
Using new Rollup and Quantization algorithms from 3.3.0 core
Version 3.2.1
Bugfix for not advancing first cell in series without data at first stamp
Bugfix for ranges growing in a dimension other than the dimension of the time values
Bugfix for ranges growing in the same dimension as time but from a different origin row/column
Version 3.2.0
Upgraded to work with core version 3.2.x
Fixed time period type Current to accept periods > 1
Version 3.1.4
Fixing bug in advancing cells where first cells weren’t counted toward totals and ranges could be blanks
Version 3.1.3
Fix for null filenames in purge
Version 3.1.2
Add system settings to new UI
Add angular component for running and downloading a report
Version 3.1.1
Fixed bug where named ranges were not available
Version 3.0.0
Upgraded to work with core version 3.0.x
Fix validation bug when multiple points were wrongly being validated as in the same range.
System settings import validation bugfix
Fixing statistical bug where first/last values were backwards
Improved validation feedback for Point Range area
Version 1.1.3
Adding support to include Data Point Events for all points in the report.
Version 1.1.2 *Bugfix for not being able to use some Single Cell Data attributes for time series with Rollup other than None.
Version 1.1.1
Bugfix for report failure when no time range defined or rollup used
Version 1.1.0
Upgraded to work with core version 2.8.x
Fixing purge REST calls from swagger and system settings page.
Better handling for validation and JSON emport
Version 1.0.6
Allow the use of macro enabled Excel templates
Allow using statistics ranges directly without requiring a default range for a point.
Version 1.0.5
Fixed bug where saving mailing lists would fail
Added better REST response message for report templates with missing file
Version 1.0.4
Adding ‘Current’ date range type to allow reporting on the current period type, for example to report on this month until now
Adding ‘Ago’ date range type to allow reporting on a period for × periods ago, for example you can now report on the entire month that was 3 months ago
Adding error page output for feedback on problems when viewing reports as HTML
Fixing bug where deleted users linked to a report template’s email functionality would break the report
Permissions change: Reports and Templates can only be deleted by admin or the owner of the item.
Permissions change: Report readers can only view generated reports
Version 1.0.3
Parameterization of rest endpoints with filenames for use in Swagger.
Fix Download of template file to have appropriate filename
Fix for licensing to allow the correct number of templates per the license type
Changing column ordering for the points list of a Time Series
Version 1.0.2
Improvements to Permissions handling
Improvements to JSON import/export
Version 1.0.1
Fix to allow filtering data points by XID, Device Name and Name
