Query Builder
- Fix – Filters when set to Single would sometimes drop the << part of a multiple value filter list. E.g. <<A,B,C upon reopening the query
- Add – Expression to calculate Age taking into account leap years while a DateDiff()/365.25 will not be accurate. The main function returns a person’s age based their birth to today in years, months and days e.g. 36y 5m 12d but it is possible to set the end date and also get the AgeYear, AgeMonth and AgeDay parts
- Fix – Expression can now be referenced by Sub Query Filters but this caused Expression with reference to previous values of themselves to run twice and double up if they were recursive.
Materialise Queries
- Fix – Seed Queries that contained Unions did not work correctly in Delta Replace/Add modes due to the union parts of the Query not being passed the filter offset. There is also now new validation logic to warn about any issues with Unions.
Security Roles
- Add – Published Report Groups, Code or Unique Code can now be secured as a alternative to using the Security Tab in Publisher. In Query Builder select Product System and Table Publisher and do a lookup on either the Unique Code, Code or Group and then right click on the Lookup to create a Security Role after multiple select a few codes. After adding Security Roles to Publisher, the lookup lists and also any reports in the Web Channel will be restricted based on the codes, ranges etc the users account is restricted to.
Web Channel
- Add – Form Entry now has new styles for showing mandatory fields in addition to the existing bold text. Can now turn off styling or show a black or red * before or after the field description. See the REST service URL parameter &mandatoryStyle=[NONE|BOLD|STAR|STAR-AFTER|STAR-RED|STAR-RED-AFTER]
Studio
- Add – Field Writeback property Allowable Character to validate data based on Regular Expressions. e.g <REG= ^[a-zA-Z0-9—_-_]+$> in addition to the existing patterns
