ReportMagic 2.19

Improvements

• LogicMonitor macros now pause during LogicMonitor portal upgrade, and retry every 10 seconds until the service is available. You can change this, the default behaviour, by setting waitDuringUpgrades for your LogicMonitor connection in Macro Parameter Defaults. You can also set this as a parameter on all LogicMonitor macros, which overrides any other defaults.
• You can redact the results of macros that produce textual output by setting the new redact parameter to true (default is false). This replaces substituted macro text and output macro text in the results, user interface and database with the word REDACTED.
• You can set a a clean up age (days) for the output folder of your Schedules. Any files in that folder / sub-folders are deleted if older than the specified value. You can of course set them not to age, or use a Tenant-level default (set by a Tenant Admin).
• [ReportMagic.ReportScheduleProperty:] and [ReportMagic.ReportScheduleList:] macros now allow you to specify multiple properties. The default (without specifying properties at all) is to return all properties.
• [ReportMagic.ConnectionList:] macro now supports skip and take parameters.
• In Report Studio, you can now save a file whose name contains multiple dots such as myfile.v0.1.html
• You can now add further CSS, such as striping, to your tables.
• API improvements such as adding a dictionary of patch values.

Bug fixes

• Fixed the [Break:] macro to work as described.
• Fixed the behaviour of the [Continue:] macro if used within a ForEach macro.
• Fixed a problem with the LogicModules management page where it became unusable if you had specified an invalid connection.
• Ensured you cannot set an empty write-only macro parameter default
• Made Help and Error Message text corrections including typos, the Help for Cache.Set examples, and the API help page
• [LogicMonitor.AlertCalendar:] macro now always colours affected cells correctly.
• Fixed an issue with the [LogicMonitor.SdtList:] macro for portals with a service SDT
• Added startDate and endDate parameters to [LogicMonitor.LogAnalysis:] macro (there is a 3 month limitation for performance reasons). 
• The [DocumentBookmark:] macro now works even if you are attempting to use it in a document with no bookmarks.
• API: A Tenant API token can only now be assigned users from the current Tenant
• API: Fixed an issue where user tokens would show ID instead of email address under certain circumstances.
• API: Ensured that on upgrade, the existing appsettings.json file is retained.
• The [ReportMagic.ReportJobList:] macro has been corrected to report only on jobs initiated via a Schedule and not HTML jobs from Report Studio.
• The [ReportMagic.ReportJobProperty:] macro no longer includes the SystemBaseUrl and SystemName properties.
• Renamed [ConnectionList:] to [ReportMagic.ConnectionList:] and [ConnectionProperty:] to [ReportMagic.ConnectionProperty:] Both macros use the ReportMagic API to fetch results, rather than the local repository.
• A meaningful error is reported if you use the [ReportMagic.ConnectionList:] macro in conjunction with a [ReportMagic.Connection:] specifying a non-existent connection.
• Fixed an issue in orderable [List.XXX:] macros where if the orderByIndices parameter was a negative number or greater than the minimum number of columns, this would cause a system error.
• [List.xxx:] and [XXX.List:] macros had no need for both the excludeWhitespaceItems and includeWhitespaceItems parameters. Only the latter (default = true) is now available.
• You can now use the property or the properties parameter in the [ReportMagic.ReportScheduleProperty:] macro.
• Fixed an intermittent issue with the [Toggl.TimeEntryList:] macro.
• Implemented a two-second back-off and retry for [Toggl.TimeEntryProperty:] macros. Also, time Entries with no data correctly result in no data, rather than causing a macro error.
• Database: Fixed an issue with not being able to delete a Tenant due to database entities with linked secondary keys not being deleted.