Materialised Queries
- Add – Performance Tab / Use In-memory Table option to improve loading and query speed by holding the entire table data in Microsoft SQL Server memory in addition to storing on disk. This feature does require that the SQL Database be setup to allow Memory-Optimized Tables. SQL Server 2014 or higher is required and it is recommended that indexes be applied to avoid table scans. https://learn.microsoft.com/en-us/sql/relational-databases/in-memory-oltp/introduction-to-memory-optimized-tables?view=sql-server-ver16
- Add – Table Indexes. To date the only way to create an index on the Materialised Table was to specify a sort order on the seed Query or to manually create one on the Database Table using SSMQ. It is now possible to not only see the default index created by the Query sort order but create and delete indexes. Indexes are very important in improving reporting query speed especially when many small queries are involved as seen in Excel Value formulas or Reporting Rows.
Form Designer
Add – Styling Tab / JavaScript hooks to allow for customization of Data Entry Forms and Table Grids in the Web Channel. For example, you can add a library of JavaScript functions and then on Setup and Form Validation call these functions to create your own validation and submit logic in addition to the existing Form Logic.
Add – Field Advanced Button / Appearance / Input Changed JavaScript event hook to allow for customization of Data Entry Forms during data entry. Whenever the value is first set or changed you can trigger your own JavaScript to executing things like calling the REST API to retrieve data so that other fields can be calculated or validated.
Add – Field Advanced Button / Appearance / Column Index to override the default column position of fields in the Web Channel Data Entry Forms. By default, Forms align the fields into one column but they can support up to three columns. Use the Column Index to force a field into a column position, for example Column 1,2 or 3. Once this is done the Form will auto detect the maximum column positions required and auto assign fields a column index if not set here. Note: In the REST API Help you will notice there is also a URL parameter & fieldsPerLine=[1..3] that can set the Forms max columns.
Site Setup
Add – Users / Report / Security Audit Log now logs addition new events to give even more visibility over security sensitive changes in addition to the existing ones like adding, delete users and changing passwords. The log now also records changing of the following settings: Administrator, User Disabled/Enabled, Password Complexity, User Group and the User Expires Date.
Web Channel
Fix – Filter Pane would pass an invalid filter parameter to reports <same as> instead of <_same_as> which is a special tag to indicate the to filter value is the same as the from filter value. This would show up as a invalid filter value in reports where the from and to filter values were the same.