Query Builder
- Add –Support for Not blank or null keyword tag !<blank_or_null>
- Add –Support for Not blank or zero keyword tag !<blank_or_zero>
Excel
- Fix – Writebacks created in previous versions would display an error message that No Driver field has been set preventing writeback from working until a Driver Field has been set in the mapping. Previous versions would auto set the Driver Field if not set but in version 5 this was changed to insist on a Driver Field and therefore caused this issue with backward compatibility. Now if editing an existing or create a new writeback the Driver field is required while if executing an existing writeback the auto detect logic for Driver Fields will determine to best field to be a driver like in previous version which in most cases will be the first cell reference field.
- Fix –Writeback support for Header Lines was very limited. It would only allow for one Header with multiple lines to be written back. This has now been fixed so that multiple Header and Lines can be posted back. For example, fix invoices each have many lines can be posted at once.
Site Setup
- Add –Writeback History now has additional option to also record full details of the writeback which the writeback data. To date the details records where such attributes as the date, time, user, product, table, status and writeback response. There is now a report button to view the last month of writebacks in addition to the existing Web Channel report found on the index page.
Publisher
- Add –New tag to get filter URL parameters section {*Data.URL.Filters}
Scheduler
Fix –Nested Query Combinations value references did not show the correct values from the second level to third level