Foundry

  • Add – Resources now shows a Link Reference for Folders and Files so that content such as JavaScript files can be easily imported into various location such as a Table’s Library and Setup etc.  This is useful because the files can be edited externally with tools like Studio Code.
  • Add – Global option to restrict all Table Lookups to active records based on a specified column.  For example, if the Tables have an [Active] or [Enabled] Column then the Lookups would only show Active or Enabled records.
  • Add – Table Sub Folder support by using a backslash in the Folder Name (One level only).  E.g. Finance\Sales
  • Add – Table option to conditionally Lock/Read-Only records. The most common usage would be to lock at record if the user is not an Admin User to prevent users from editing or deleting core system data like a Rates table.  Another example would be basic workflow where once the record’s Approved column has been set to Yes, the record is locked for non-admin users preventing them from deleting or updating the data. E.g. IsYes(“{/Approved}”) AND {_User.IsAdmin}=0
  • Change – Table joins will use the field code when multiple joins to the same table are present instead of a number sequence of 1, 2 and 3 to better clarify the meaning of the join.
  • Fix – Table permission only supported code inclusion and would deny access to all records if Read was to No access.  It now supports exclusion of codes in addition to inclusion.

Web Channel

  • Fix –Form Entry multiple select checkboxes would not save the first checkbox value.
  • Change – Form Entry checkboxes and radio buttons would only display for fields with value lists.  Now displays any field as a multiple select checkbox list or a radio button list.
  • Change – Table Grid Filters will now default to 3 filter per line instead of 2.

Scheduler

  • Fix –Web scrapping using the “Action Save Web Page As” would sometimes fail to get Sharperlight web content due to the Sign On prompt.

Query Builder

  • Fix –Period Filter custom formatting with offsets did resolve correctly when referenced from another Filter

Publisher

  • Change – Report Packs will now auto wrap output captions into two lines to narrow the overall report width. Also, date fields will be sorted so that the most recent dates will be at the top if the field is a primary field or withing the first 3 columns.
  • Add – Support for the Font Phetsarath

Materialised Queries

  • Add – The Database size statistics are now displayed for each Materialised Query Database. It is also possible to Shink the Database files when they become too large.  This can be important given the log file can increase in size over time.  Note that the Shrink will set the Database recovery to Simple to avoid Log file growing too large and to improve performance.
  • Add – Tables will now display the number of records. This is helpful when diagnosing refresh issues and errors as the record count will be visible.  These stats are also available in the System \ Materialised Table for reporting.
  • Add – Table history can be accessed via the right click menu.

Spreadsheet

  • Fix – Shapes colours and borders now better match the original shape in Excel.
  • Fix – Shapes with content cell references are now supported.
  • Fix – Cached Reports would not refresh the Data if Workbook or Worksheet Refresh buttons or menus were used by user.  Now forces a data refresh even if caching is enabled.
  • Fix – mdValue were always returning the first output in the query even if it was hidden.  Now looks for the first visible. output.