Bootstrap

Query Builder

  • Fix – Sub Queries filter would become incorrect on rows after being passed <<!  Not in list
  • Fix – System Web Table, JSON, XML would return an error if an empty JSON array with no data was returned. E.g. []

Studio

  • Add – Field properties to allow live calculations in the Web Channel Forms and Grid during data entry.   For example, to display the Cost given [Quantity] * [Price] or the Total for four budget quarters [Q1] + [Q2] + [Q3] + [Q4].  Simple calculations can reuse the SQL logic while more complex calculations can be defined using the Custom JavaScript property.  The colour can also be set to distinguish the field from normal data entry fields.

Foundry

  • Add – Field properties to allow live calculations in the Web Channel Forms and Grid during data entry under the Advanced button writeback section.   See Studio comments above.

Site Setup

  • Add – Sync LDAP Config now has the option to manually sync users.  This is used when the list is very large and it takes a long time to resync the users in Realtime.   The user list can still be resynced via Site Setup right click menu and also by using the Scheduler User Synchronize Action.

Scheduler

  • New – Action to resync Site Setup LDAP Users.  This is used when LDAP takes too long to sync and it’s better to sync manually via Scheduler Timer.   Used in combination with new Sync Option called Manual on the Site Setup – LDAP Config Window.