Scheduler
- Fix – Writeback that used Queries as a Source would get the values out of alignment if there were hidden outputs. The hidden value would get into the writeback list pushing other values down. If the hidden column was on the very end there was no issue.
Query Builder
- Add – Web Table Query now supports array positions in the Expand Fields. By default, a sub-class is shown as a JSON text string but when expanded the individual fields appear in the selection list. In the case of an array the first item is returned. To return all the items in a array suffix the field name with [*] For example contact[*] to just return the first and second array position use contact[1]|contact[2]
- Add – Web Table Query now supports Field Selection List. When querying JSON for example there may be many fields that are not required. Selected Fields will restrict the field list to just the ones in the list. This is also useful when dealing with JSON objects that have optional fields or varying fields that change the schema and break queries/reports. By defining a Field Selection List, it solves this issue as the order and fields returned are fixed and do not change.