Scheduler
- Add – Writeback mapping can now support auto mapping based of the matching of the field names minus any special characters. See Auto Mapping on settings tab. When turned on anything that is not specifically mapped to an ordinal or column name is auto mapped. There is also an option to show errors if a match is not found. In this way unmatched fields can be manually set.
- Add – Writeback from JSON and JSON file now supports Field Expanding where a sub-class is flattened out into individual fields e.g. Contact: { “Phone”:”123”,”Mobile”:”456” } becomes Contact::Phone and Contact::Mobile
- Add – Writeback status can now be stored as a Task Parameter Name. It is always stored in JSON format.
- Add – Writeback status file now supports JSON and XML formats. Set the file extension to .json or .xml
Query Builder
- Add – Web Table Query now has new filter called JSON Expand Fields. Field Expanding is where a sub-class is flattened out into individual fields
- e.g. “Contact”: { “Phone”:”123”,”Mobile”:”456” } becomes
- Contact::Phone and Contact::Mobile
Previously one would have had to use an Expression to break up the JSON class into fields.
Publisher
- Fix – Annotation records were deleted if a Report code was changed using the main edit UI. The right click Change Report Code was fine and moved the annotations to the new code.
Studio
- Add – Table Import now allows the internal code to be based on the SQL object names instead of shortening them. See new checkbox