Query Builder
- Add – Output Expressions can now be used as filter parameters in Sub Queries. Previously the only way to calculate a value was by using Filter Expressions e.g. _Expression( ) which are harder to write and debug.
- Fix – Sub Queries would return the same value for all rows if a Filter range was passed a null value. For example, <null> to 2021-06-20 is now converted into <= 2021-06-20 and 2021-06-21 to <null> is converted into >= 2021-06-21.
Scheduler
- Fix – File to Text was always generated an output file even when set to blank
- Add – File to Text now has matching Text 1 and 2 as a general check to see if the keywords exist in the text or now
- Fix – File names in general would default to the MyDocuments folder if not path or default folder was specified which would raise a permissions error if Site Setup Trusted folders are active. New logic uses the first folder path in the Trusted folders list instead of MyDocuments as the working folder if none is specified.
Web Channel
- Fix – Grid Writeback would depending on the contain, for example Tabs would scroll top section off screen after a Delete prompt.
- Add – Create Menu added branding Theme button
Client Setup
- Add – Better error messages, Tooltips and Timeout setting for Microsoft LocalDB connections.