Bootstrap

#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 [...続きを読む]

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[...続きを読む]

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[...続きを読む]