Site Setup
- New – Group property called Allow Published – Default Security Settings. By default, this is True but when set to False new reports will automatically be restricted to the User how creates the Report. The Author of the report can remove their Account from the Security Tab if required to give wider access to the Web Channel Published Report. This new setting is useful when you want to prevent Web Channel report from being unintentionally accessed by many users. This give the Author’s report protection until such time as they decide what level of security access to give the report.
Query Builder
- Add – Period filter values now allow month names combined with the year. For example, various formats such as 01/2020 and 2020-001 etc were acceptable but Month names were not. Now 2020 Aug will resolve to 2020/08 and November 2020 will resolve to 2020/11. Note: This assumes that the Periods are based on calendar months and the financial year starts in January
Scheduler
- Add – Writeback Actions now allow for targeted updates through the use of either the new mapping option called ‘Exclude from Update’ or by setting the writeback field value to <!!>. For example, if updating just the status off a Project record you would set pass the values for the Project and Status and set all other fields to ‘Exclude from Update’ or <!!>. The unique fields must always be set so that the record can be found to then be updated. Note that in this mode insert statement are suppressed. This same option can be done in Excel or the REST API but only via setting the mapping values to <!!> to exclude them from the update SQL.
- Fix – Writeback based on value lists would raise an error fields whose Datamodel allowed for nulls. Due to the increase in REST API data the engine now allows nulls on fields with value lists that may not explicitly include the <null> in the list.