ENH : SQL Editor : More new IRIS keywords are hightlighted, e.g. for new Windows Functions https://docs.intersystems.com/irislatest/csp/docbook/DocBook.UI.Page.cls?KEY=RSQL_windowfunctions
ENH : SQL Editor : New code completion for “SET OPTION”
ENH : SQL Editor : New Generic CodeCompletion provider for all other databases than IRIS\CACHE e.g. MS SQL SERVER
ENH : TableViewer : Rebuild Index works now for IRIS. This is executed with %NOLOCK %NOJOURN
ENH : TableViewer : Tune Table works now for IRIS.
ENH : TableViewer : New Tune Table with %RECOMPILE_CQ: will recompile the cached query classes using the new Tune Table statistics.The new action
ENH : New Driver 3.6.1 from InterSystems IRIS 2022.2 added
FIXED: SQL Editor : Connection handling for the SQL Editor has been improved. Each SQL Editor uses only one “private” connection.
Querying the namespace objects created a second public connection. This caused the editor to open more slowly. This is now fixed. The editor now only needs one database connection.
A public connection is now only created when navigating in the server navigator. The server navigator uses its own connection, independent of any open editor.
ENH : Windows setup works now with lowest privileges.
FIXED: Scriptmanager : Scrollbars in Scriptmanager window fixed.
FIXED: ServerNavigator : Connectionhandling is now faster
ENH : Setup : Setup comes now with asigned uninstaller, so the “unknown publisher” message is gone by unstalling SQL DATA LENS
Setup can now be executed in non administrative mode
ENH : Flat Look and Feel updated to 3.0 (https://github.com/JFormDesigner/FlatLaf)
ENH : Many internal libs upgraded
3.12 released on 2022-09-18
ENH : SQL Editor : Min\Max\Avg\Sum values are calculated on selection in tablegrid
ENH : SQL Editor : Sorting performance in grid improved
ENH : From table results the new option “Copy pretty formatted” is available
ENH : More visible connection details for IRIS, eg. using shared memory, server local, and more…
FIXED: Open TOP 1000 rows of a table produce in some situations invalid sql statement
ENH : TableViewer : Performance improvments for SQL Server connections