Bootstrap

#Query Builder

Version 5.3.26

Query Builder Fix – Filters when set to Single would sometimes drop the << part of a multiple value filter list.  E.g. <<A,B,C upon reopening the queryAdd – Expression to calculat[...続きを読む]

Version 5.3.6

Query Builder Fix – Filtered Outputs and Dynamic Outputs did not work correctly on the SunSystems Ledger FilterFix – Filter Sub Queries that return no results when mainly dealing with Dates or Per[...続きを読む]

Version 5.2.132

Query Builder Add – Period offsets now have after offset support similar to dates Scheduler Fix – files path that used environment variables like %TEMP% did not always work. Web Chann[...続きを読む]

Version 5.2.128

JavaScript Fix - Lib_sys.rlContent.Post and Lib_sys.rlContent.Get timeout (millseconds) was not working and would always timeout after about 120 seconds.var timeout = (2700*1000);var =result [...続きを読む]

Version 5.2.124

Query Builder Add – Expression to create KPI Boxes with drill throughs and background images. See  HtmlKpiBox(<Title>,<Title CSS Style>,<Big Value>,<Big Label>,<Big[...続きを読む]

Version 5.2.106

Publisher Add – Themes has new setting to override the Title Colour.  Fix – Chart / Treemap height did not work. Scheduler Add – Default global Themes are applied when saving as qu[...続きを読む]

Version 5.2.102

Site Setup Add – Support for Azure AD Multifactor Authentication and Sign on Windows.  Note that if you cancel the Microsoft sign on window you can still sign in with the Sharperlight Window.[...続きを読む]

Version 5.2.93

Query Builder Fix – Sub Query filters using a in clause with two items would be resolved as a SQL between instead of a SQL IN.  e.g.  <in> A,B  <<A,B   If the [...続きを読む]

Version 5.2.89

Query Builder Fix – Sub Query filters using a in clause with two items would be resolved as a SQL between instead of a SQL IN.  e.g.  <in> A,B  <<A,B   If the [...続きを読む]

Version 5.2.79

Site Setup Fix – Azure AD sync did not work correctly with Client Secrets. Web Channel New – Index menu page now has a new entry under the License menu called License – Vendor Issued.  [...続きを読む]

Version 5.2.77

Materialized Queries Fix – Seed Queries with Unions filters that referenced the parent filters would drop and become resolved.  e.g.  {@RefParent} would resolve to a constant.  This[...続きを読む]

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.65

Query Builder Add – System / Web Page Table…JSON Table now supports named arrays by specifying the start position with [] on the end.  E.g.   employees[] Shared Authentication [...続きを読む]

Version 5.2.63

Excel Fix – Group Writeback depending on the contents would leave database transaction open. Reporting Rows Fix – Override default format would display in the wrong columns positions if comb[...続きを読む]

Version 5.2.59

Publisher Fix – Obscured Outputs would still display as a thin column when combined with Groups (Group=) in Tables but was fine in Table Grid Query Builder New – System Table Financial Data [...続きを読む]

Version 5.2.55

Studio Add – File Move now has Wild Card search and Filter Criteria.  The action is only executed when the Filter Criteria is true.  For example, the file or files are older than 2 days [...続きを読む]

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.43

Site Setup Fix – Google LDAP failed in Web Channel with endless refresh loop depending on the LDAP data.Add – Two-Factor Authentication can now be forced so the end user cannot deactivate it. [...続きを読む]