#Scheduler
Version 5.2.87
Web Channel
Fix – Form Entry multiple column display using URL parameter &fieldsPerLine=2 or greater would not display error message correctly under the value.Fix – Form Entry values lists for[...続きを読む]
Version 5.2.85
Site Setup
Fix – Azure AD sync did not work correctly with Client Secrets.
Reporting Rows
Fix – Reverse Sign worked correctly when numbers had the most common underlying data type of decimal[...続きを読む]
Version 5.2.75
Query Builder
Fix – Sub Queries filter that used != <blank> instead of !<blank> did not work correctly and would do an equal to blank instead of not equal to blank. &n[...続きを読む]
Version 5.2.71
Query Builder
Change – System / File List table could not handle more than 1000 rows which was not enough for large file system queries. Tests were conducted with 50,000 rows.
Scheduler
[...続きを読む]
Version 5.2.69
Query Builder
Fix – If Unions created different number of outputs in their results would sometimes fail when returning data over Remote Connections while Local Connections were fine. The err[...続きを読む]
Version 5.2.45
Query Builder
Fix – Sub Queries did not initialize multiple selected Companies or Business Units if they were the first to encounter them. Issue introduced in v5.2.35
Site Setup
Add – [...続きを読む]
Version 5.2.39
Query Builder
Fix – Sub Queries filter would become incorrect on rows after being passed <<! Not in listFix – System Web Table, JSON, XML would return an error if an empty JSON array w[...続きを読む]
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[...続きを読む]