#Query Builder
Version 5.0.65
Scheduler
Fix File Exist Goto Action raised serialization error when using Remote Connections
Query Builder
Fix – Product Lookup did not always display license information correctly when con[...続きを読む]
Version 5.0.51
Query Builder
Fix –Annotations Icon expression did not show correct icon if there were hidden outputs before it
Publisher
Fix – Grid total row were always centre aligned. Now right ali[...続きを読む]
Version 5.0.50
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 – W[...続きを読む]
Version 5.0.46
Site Setup
Add –Support for Microsoft Online Accounts. The Account type is MicrosoftAdd – New User right click menu item to add the current user accountAdd – Accounts that have blank passwor[...続きを読む]
Version 5.0.44
Scheduler
Add –Web Channel Scheduler page now allows Daily trigger times to be setAdd – Query Builder System Scheduler Table now has two new fields to shows Daily Time field and attributes when th[...続きを読む]
Version 5.0.29
Writeback
Fix – Boolean Yes/No validation and handling of nulls was not correct. Was saving nulls as No instead of Null.
Client Setup
New – Service Properties now has a set of fields t[...続きを読む]
Version 5.0.23
Query Builder
Add – UTC Dates can now be filtered or output directly as a UTC Date Time. By default, all database UTC Dates are automatically converted to local time for the outp[...続きを読む]
Version 5.0.13
Scheduler
New – Actions now have a On Error attributes that allows finer control of error handling. If an Action fails it is not possible to jump/goto another Action within the current Task [...続きを読む]
Version 5.0.10
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 v[...続きを読む]
Version 5.0.9
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 a[...続きを読む]
Version 5.0.7
Query Builder
Fix – Expression RowAddAfter and RowHeaderAfter did not work
Report Rows
New – Option to override Amount formats. Useful for when a row needs to be a percentage while all[...続きを読む]
Version 4.8.112
Query Builder
New – System Table to query Microsoft Teams in Office 365Add – System Table Web Table now has support for ready OData pages. The default is 10 pages but under options you can s[...続きを読む]
Version 4.8.111
Web Channel
Fix – Table Grid report where no showing Page Navigation after build v.4.8.104.Fix – Reporting Rows Grid edit did not work – Line Error on filter
Filter Mapping
Change – Company [...続きを読む]
Version 4.8.107
Scheduler
Add – Authentication Type details now has a new option to restrict its usage the to the original Task and Action Code at the time of its creation. This prevents the details being u[...続きを読む]
Version 4.8.106
Query Builder
Removed – Output menu Drill Link as this depended the old XBAP deployment of Sharperlight which has been deprecated.
Web Channel
Add – URL Parameter called formatOutputs that a[...続きを読む]
Version 4.8.101
Query Builder
Change - System Excel Workbook Table now no longer stops at the first blank column but continues to search for data columns. Best to set the Cell Set Position with a range if p[...続きを読む]
Version 4.8.97
Query Builder
Add – Preview save as CSV to clipboard menu. This data can then be pasted into Excel or used as a System / Custom DatasetNew – Expression Forecast Linear function StatisticsFor[...続きを読む]
Version 4.8.95
Scheduler
Add – Writeback Action now exposes writeback options which are custom defined settings in the DatamodelAdd JavaScript new function to decode and encode XML data. lib_data.XmlEncode(strin[...続きを読む]
Version 4.8.86
Scheduler
Fix – Writeback Source Query was not settings correctlyNew – Action Microsoft Teams. Create messages in a channel in Microsoft TeamsNew – JavaScript library lib_sys.microsoft[...続きを読む]
Version 4.8.81
Web Channel
Fix – Save to Excel and CSV now hides obscured outputs.
Query Builder
Add – System Web Tab now has a Content Type filter in case the URL needs to know the content type which may [...続きを読む]