Web Channel
- Fix – Percentages in Data Entry Forms and Grid had to be entered as a value between 0 and 1. Can now enter 45 for 45% and 1 for 1% etc.
- Fix – Data Entry Grid number sliders did not update correctly
Site Setup
- Add – LDAP sync now has a timeout setting in seconds used for Google LDAP syncing.
Client Setup
- Add – Now has auto backup and restore on UI as combobox near find. Will save the details with the date time stamp or if specified the name entered into the ComboBox. These can then be restored by selecting one of the items in the ComboBox. This is useful when connection details are lost for whatever reason. Keeps a history of the last 20 changes.
Engine
- Fix – Support for SQL Server date types datetime2 and datetimeoffset. Previously there would be SQL errors when filtering or outputting fields of these types. Now engine validates date, date, datetime, smalldatetime, datetime2 and datetimeoffset with the correct ranges and also writes back the data correct too. Note that date, datetime and smalldatetime have a narrower year range.
- Change – SQL Server data type date will no longer unnecessarily produce SQL to strip the time part of the date off as it is not required. This logic does require the Datamodel to have the original SQL data type set to date to work otherwise it will revert to stripping the time logic as it did in the past. This change would mean that SQL should have a small performance increase.
Foundry
- Add – Field list display shows more details like format, default values and data entry method etc
Studio
- Add – Oracle ODBC DSN Connection template. This was added due to Oracle ODAC often failing to install the .NET Data Provider correctly. By having this Oracle ODBC supported it will apply all the Oracle SQL Syntax setting to an ODBC connection as it would for .NET Data Provider.
