3.17 released on 2024-05-30

• ENH : New Driver 3.8.4 from InterSystems IRIS 2024.1 added
• ENH : TableViewer : Some driver ignore the setMaxRows Paramter like DuckDB. So for some databases the row limitation is done by TOP x or LIMIT x
• ENH : TableViewer : Column size in grid optimized
• ENH : TableViewer : Count rows function recognizes keywords in object names that need to be quoted. So now less errors when counting on system tables.
• ENH : Flat Look and Feel updated to 3.4.1 (https://github.com/JFormDesigner/FlatLaf) – more Windows 11 features
• ENH : Many internal libs upgraded
• FIXED: Notepad content was multiplied after close and reopen the notepad tab
• ENH : DuckDB driver upgraded to 0.10.3
• FIXED: SQL History : Threading issue fixed

3.16 released on 2023-10-08

• ENH : TableViewer : “open in new tab” improved
• ENH : Cached Queries : Delete selected cached query and delete all cached queries for selected tabel is now working for IRIS
• ENH : SQL Editor : Copy table on server side works now for IRIS and use the CREATE TABLE

• ENH : SQL Editor : More keywords for Intersystems IRIS integrated
• ENH : TableViewer : Show storage details for IRIS, like table (global) sizes
• ENH : The licensing system has been updated to fix issues with error code 28 based on a disabled network adapter. The activation process needs to read all of a computer’s components to get an accurate “fingerprint” of the computer, and this includes all real (aka non-virtualised) network adapters attached to the computer.
• ENH : ServerNavigator : Database metadata viewer improved with more detail and better sorting
• ENH : DuckDB (driver) upgraded to 1.0
• ENH : New shortcut to create a in memory DuckDB connection
• ENH : Simply drag and drop the csv\parquet\json file onto the DuckDB connection and the necessary SQL statements will be generated to read the file with ease.
• FIXED: Connection dialogue box is now centred on the main frame
• FIXED: DuckDB connections are created with the right duckDB icon. You need to recreate the entries to fix this problem for existing connections.

Bug Fixes

• Major development on core engine components (23.2.6) that improve VDM's overall performance, scalability, stability and usability. (Task 1615)
• VDM's Datawarehouse feature now stores Grid Level expressions for both the Detail and Summary Grids. (Feature 1627)

• (Bug 1621) - VDM: Scheduler Appointment Options Differ Using Database vs Calendar File
  • When the Calendar file is used, we don't have all the options available. (Minutely / Hourly / Time Zone, etc.)
• (Bug 1623) - VDM: Scheduler - Job Management Errors
  • After changing view / execution order and saving the job, the next job you would open will have the wrong order of your jobs.
  • Adding views to an existing job would cause job to inherit the execution of the selected view when clicking add.
• (Bug 1624) - VDM: VDM: Finished Reports - Designer Button Opening Multiple Tabs
  • When clicking on the FInished Report Designer Button with the designer already open, VDM would open another tab for the Finished Report.

• This is the latest release available to match the current VDM release (2024.2.6.0) as of 2/6/2024.
  • We always recommend that the latest (matching) version of VDM and WebReports are installed.
• We have added WebReports compatibility for the following VDM features: (Feature 1591)
  • Cleaning MDX queries for characters
  • The ability to run multi dimensional MDX queries
  • The ability to run MDX MQ views
  • The ability to differentiate between PivotExecute and MDXExecute
  • Added to Intersystems IRIS BI
• Add the functionality needed to execute single level MDX Queries to IRIS Analytics BI/DeepSee to WebReports (Feature 1593)

• ;Encrypt=Yes;TrustServerCertificate=Yes;

• Replaced the Real data type for MDS / Datawarehouse with Dec(18,4). (Task 1579)
• We have updated the Default Connection String in the appsettings.json for WebReports. This will address the Breaking Change in this build for any new users of WebReports (any users with existing appsettings file will have to update it manually.) (Task 1594)
• Major development on core engine components that improve VDM's overall performance, scalability, stability and usability. (Task 1596)

• (Bug 1580) - WebReports: Parameters - Visualize Parameters Not Being Passed
• (Bug 1605) - WebReports: MFA - 400 Error
• (Bug 1619) - WebReports: Error Updating Roles (More than 1024 Items)

• Major development on core engine components (23.2.6) that improve WebReports's overall performance, scalability, stability and usability. (Task 1616)

• Added isc.codetidy to repository

• fixed issue with slow data refresh on chart widgets

• fixed default filter value with "Not" issue

• Simplified IRISELK.BusinessOperation.LogstashOutbound
• Allowed for monitoring subnode in configuration.json