Bootstrap

#Query Builder

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

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

Query Builder Fix – Filter Mapping did not work correctly when used in combination with multiple Company or Business Unit filter selections.Fix – new Output Sub Queries were not showing Expression[...続きを読む]

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

Publisher Fix – Google Map Layers did not always work correctly when displaying pins with labels and did not show any pins due to a JavaScript error.  This was recently introduced.Add – Googl[...続きを読む]

Version 5.1.90

Query Builder Fix – Dynamic Columns based on Dates with a Year/Month function applied to them would not work correctly in Excel if dates were referenced in cells instead of text in YYYY/MM format.[...続きを読む]