#Query Builder
Version 5.6.18
Query Builder
Add – Filter option called ‘Sub Query Suppress’ to conditionally execute an output Sub Query to improve execution performance. In advanced reporting the output Sub Query may need o[...続きを読む]
Version 5.4.52
Form Designer
Add – Allow Workflow labels to be customised
Query Builder
Fix – Filter Period custom formatting would disappear on editing if the Format tab was not active when savingFix [...続きを読む]
タグ: 5.4, Query Builder
Version 5.4.46
Query Builder
Add – Selection tree right click menu mode switch called ‘Abbreviated Descriptions’ to allow the stripping off of the table prefixes on field descriptions when outputting and filteri[...続きを読む]
Version 5.4.40
Query Builder
Fix – System Excel table would miss the last few rows of a dataset when a single cell offset such as B3 was entered while B3:E9999 was fine. The number of rows missing matched [...続きを読む]
Version 5.4.36
Query Builder
Add – Period Formatting options for both filtering and outputting periods. Previously periods where always formatting using the year and period number e.g., 2022/009. Now[...続きを読む]
Version 5.4.24
Query Builder
Add – Filter option to return the description when filter on Value Lists instead of the code. This is helpful when the code is not descriptive enough for the user or when displ[...続きを読む]
タグ: 5.4, Query Builder
Version 5.4.22
Query Builder
Fix – Company/Business level filters that reference filter mapping #[….] in Excel would raise a error when creating or editing Drill downs or Unions.
Version 5.4.18
Query Builder
Add – Lookups are generally by default limited to 1000 rows but this can now be overridden by using the Change row limit checkbox. Note the Change row limit will only show when[...続きを読む]
Version 5.4.10
Publisher
Fix – Improved refresh list performanceAdd – Addition references tags to get Product attributes like Description, Author and Version e.g. {*Product.Description.<productCode>} or {*[...続きを読む]
Version 5.4.6
Site Setup
Fix – License Check did not work on Remote Connections
Studio
Add – Schema – Import Value Lists
Security Roles
Fix – When Creating new Security Roles the initial field detai[...続きを読む]
Version 5.4.2
Form Designer
Add - Data Type Encrypt
Publisher
Add – Security – Report menu with generates a report with all the security details of each published report. This includes what us[...続きを読む]
Version 5.3.54
Security Roles
Fix – Company or Business Unit security roles were being applied to all users instead of the target users and groups which means it was too strict. Now only applies to the use[...続きを読む]
Version 5.3.52
Query Builder
Fix – Sub Queries when combined with Reporting Rows would under rare cases not adjust their filters correctly if moving from a filter in list of more than two <<A,B,C &nbs[...続きを読む]
Version 5.3.42
Query Builder
Fix – Drill Through did not respect output custom widths when set.Add – Expression can now reference the current product dictionary directly via tags instead of the Dictionary Functi[...続きを読む]
Version 5.3.32
Query Builder
Fix – Filters with Sub Queries based on NOT IN logic !<in> worked correctly until there was only one item in the list and then it would set the where clause to equal that one i[...続きを読む]
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[...続きを読む]