Command Line
- New – /ProductSettingsSet Allows the setting of Site Setup / Product Settings via the command line. (See online article for details)
- New – /RemoteConnectionSet Add, Update and Delete Client Setup / Remote Connections. (See online article for details)
- New – /ServiceConnectionSet Add, Update and Delete Client Setup / Service Connections. (See online article for details)
Client Setup
- New – Service property called Active Directory Domain Default. This allows users to omit the Active Directory Domain name from their user account when signing in. For example MyDomain or MyDomain.com.uk
Query Builder
- Fix – Output Alignment Formatting will now always align all the content in the column instead of just the Head section. This flows through to the Web Channel Table, Table Grid, Table Basic, PDF and output to Excel
Scheduler
- Add – Task Action Web Hook now supports PUT, PATCH and DELETE in addition to the existing POST and GET methods
Foundry
- New – Data Types, Color HTML Basic and Color HTML. Both accept HTML colors e.g. #FF00FF and display a colour picker in both the Entry Form and Grid Writeback. The color is displayed as a box in reports using an Expression.
- New – Data Types Geo Json format that is compatible with Google Maps. The general format is based on { lat:0.00, lng:0.00 } and depending on the object type is combined into arrays []. There are four data types Geo Point JSON, Geo Line JSON, Geo Polygon JSON and Geo Polyline JSON. These data types will do a validation check on data entered during writeback. Note that a simply format of numbers with commas is also supported. For example -31.953512, 115.857048 is converted to { lat: -31.953512, lng: 115.857048 } and 1,2,3,4 is converted to [ {lat:1,lng:2},{lat:3,lng:4} ]
Studio
- New – Special Move SQL tag to move section to just after Table Alias. /*MoveSQLBlockAfterTableAliasBegin*/ /*MoveSQLBlockAfterTableAliasEnd*/ This is useful for creating conditional SQL Index hints in MySQL