Query Builder
- Fix – Sub Queries filter that used != <blank> instead of !<blank> did not work correctly and would do an equal to blank instead of not equal to blank. This issue was introduced around v5.2.30.
- Fix – System table Web Page and the repeater filter would not exit when combined with Configuration Snapshot. The query continues trying even when no data was returned until all the repeater values were called which would cause delays. Now by default it breaks out of the repeater values if 50 consecutive queries are done with no data. To control how long to persist with calling repeater values with no results see the new filter called “Repeater Abort”. For example, if set to 1 it will abort the repeater loop on the first query that returns no data.
Scheduler
- Fix – Action SQL statements trusted connections did not work with Materialised Query Databases unless the tables were prefixed with the database name.
Foundry
- Add – Writeback setting called ‘Allowable Characters’ to better restrict data entry characters and patterns using .NET regular expressions or a pre-set list of keywords for the most common patterns like <EMAIL> or <CODE>.
![](https://sharperlight.jp/wp-content/uploads/2022/01/image-29.png)
Studio
- Add – Field Writeback property called ‘Allowable Characters’ to better restrict data entry characters and patterns using .NET regular expressions or a pre-set list of keywords for the most common patterns like <EMAIL> or <CODE>.
![](https://sharperlight.jp/wp-content/uploads/2022/01/image-28.png)