Initial Release

Fixed deployment from scratch issues

Fixed ZPM module

• Added customizable unauthorized error checker (see IsAuthError() method)
• Added RawJWT mode when the server returns only a JWT token as plain text. In this case, the API client extracts the expiration date from the token payload. I consciously did not add signature verification, since it requires additional elements (encryption algorithm, public key) and is not needed to extract the date
• Bug fixes

Initial Release

Initial Release

Initial Release

Initial Release

more detailsAn AI Assistant in the SQL editor with your own API key, an offline viewer for .gof global exports, jumping from a result row straight to its Global node, Azure SQL Database listing every reachable database, a Server Navigator search box with a properties-grid connection panel, and a broad round of fixes against the window freezing during long operations.

Five days after 4.01: 29 changes, headlined by two features that reach into territory SQL DATA LENS did not cover before — an AI Assistant in the SQL editor, and a way to read a .gof global export with no server connection at all.

One thing to know before you update. A newly opened SQL editor no longer collects IRIS/Caché execution statistics by default — the chart button in the editor toolbar, or Tools > Settings > InterSystems IRIS / Caché > SQL editor, turns it back on, per editor or as the default for editors you open afterwards. If you had already switched it on, that choice is kept.

NEW AI Assistant in the SQL editor. Three actions in a new AI menu — Generate SQL from description…, Explain statement, Explain execution plan — bring an AI model into the editor, with IRIS/Caché domain knowledge (maps, Master Map scans, bitmap vs. standard indexes, TuneTable state) added to what the model already knows about SQL. Bring your own API key for Anthropic, OpenAI, Azure OpenAI or a self-hosted OpenAI-compatible endpoint under Tools > Settings > AI Assistant. Off by default everywhere; switch it on per connection under the connection’s new AI tab. No row data and no connection credentials are ever sent, SQL literal values are masked by default, and a preview shows the exact text before anything goes out. Available in the paid editions and in the verified trial, not in the Free Edition. Details on AI Assistant.
NEW Open a .gof export with no server connection. File > Open .gof File… reads an InterSystems block-format global export (%GOF, OutputFormat 7) straight from disk: a header with format version, export time and namespace, a globals table with node and byte counts, and a subscript tree that expands level by level, so an export of several gigabytes with millions of nodes stays navigable. The value panel shows a node as text, as a hex dump, or as decoded $LIST elements. Filter the global list by name, jump to a node with Go to ^Global(1,"x"), and export or copy a selection as ZWRITE text or CSV. Needs a paid edition. See Global Browser.
NEW From a result row straight to its Global node. Right-click a row in a query result against IRIS/Caché and choose Show in Global Browser to open the Global Browser with the real subscript values of that row already filled in — a simple numeric key or a composite one, several rows at once for a pick list. Only offered when the row’s table resolves unambiguously (not for joins or views) and uses ordinary storage.
FIX Long operations stop freezing the window. Testing a connection, loading table details, scanning a folder for Query Cloud, collecting a support bundle, generating a table/view/procedure script, saving a trigger or an ER diagram, and expanding a connection’s Namespaces node now show a progress window after about a second, keep the window responding while they run, and offer a Cancel button that actually hands control back — even when a database driver is still waiting. Alongside it: a connection the server has quietly dropped is now recognised and rebuilt instead of failing on one that only looks alive, in table detail tabs, the ER diagram save and elsewhere.
FIX Azure SQL Database now lists every database your sign-in can reach, not just master. Leave Database Name empty on the Azure tab and Catalogs shows them all; opening one connects in the background, reusing the sign-in you already made — no second Microsoft Entra browser prompt. Fixes the database-switch error SQL Server 40508. Existing connections benefit without any change.
NEW A search box above the Server Navigator tree, and connection details as a real properties grid. Search by connection, group, host or user name (Ctrl+F, Esc, Arrow Down/Enter); matching groups expand and the tree returns to its previous state once you clear the box. The connection details panel is now sortable and copyable, shows host, port, namespace, driver, product version, read-only marking and the encryption in effect, a “Stand hh:mm:ss” timestamp plus a Refresh button, and — for a connection that is not open — its configured settings instead of an empty panel.
NEW Class view signatures, and a filter field that remembers. The IRIS/Caché class view now shows methods, properties and parameters with their full signatures and description text, not just bare names. The Data tab’s Filter field remembers the filters you last used on a table and offers them again as a dropdown, newest first. Alongside it, a security fix: a connection created before 4.01 could still carry a leftover user name, password or encryption setting on its Properties tab — it is now removed automatically the next time SQL DATA LENS loads your connections.
All 29 changes are in the complete 4.02 changelog.

Complete changelog for 4.02

Initial Release

fix typo in docker start

Simplify Docker container build
No Dockerfile required

simplify docker build
no Dockerfle requred anymore

simplify container start
make it a templates

Improvements by report

Fix Link to Analyzer Plus
http://localhost:52773/csp/USER/BIExport.UI.Analyzer.cls

Not from SMP !

Initial Release

New logo and IPM version

technical release

No pivot needed - BIExport.UI.DemoPage.cls is a self-contained form with a few canned MDX queries and totals/aggregation toggles. Pick one, click a button, get a real .xlsx/.json download, using the exact same code path as the buttons below:

/csp//BIExport.UI.DemoPage.cls

Totals: independent row/column totals, now with real aggregation functions

Row totals ("Total" column) and column totals ("Total" row) can now be turned on independently — previously, enabling either one always turned on both.
Totals now support Sum, Count, Min, Max, Average, and % of Total — the same options already in the Analyzer's own Pivot Options "Summary" dropdown, applied consistently to your export.
Fixed a bug where the exported file's totals didn't match what the Analyzer displayed on screen for the same pivot.

Initial Release

The highlights:

• Encrypted connections without the ceremony. The TLS Assistant fetches the server certificate, validates it, writes the trust store, and tests the connection. No properties file, no keytool, no restart.
• Server-side source code search across a whole namespace — plain text or regex, including "Where is this used?" from any table or global. Nothing gets downloaded to be searched.
• "Why is this slow?" — answered while the query runs. IRIS execution statistics sit right in the SQL editor: global references, disk reads with latency, and the stream columns that make a fast query take minutes.
• Dev, Test, Production — with a real guard. A [PROD] badge on every tab, plus a read-only mode that the editor, grid and Data Pumper actually enforce.
• Export, Import, Compile and Delete in the Classes context menu work on IRIS again.
• And beyond IRIS: connect to Azure SQL, Fabric Warehouse and Fabric SQL database with the same sign-in methods SSMS offers — run az login once, no token to paste. When Azure refuses a connection, you get the actual reason instead of "Login failed".

more details: https://sqldatalens.com/whats-new/4-01/

Initial Release

Initial Release

readme updated

Initial Release

Addressed reported issue on Nov 3, 2025.
Plase see https://github.com/IRISMeister/iris-c-language/issues/2 for details.

video youtube

rename