#Scheduler
Version 5.2.35
Query Builder
Change – Increase row limit on System tables such as CSV, JSON, XML, Web Tab, Excel, Windows Event Log, LDAP and MS Teams. Fix for v5.2.33 got SQL error when no dataFix – Sub Q[...続きを読む]
Version 5.2.33
Query Builder
Change – Increase row limit on System tables such as CSV, JSON, XML, Web Tab, Excel, Windows Event Log, LDAP and MS Teams. Previously it would max out at 1,000 rows but can now[...続きを読む]
Version 5.2.29
Query Builder
Add – When opening a Materialised Query that is associated with a Database that is not valid, a prompt now appears to allow the Query to be redirected to another MQ Database. T[...続きを読む]
Version 5.2.27
Query Builder
Add – Output Expressions can now be used as filter parameters in Sub Queries. Previously the only way to calculate a value was by using Filter Expressions e.g. _Expression( ) w[...続きを読む]
Version 5.2.23
Scheduler
Change – Save As Excel, CSV and PDF will now auto convert fields of data type HTML to text unless the Query Output name is suffixed with _Raw.New – Action to convert Office Word DOCX and[...続きを読む]
Version 5.2.21
Scheduler
Fix – User sign would fail when manually starting Tasks if the Service User Account was not trusted in Site Setup despite the task be set to run with current User. Now uses t[...続きを読む]
Version 5.2.13
Security Roles
New – User defined security that can be applied to almost any field in Query Builder. Select a field and apply security roles to it so that reports and lookups are restricted [...続きを読む]
Version 5.2.1
Scheduler
Fix – Save as Excel would fail if the dataset exceeded 1 million rows due to limit in 2010 Excel file format which the library uses. Raised Row Index error. Now auto splits t[...続きを読む]
Version 5.1.78..79
Query Builder
Fix – Filter <in> criteria would drop when reopening Query Builder. This issue was introduced in 5.1.78.Fix – Filter Mapping of Company or Business Unit selection in Exce[...続きを読む]
Version 5.1.74
Materialised Queries
Fix – Duplicate rows would appear if the Query seeding the MQ was based on one of the System Tables that is sourcing data not from the Sharperlight Database but rather the Clo[...続きを読む]
Version 5.1.60/62
Web Channel
Add – Dash Page Options on title to control display of Titles, Descriptions and also set the level of Row Selection Filters.
Fix – Data Entry Forms did not display Percentage fi[...続きを読む]
Version 5.1.48
Studio
Add – Field Writeback property to show and set extended attributes like User last modified, modified date, file details, Geo details etc. Previously the only way to set them was in th[...続きを読む]
Version 5.1.46
Scheduler
Fix – Published Report with Security to limit access to users and groups would fail when scheduled as it would deny access to the content no matter the user.
Excel
Fix – Header bac[...続きを読む]
Version 5.1.40
Scheduler
Fix – FTP did not display the file details when reopening and editing an Action. Action would work correctly but editing the file setting would require you set it again.Add – File [...続きを読む]
Version 5.1.38
Scheduler
Add – SFTP action now support Public Authentication Key Files
Add – JavaScript SFTP library Create Function now supports third parameter for Public Authentication Key data
Shar[...続きを読む]
Version 5.1.34
Publisher
Fix – Filter Sub Queries defined to refine the lookup where not working correctly when combined with wild card searches prefixed with ** or %Fix – PDF rendering would get an object error[...続きを読む]
Version 5.1.23
Web Channel
Fix – _Expression() sometimes appeared unresolved in Filter if it referenced a visible filter’s value. Now encodes as inline _Expressions( ) are not allowed in filters in the Web[...続きを読む]
Version 5.0.99
Command Line
New – /ProductSettingsSet Allows the setting of Site Setup / Product Settings via the command line. (See online article for details)New - /RemoteConnectionSet Add, Update and De[...続きを読む]
Version 5.0.98
Command Line
New – /CompileAll will recompile all Datamodels in the same way that Datamodel Installer / Force Recompile does. This may take a few seconds to complete so it is rec[...続きを読む]
Version 5.0.96
Site Setup
New – User Email notifications on password change, Web Channel Sign in and Rich Client Application Sign in (Excel, Publisher etc). This feature does not support AD users who enter[...続きを読む]