System
- Fixed – File List table did not always get the correct Last Modified date time, was converting hours to 0 to 12 instead of 0 to 23.
Foundry
- Fixed – When loading time data from a Query was converting hours to 0 to 12 instead of 0 to 23
Scheduler
- Changed – Triggers now default to Service Triggers as these avoid the permission issues related to using Windows Task Scheduler to trigger tasks
- New – File Decompress Action – unzip. Complements existing Files Compress
- New – Folder Decompress Action – unzip. Complements existing Folder Compress
Publisher
- New – Additional Properties Category, Reference and Other to assist in managing Published Queries. The System Datamodel has been updated to allow for the querying of these new fields in addition to also getting the main query XML.
- Enhanced – Annotations now supports row level logic
- New – Right click menu to show various URL Links on Publisher List including Power BI metadata URL.
Studio
- Fixed – SQL and text edit window limited size to 32K. Now increased to 999999
- New – Datamodels have a new property called on Product Attributes called License Feature Key. When set the Datamodel or Extension Datamodel will required the code to appear in the license Feature Key section e.g. [CF=MyCode,MyCode2]. In this way authors can protect their work by requiring only sites with the feature key have access to the tables and writeback. When unlicensed the normal demo mode limitations are in place.
Excel
- Fixed – Cell References combined with multiple select on the super field like Company would drop the cell reference in Query Builder on editing the formula.
Writeback
- Changed – When a site is unlicensed, they will be limited to one record during writebacks.
Query Builder
- New – Filter Mapping. This allows users to create filter groups and other mappings of filter criteria. Filter Mapping codes can then be referenced just like any other valid filter value and their mapped values will be substituted at runtime. An example of this would Filter Mappings to facilitate company consolidation or account groups if the underlaying application does not support this type of functionality.
- New – Filter Mapping in Outputs. Use Filter Mapping definitions or create custom lists to map output values to group codes. Single values, ranges and likes matches are supported. Unlike Expressions this logic is done in SQL, so the side effects like generating additional rows is avoided. This means the summing of values can be done by the group codes created by this process.
- New – Annotations now appear in Query Builder due to them now support row level criteria. Currently there only appear in Publisher Web Channel content but in future versions that will also appear in Excel and Query Builder preview etc.
Power BI
- New – Sharperlight custom Power BI connector.
- New – Site Setup, create REST API Feed Key tokens so that Power BI can connect to Sharperlight using Sharperlight Service default authentication. Tokens can have an expiry date.