Reporting Rows
- Add – Find, Find Next and Search and Replace buttons
- Add – Row Icons and Colour coding to better identify the categories when editing.
- Fix – If SUBTOTAL and TOTAL calculations used Line Numbers instead of Line Names the result would sometimes return 0 if the resolved value of a Line Number matched another line Number. For example, 1200 + 3400 + 4200 would error and return zero if Line Number 3400 resolved to 4200.00 which happened to be the same as the Line Number 4200 part of the calculation.
Query Builder
- Add – The System Web Table now supports the overriding of field data types when URL links that return JSON, XML and HTML. The field in most cases the field data type will be returned as text. However, by putting the field description in the Data Type – Number or Data Type – Date filters one can force the field to always be converted to a number or date. Drag and Drop the fields from the selection list into the value box of the Data Type – Number and Data Type – Date value box area.
Scheduler
- Fix – Writeback source Query was showing as SQL statement on coming back into Action later. This issue was introduced v4.8.72.
- New – JavaScript library for sending emails via SMTP called lib_sys.io.emailSMTP
Foundry
- Add – New check box option to allow Query Builder editing in Web Channel Reports. When enabled a wrench icon will appear at the top right where the user can modify the Query behind the report. The existing right click options menu also has Query Builder which will also display the current query in an Overlay Windows. Previously this showed a XBAP version of Query Builder if setup (XBAP is being retried in favour of the HTML version of Query Builder).
- Updated – Template SL90015 multi period budget example