---
title: "Release notes of Invantive Query Tool Multi-Platform"
description: "The enhancements and bug fixes of the Invantive products per release, with what to check before upgrading."
language: en
canonical: https://documentation.invantive.eu/en/release-notes/products?product=invantive-query-tool-multi-platform
---

# Release notes of Invantive Query Tool Multi-Platform

**Products:** [Invantive Authenticator](/en/release-notes/products.md?product=invantive-authenticator&product=invantive-query-tool-multi-platform) | [Invantive Bridge](/en/release-notes/products.md?product=invantive-bridge&product=invantive-query-tool-multi-platform) | [Invantive Bridge Online](/en/release-notes/products.md?product=invantive-bridge-online&product=invantive-query-tool-multi-platform) | [Invantive Bridge Online Samples](/en/release-notes/products.md?product=invantive-bridge-online-samples&product=invantive-query-tool-multi-platform) | [Invantive Business for Windows](/en/release-notes/products.md?product=invantive-business-for-windows&product=invantive-query-tool-multi-platform) | [Invantive Business Server](/en/release-notes/products.md?product=invantive-business-server&product=invantive-query-tool-multi-platform) | [Invantive Cloud](/en/release-notes/products.md?product=invantive-cloud&product=invantive-query-tool-multi-platform) | [Invantive Connect](/en/release-notes/products.md?product=invantive-connect&product=invantive-query-tool-multi-platform) | [Invantive Control for Excel](/en/release-notes/products.md?product=invantive-control-for-excel&product=invantive-query-tool-multi-platform) | [Invantive Data Access Point](/en/release-notes/products.md?product=invantive-data-access-point&product=invantive-query-tool-multi-platform) | [Invantive Data Hub](/en/release-notes/products.md?product=invantive-data-hub&product=invantive-query-tool-multi-platform) | [Invantive Data Loader](/en/release-notes/products.md?product=invantive-data-loader&product=invantive-query-tool-multi-platform) | [Invantive Estate for Windows](/en/release-notes/products.md?product=invantive-estate-for-windows&product=invantive-query-tool-multi-platform) | [Invantive MCP Server](/en/release-notes/products.md?product=invantive-mcp-server&product=invantive-query-tool-multi-platform) | [Invantive Optimizer](/en/release-notes/products.md?product=invantive-optimizer&product=invantive-query-tool-multi-platform) | [Invantive Query Tool for Windows](/en/release-notes/products.md?product=invantive-query-tool&product=invantive-query-tool-multi-platform) | **[Invantive Query Tool Multi-Platform](/en/release-notes/products.md)** (chosen) | [Invantive Runtime](/en/release-notes/products.md?product=invantive-query-tool-multi-platform&product=invantive-runtime) | [Invantive Studio](/en/release-notes/products.md?product=invantive-query-tool-multi-platform&product=invantive-studio) | [Invantive Support Assistant](/en/release-notes/products.md?product=invantive-query-tool-multi-platform&product=invantive-support-assistant) | [Invantive UniversalSQL Server](/en/release-notes/products.md?product=invantive-query-tool-multi-platform&product=invantive-universalsql-server)

**Releases:** [26.0 to 27.0](/en/release-notes/products.md?product=invantive-query-tool-multi-platform&step=26.0-to-27.0) | [new in 27.0](/en/release-notes/products.md?product=invantive-query-tool-multi-platform&step=new-in-27.0) | [25.0 to 26.0](/en/release-notes/products.md?product=invantive-query-tool-multi-platform&step=25.0-to-26.0)

<div class="rn-block" id="invantive-query-tool-multi-platform-new-in-27.0">

<div class="rn-head">

Release Note - Download

## Invantive Query Tool Multi-Platform, new in 27.0

| Build | Date | Description |
|---|---|---|
| &ndash; | &ndash; | the product did not exist |
| `27.0.54` | 01-11-2026 | latest build of release 27.0 at the time of writing |

Invantive Query Tool Multi-Platform is an interactive SQL editor for Windows, Linux and macOS. It runs SQL on the Invantive UniversalSQL engine, so the same statements work on the many database and cloud platforms that the engine supports. It is meant for users who develop, test and run SQL and who do not work on Microsoft Windows only. It is a separate product next to Invantive Query Tool for Windows: it uses the same engine, databases, favourites and licence functions, but has a smaller and newer user interface and does not replace the Windows product. The product is new in release 27.0: there is no older release to compare with, so this note lists what the product can do instead of what changed.

- **45** enhancements
- **0** bug fixes
- **3** things to check before upgrading

</div>

<div class="rn-layout">

<div class="rn-index">

**This Note**

- [Before You Upgrade](#invantive-query-tool-multi-platform-new-in-27.0-before)
- [Top 25 Changes](#invantive-query-tool-multi-platform-new-in-27.0-top)
- [All Enhancements](#invantive-query-tool-multi-platform-new-in-27.0-new) 45
- [All Bug Fixes](#invantive-query-tool-multi-platform-new-in-27.0-fixed) 0
- [What It Builds On](#invantive-query-tool-multi-platform-new-in-27.0-builds)
- [More Information](#invantive-query-tool-multi-platform-new-in-27.0-more)

**Enhancements**

- [Installation and platform](#invantive-query-tool-multi-platform-new-in-27.0-e-installation-and-platform) 3
- [Licensing and sign-in](#invantive-query-tool-multi-platform-new-in-27.0-e-licensing-and-sign-in) 5
- [Security](#invantive-query-tool-multi-platform-new-in-27.0-e-security) 2
- [Scripting](#invantive-query-tool-multi-platform-new-in-27.0-e-scripting) 3
- [Query Tool user interface](#invantive-query-tool-multi-platform-new-in-27.0-e-query-tool-user-interface) 20
- [Platforms and drivers](#invantive-query-tool-multi-platform-new-in-27.0-e-platforms-and-drivers) 3
- [Export and import](#invantive-query-tool-multi-platform-new-in-27.0-e-export-and-import) 2
- [Logging and diagnostics](#invantive-query-tool-multi-platform-new-in-27.0-e-logging-and-diagnostics) 4
- [Translations and texts](#invantive-query-tool-multi-platform-new-in-27.0-e-translations-and-texts) 1
- [Documentation](#invantive-query-tool-multi-platform-new-in-27.0-e-documentation) 1
- [Other](#invantive-query-tool-multi-platform-new-in-27.0-e-other) 1

</div>

<div class="rn-main">

<div class="rn-before" id="invantive-query-tool-multi-platform-new-in-27.0-before">

### Before You Upgrade

These changes ask for a check:

- [Self-contained ZIP per operating system and processor architecture](#QTM-27.0-E003)
  - Download the ZIP for the operating system and processor, extract it in a folder and start the Invantive.QueryTool programme from that folder.
- [Running a script is a licensed function](#QTM-27.0-E009)
  - Check that the licence and the user rights include the function for running scripts before using Execute All.
- [Licence window to register a key or request a free, trial or public data licence](#QTM-27.0-E026)
  - Register a licence on the first start.

</div>

<a id="invantive-query-tool-multi-platform-new-in-27.0-top"></a>

### Top 25 Changes

<div class="rn-top">

1. [Interactive SQL editor on the UniversalSQL engine for Windows, Linux and macOS](#QTM-27.0-E001)
   - *Enhancement*
   - A capability that the new product offers from release 27.0.
2. [Same engine, drivers and settings as the other Invantive products](#QTM-27.0-E002)
   - *Enhancement*
   - A capability that the new product offers from release 27.0.
3. [Self-contained ZIP per operating system and processor architecture](#QTM-27.0-E003)
   - *Enhancement*
   - A capability that the new product offers from release 27.0.
4. [Several query tabs that run statements in parallel](#QTM-27.0-E006)
   - *Enhancement*
   - A capability that the new product offers from release 27.0.
5. [Run the selected text or the statement around the cursor](#QTM-27.0-E007)
   - *Enhancement*
   - A capability that the new product offers from release 27.0.
6. [Execute All runs every statement of the document in order](#QTM-27.0-E008)
   - *Enhancement*
   - A capability that the new product offers from release 27.0.
7. [Results grid with sorting and filters per column](#QTM-27.0-E015)
   - *Enhancement*
   - A capability that the new product offers from release 27.0.
8. [Export results to ten formats](#QTM-27.0-E019)
   - *Enhancement*
   - A capability that the new product offers from release 27.0.
9. [Log on window with databases in groups and a platform icon per database](#QTM-27.0-E021)
   - *Enhancement*
   - A capability that the new product offers from release 27.0.
10. [Licence window to register a key or request a free, trial or public data licence](#QTM-27.0-E026)
    - *Enhancement*
    - A capability that the new product offers from release 27.0.
11. [Available objects tree with tables, views, functions and PSQL packages](#QTM-27.0-E029)
    - *Enhancement*
    - A capability that the new product offers from release 27.0.
12. [macOS application bundle with icon, name in the menu bar and SQL file association](#QTM-27.0-E004)
    - *Enhancement*
    - A capability that the new product offers from release 27.0.
13. [Open SQL files from the menu, the command line or the file manager](#QTM-27.0-E005)
    - *Enhancement*
    - A capability that the new product offers from release 27.0.
14. [Running a script is a licensed function](#QTM-27.0-E009)
    - *Enhancement*
    - A capability that the new product offers from release 27.0.
15. [Local statements and scripting variables](#QTM-27.0-E010)
    - *Enhancement*
    - A capability that the new product offers from release 27.0.
16. [Syntax colouring that follows the words of the connected platform](#QTM-27.0-E012)
    - *Enhancement*
    - A capability that the new product offers from release 27.0.
17. [Progress bar with elapsed time, engine details and a stop button](#QTM-27.0-E014)
    - *Enhancement*
    - A capability that the new product offers from release 27.0.
18. [Group results by dragging a column header](#QTM-27.0-E016)
    - *Enhancement*
    - A capability that the new product offers from release 27.0.
19. [Totals per column: sum, average, count, minimum and maximum](#QTM-27.0-E017)
    - *Enhancement*
    - A capability that the new product offers from release 27.0.
20. [Copy or save the current view as CSV or to the clipboard](#QTM-27.0-E020)
    - *Enhancement*
    - A capability that the new product offers from release 27.0.
21. [Log on with stored or typed credentials and provider-specific settings](#QTM-27.0-E022)
    - *Enhancement*
    - A capability that the new product offers from release 27.0.
22. [Favourite and recently used databases shared with other Invantive products](#QTM-27.0-E023)
    - *Enhancement*
    - A capability that the new product offers from release 27.0.
23. [Discover the databases that are present on the device](#QTM-27.0-E025)
    - *Enhancement*
    - A capability that the new product offers from release 27.0.
24. [Licence key from the command line or an environment variable](#QTM-27.0-E027)
    - *Enhancement*
    - A capability that the new product offers from release 27.0.
25. [Native routines of a platform in the Objects tab](#QTM-27.0-E030)
    - *Enhancement*
    - A capability that the new product offers from release 27.0.

</div>

<a id="invantive-query-tool-multi-platform-new-in-27.0-new"></a>

### All Enhancements

Changes to behaviour, platforms, drivers and settings, grouped by area.

<div class="rn-filters">

Importance: [all](/en/release-notes/products?product=invantive-query-tool-multi-platform#invantive-query-tool-multi-platform-new-in-27.0-new) | [2 and higher](/en/release-notes/products?product=invantive-query-tool-multi-platform&importance=2#invantive-query-tool-multi-platform-new-in-27.0-new) | [3 and higher](/en/release-notes/products?product=invantive-query-tool-multi-platform&importance=3#invantive-query-tool-multi-platform-new-in-27.0-new) | [4 and higher](/en/release-notes/products?product=invantive-query-tool-multi-platform&importance=4#invantive-query-tool-multi-platform-new-in-27.0-new) | [5](/en/release-notes/products?product=invantive-query-tool-multi-platform&importance=5#invantive-query-tool-multi-platform-new-in-27.0-new)

</div>

<a id="invantive-query-tool-multi-platform-new-in-27.0-e-installation-and-platform"></a>

#### Installation and platform

<div class="rn-item" id="QTM-27.0-E003">

##### Self-contained ZIP per operating system and processor architecture

The product is delivered as one ZIP file for each of Windows x64, Linux x64, Linux ARM64, macOS x64 and macOS ARM64. The ZIP holds the application, the engine and the drivers, so nothing else has to be installed.

<div class="rn-action">

**What to Do**

Download the ZIP for the operating system and processor, extract it in a folder and start the Invantive.QueryTool programme from that folder.

</div>

<div class="rn-chips">

- importance 5

</div>

</div>

<div class="rn-item" id="QTM-27.0-E004">

##### macOS application bundle with icon, name in the menu bar and SQL file association

On macOS the product can be built as an application bundle for Apple silicon or Intel. The bundle shows the product icon and name and lets Finder open SQL files with the product. It declares macOS 13.0 as the minimum version.

<div class="rn-chips">

- importance 3

</div>

</div>

<div class="rn-item" id="QTM-27.0-E028">

##### Command line options with built-in usage text

The option help writes the usage and ends without starting the product or checking a licence. The options can be written as /name, -name or --name. Further options start the interface without the engine, switch off syntax colouring, report keyboard input on the status bar and mark a run as part of an AI agent.

<div class="rn-chips">

- importance 2

</div>

</div>

<a id="invantive-query-tool-multi-platform-new-in-27.0-e-licensing-and-sign-in"></a>

#### Licensing and sign-in

<div class="rn-item" id="QTM-27.0-E026">

##### Licence window to register a key or request a free, trial or public data licence

On the first start, or when the licence is not valid, a window opens. The user can paste a licence key, accept the licence agreement in English or Dutch, or request a free, trial or public data licence. The window states why it opened. The acceptance is remembered, so it is asked once per device.

<div class="rn-action">

**What to Do**

Register a licence on the first start.

</div>

<div class="rn-chips">

- importance 4

</div>

</div>

<div class="rn-item" id="QTM-27.0-E009">

##### Running a script is a licensed function

Execute All is refused when the licence does not cover running scripts or the function has not been granted to the user. The message names the function. Running a single statement needs no function in this product.

<div class="rn-action">

**What to Do**

Check that the licence and the user rights include the function for running scripts before using Execute All.

</div>

<div class="rn-chips">

- importance 3

</div>

</div>

<div class="rn-item" id="QTM-27.0-E022">

##### Log on with stored or typed credentials and provider-specific settings

The user name and password can be left empty to use the keychain or the settings file, or typed for one log on. Settings of the chosen platform are shown with a suitable control, such as a check box, a number box, a date picker or a list. A secret value is hidden.

<div class="rn-chips">

- importance 3

</div>

</div>

<div class="rn-item" id="QTM-27.0-E027">

##### Licence key from the command line or an environment variable

A licence key can be given with the licence key option or in the environment variable INVANTIVE_LICENSE_KEY. The option takes precedence. This allows registration without opening the licence window.

<div class="rn-chips">

- importance 3

</div>

</div>

<div class="rn-item" id="QTM-27.0-E024">

##### Automatic log on to the last database

An option in the log on window lets the product connect to the chosen database at the next start. The option is only offered when automatic log on is available and the user has the right to use it.

<div class="rn-chips">

- importance 2

</div>

</div>

<a id="invantive-query-tool-multi-platform-new-in-27.0-e-security"></a>

#### Security

<div class="rn-item" id="QTM-27.0-E041">

##### Reading and writing of script files and clipboard copies are registered

When a script file is opened or saved, the action is registered by the engine as a managed file action, including the size and a possible failure. Copying results to the clipboard goes through a guard that registers the action.

<div class="rn-chips">

- importance 2

</div>

</div>

<div class="rn-item" id="QTM-27.0-E042">

##### Marker on the log on window when the product runs within an AI agent

When the product is started in the context of an AI agent, the log on window shows a shield with the letters AI. The tooltip names the type of agent. The command line option for the agent marks a run for tests.

<div class="rn-chips">

- importance 2

</div>

</div>

<a id="invantive-query-tool-multi-platform-new-in-27.0-e-scripting"></a>

#### Scripting

<div class="rn-item" id="QTM-27.0-E007">

##### Run the selected text or the statement around the cursor

Execute runs the selected text. Without a selection it runs the statement around the cursor. Statements are separated by an empty line, a line with go or a line with a slash. A trailing semicolon is removed, but a semicolon never separates two statements.

<div class="rn-chips">

- importance 4

</div>

</div>

<div class="rn-item" id="QTM-27.0-E008">

##### Execute All runs every statement of the document in order

Execute All splits the document at the separating lines and runs the statements one after the other. It stops at the first statement that fails and reports the number of statements that ran.

<div class="rn-chips">

- importance 4

</div>

</div>

<div class="rn-item" id="QTM-27.0-E010">

##### Local statements and scripting variables

Statements that start with local, such as defining a variable or exporting the last result, are handled by the client. Expressions such as a variable in curly brackets are expanded before a statement goes to the engine. Some subscriptions do not permit local statements.

<div class="rn-chips">

- importance 3

</div>

</div>

<a id="invantive-query-tool-multi-platform-new-in-27.0-e-query-tool-user-interface"></a>

#### Query Tool user interface

<div class="rn-item" id="QTM-27.0-E001">

##### Interactive SQL editor on the UniversalSQL engine for Windows, Linux and macOS

The product offers one SQL editor with a results grid on all three operating systems. Statements are run by the UniversalSQL engine, so the same SQL works on every platform that the engine can reach.

<div class="rn-chips">

- importance 5

</div>

</div>

<div class="rn-item" id="QTM-27.0-E006">

##### Several query tabs that run statements in parallel

Each query tab has its own editor, results and messages. A tab runs one statement at a time, but different tabs can run at the same time. A tab with unsaved text is marked and cannot be closed while a statement is running.

<div class="rn-chips">

- importance 4

</div>

</div>

<div class="rn-item" id="QTM-27.0-E015">

##### Results grid with sorting and filters per column

Each column can be sorted. A column filter combines a condition (contains, equals, starts with, greater than, is empty and others) with a selection of distinct values. The value list offers at most 500 values.

<div class="rn-chips">

- importance 4

</div>

</div>

<div class="rn-item" id="QTM-27.0-E021">

##### Log on window with databases in groups and a platform icon per database

The log on window lists the licensed databases in groups, each with the icon of its platform. Choosing a database shows its description and the fields it needs. The window opens at start-up when there is no connection yet.

<div class="rn-chips">

- importance 4

</div>

</div>

<div class="rn-item" id="QTM-27.0-E029">

##### Available objects tree with tables, views, functions and PSQL packages

The Objects tab shows the tables, views and table functions of every schema of the connected database, and the PSQL packages, functions and procedures of the data dictionary. Selecting an object shows its description. Double-clicking inserts its name or a ready-to-run select statement, limited to at most 5000 rows where the engine evaluates the SQL.

<div class="rn-chips">

- importance 4

</div>

</div>

<div class="rn-item" id="QTM-27.0-E005">

##### Open SQL files from the menu, the command line or the file manager

SQL files (.sql, .isql and .txt) open in a query tab through File &gt; Open, through file names on the command line, or on macOS by double-clicking in Finder. Files are saved as UTF-8 without byte order mark.

<div class="rn-chips">

- importance 3

</div>

</div>

<div class="rn-item" id="QTM-27.0-E012">

##### Syntax colouring that follows the words of the connected platform

The editor colours keywords, functions and objects from the vocabulary of the session. This is UniversalSQL, or the SQL dialect of the platform on a connection that runs native SQL. The colours are the same as in the Windows product and also suit the dark appearance.

<div class="rn-chips">

- importance 3

</div>

</div>

<div class="rn-item" id="QTM-27.0-E014">

##### Progress bar with elapsed time, engine details and a stop button

While a statement runs, the tab shows the elapsed time and what the engine is doing. A stop button cancels the wait. The running statement is not interrupted on the platform; its result is ignored when it finishes.

<div class="rn-chips">

- importance 3

</div>

</div>

<div class="rn-item" id="QTM-27.0-E016">

##### Group results by dragging a column header

A column header can be dragged to the group bar above the grid, or grouped from the column menu. Several columns can be grouped and a grouping can be removed again.

<div class="rn-chips">

- importance 3

</div>

</div>

<div class="rn-item" id="QTM-27.0-E017">

##### Totals per column: sum, average, count, minimum and maximum

The column menu adds summaries to a column. They show in a total row and in the header of each group.

<div class="rn-chips">

- importance 3

</div>

</div>

<div class="rn-item" id="QTM-27.0-E023">

##### Favourite and recently used databases shared with other Invantive products

A star in front of a database pins it as a favourite. Favourites and recently used databases are shown first in the log on window. The lists are kept per user and are the same as in the other Invantive products. A favourite whose database no longer exists stays visible, greyed out, with the reason.

<div class="rn-chips">

- importance 3

</div>

</div>

<div class="rn-item" id="QTM-27.0-E033">

##### Menu bar on every operating system with Ctrl shortcuts outside macOS

On macOS the menu is shown in the menu bar of the screen. On Windows and Linux it is shown as a bar in the window, and the shortcuts use the Ctrl key. The menus are File, Edit, Selection, Query, Window and Help. The Help menu opens the documentation and the forums.

<div class="rn-chips">

- importance 3

</div>

</div>

<div class="rn-item" id="QTM-27.0-E036">

##### Engine questions and messages shown in windows instead of on the terminal

Questions from the engine (yes or no, yes, no, all or none, text input, choice from a list, XML correction) and error reports are shown as dialogs. The error window shows the message, the action to take and the object concerned in separate fields, with the message code and details.

<div class="rn-chips">

- importance 3

</div>

</div>

<div class="rn-item" id="QTM-27.0-E013">

##### Find, select current statement and the usual editing commands

The editor has line numbers, a search panel, undo, redo, cut, copy, paste and select all. A separate command selects the statement around the cursor.

<div class="rn-chips">

- importance 2

</div>

</div>

<div class="rn-item" id="QTM-27.0-E018">

##### Fixed columns, hiding of empty columns and refresh of the result

Columns can be pinned so that they stay visible while scrolling. A switch hides columns without any value. Refresh runs the last statement of the tab again.

<div class="rn-chips">

- importance 2

</div>

</div>

<div class="rn-item" id="QTM-27.0-E032">

##### Light and dark appearance follow the system

The product follows the light or dark setting of the operating system, also while it runs. The editor colouring changes with it.

<div class="rn-chips">

- importance 2

</div>

</div>

<div class="rn-item" id="QTM-27.0-E034">

##### Window position and size are remembered

The product opens on the screen, at the position and in the size that it had when it was closed. When that screen is gone, it falls back to a visible position.

<div class="rn-chips">

- importance 2

</div>

</div>

<div class="rn-item" id="QTM-27.0-E037">

##### Warning before unsaved SQL is lost

Closing a tab, closing the window or quitting the product asks for confirmation when a tab holds text that was not saved. Empty tabs do not count.

<div class="rn-chips">

- importance 2

</div>

</div>

<div class="rn-item" id="QTM-27.0-E043">

##### Names for screen readers on rows, buttons and fields

Rows of the database and objects trees, buttons that only show an icon, tabs and input fields carry a name that a screen reader can read out.

<div class="rn-chips">

- importance 2

</div>

</div>

<div class="rn-item" id="QTM-27.0-E045">

##### About window with product, edition, version and contact details

The About window shows the product name, the audience and edition of the licence, the version, the copyright and the contact details with links to the website, the sales e-mail address and the product forums.

<div class="rn-chips">

- importance 1

</div>

</div>

<a id="invantive-query-tool-multi-platform-new-in-27.0-e-platforms-and-drivers"></a>

#### Platforms and drivers

<div class="rn-item" id="QTM-27.0-E002">

##### Same engine, drivers and settings as the other Invantive products

The product contains the same UniversalSQL engine and drivers as the other Invantive products. It reads the databases from the shared settings files and the credentials from the shared keychain, so databases that are already known on the device can be used directly.

<div class="rn-chips">

- importance 5

</div>

</div>

<div class="rn-item" id="QTM-27.0-E025">

##### Discover the databases that are present on the device

The Discover Databases window asks all drivers which databases and services they find on the device. The results are grouped by platform and saved, so they appear in the log on window. The function needs the discovery right.

<div class="rn-chips">

- importance 3

</div>

</div>

<div class="rn-item" id="QTM-27.0-E030">

##### Native routines of a platform in the Objects tab

On a connection that sends SQL to the platform as typed, the Objects tab shows the packages, procedures and functions of that platform under their schema. Selecting one shows its parameters, and double-clicking inserts a call in the syntax of the platform. PSQL packages of the engine are not shown for such a connection.

<div class="rn-chips">

- importance 3

</div>

</div>

<a id="invantive-query-tool-multi-platform-new-in-27.0-e-export-and-import"></a>

#### Export and import

<div class="rn-item" id="QTM-27.0-E019">

##### Export results to ten formats

The Export menu writes the result of the last statement to Excel, CSV, TSV, text, XML, JSON, NDJSON and to SQL insert, select and create table statements. The statement is run again so that the file holds all rows, not only those on screen.

<div class="rn-chips">

- importance 4

</div>

</div>

<div class="rn-item" id="QTM-27.0-E020">

##### Copy or save the current view as CSV or to the clipboard

Two further export entries write the grid as it is shown, with the active filter, order and hidden columns. One saves a CSV file with semicolons as separator in UTF-8; the other puts tab-separated text on the clipboard.

<div class="rn-chips">

- importance 3

</div>

</div>

<a id="invantive-query-tool-multi-platform-new-in-27.0-e-logging-and-diagnostics"></a>

#### Logging and diagnostics

<div class="rn-item" id="QTM-27.0-E035">

##### Indicator and window for the activity on database and API connections

A coloured dot on the status bar shows how much of the recent time was spent waiting on a database or an API. A click opens a list of the calls with start time in UTC, duration, rows, round trips, cache use and address, with a search box and a detail window. The list can be saved as CSV or NDJSON. The dot stops moving while the interface is blocked.

<div class="rn-chips">

- importance 3

</div>

</div>

<div class="rn-item" id="QTM-27.0-E039">

##### Trace from the start with command line options

Options switch trace on, write it to a file and name the folder for the trace files, so that a problem during start-up is in the trace without setting environment variables first. The product writes trace entries with a message code and a logging level.

<div class="rn-chips">

- importance 3

</div>

</div>

<div class="rn-item" id="QTM-27.0-E011">

##### Execution profile of statements that are run

Every statement that is run, by hand or as part of Execute All, is registered as a run with statements. The durations can be read afterwards with SQL from the runs and statement executions of the script session.

<div class="rn-chips">

- importance 2

</div>

</div>

<div class="rn-item" id="QTM-27.0-E038">

##### Start-up problems are shown in a window

Problems that occur while the engine starts are collected and shown in the error window as soon as the main window is open. The product keeps running, so the cause can be read. A failure while reading the command line ends with exit code 6 and a message on the error output.

<div class="rn-chips">

- importance 2

</div>

</div>

<a id="invantive-query-tool-multi-platform-new-in-27.0-e-translations-and-texts"></a>

#### Translations and texts

<div class="rn-item" id="QTM-27.0-E031">

##### Interface language can be changed from the Window menu

The language of the interface is chosen in a submenu of the Window menu, which lists the languages that the licence allows. The choice is shared with the other Invantive products on the device. A number of short texts still appear in Dutch whatever language is chosen.

<div class="rn-chips">

- importance 3

</div>

</div>

<a id="invantive-query-tool-multi-platform-new-in-27.0-e-documentation"></a>

#### Documentation

<div class="rn-item" id="QTM-27.0-E044">

##### Customer documentation and links to documentation and forums

The product has a documentation section of thirteen pages with the topics installation, licence, log on, discovery, statements, objects, results, export, language, command line options and limitations. The Help menu opens the online documentation and the forums.

<div class="rn-chips">

- importance 2

</div>

</div>

<a id="invantive-query-tool-multi-platform-new-in-27.0-e-other"></a>

#### Other

<div class="rn-item" id="QTM-27.0-E040">

##### Orderly shutdown on log off, termination signals and normal closing

When the window is closed, or the system sends a termination signal, the product stops running work, finishes the registration of the run and ends. This prevents statements that stay in the execution profile as never ended.

<div class="rn-chips">

- importance 2

</div>

</div>

<a id="invantive-query-tool-multi-platform-new-in-27.0-fixed"></a>

### All Bug Fixes

Defects of the older release that are repaired.

None.

### Announced, Not Yet Available

- Seven windows are stubs that report 'not available in this version': diagnostics, keychain, data replicator, help for local statements, feedback, stay informed and preferences.
- The Objects tab stops at the table or view; the columns of an object are not shown.
- Double-clicking a PSQL package function, a function or procedure of the data dictionary or a data dictionary view in the Objects tab inserts nothing.
- Names of tables and columns are not completed while typing.
- Cancelling a statement does not interrupt it on the platform; only the result is discarded.
- There is no log off: a database stays connected until the window is closed.
- A value that holds a document or image is shown as \[BLOB\] and cannot be opened or saved from the grid.
- Refresh and the export menu report that there is nothing to work with after Execute All, because no single statement is remembered.
- Export to PDF, Word, XPS, HTML and RTF, and printing, are not offered; the README also lists charts and dashboards as absent.
- The load graph and the overlay of the activity indicator are not implemented; the dot stops while the interface thread is blocked.
- Pre-emptive loading of metadata after the object list has loaded is only a design (NEXT_STEPS item 15) and has no code in the repository.
- The discovery window shows grouped tiles only; the per-driver rows with help links and action buttons of the Windows window are not built.
- The macOS bundle is signed ad hoc only; Developer ID signing and notarisation are left to the release build.
- Running a single statement, or a selected document with Execute, is not checked against a licensed function; only Execute All is.
- The menu bar on Linux and the menu captions on macOS were not verified after the menu rewrite; only Windows was verified.
- Some texts are still hard-coded Dutch, among them the filter operators and summary names of the column menu, the status texts for preparing, executing and cancelling, and the keyboard diagnosis texts.
- No installer script or package-manager package (MSI, Chocolatey, NuGet) for this product was found in the repository, although product-orig.json names package identifiers; delivery is by ZIP.

### Differences from Windows Edition

- The Windows Query Tool exports results to Adobe PDF, Microsoft Word, XPS, HTML, RTF and JSON data set as well; this product offers ten engine formats and no document formats or printing.
- The Windows Query Tool has a preferences window and a keychain window; here both only report that the window is not available.
- The Windows Query Tool has a diagnostics window and data replicator windows; here the diagnostics and data replicator entries only report that the window is not available.
- The Windows Query Tool completes keywords while typing in its SQL editor; this product only colours the SQL.
- The Windows products show a load graph of the connection activity next to the dot; this product has the dot and the list of calls only.
- The Windows Query Tool uses the complete Invantive Producer interface on Windows only; this product has a smaller interface and one window layout for all three operating systems.

<a id="invantive-query-tool-multi-platform-new-in-27.0-builds"></a>

### What It Builds On

| Kind | Name | From | To |
|---|---|---|---|
| invantive component | Invantive Query Tool Multi-Platform |  | 27.0.54 |
| invantive component | Invantive(R) Basics |  | 27.0.93 |
| invantive component | Invantive(R) Producer GUI Base |  | 27.0.93 |
| invantive component | Invantive(R) Producer Data Model |  | 27.0.93 |
| invantive component | Invantive(R) SQL for Core |  | 27.0.93 |
| invantive component | Invantive(R) SQL |  | 27.0.93 |
| invantive component | Invantive(R) SQL for Windows |  | 27.0.93 |
| build tool | Invantive Deploy |  | 27.0.93 |
| third party summary |  |  |  |

<a id="invantive-query-tool-multi-platform-new-in-27.0-more"></a>

### More Information

- [Product manual](https://go.invantive.com/doc/invantive-query-tool)
- [Product documentation](https://documentation.invantive.com/)
- [Questions and answers on the forum](https://forums.invantive.com/tag/invantive-query-tool)
- [Downloads](https://go.invantive.com/download/)
- [All release notes](https://go.invantive.com/releasenotes/)

### How This Note Was Made

<div class="rn-small">

- Not verified by a second reading: the capabilities come from one reading of the documents and source.
- The product did not exist in the previous release, so there is no range of commits to compare.
- The capabilities were read from the documents and the source of the newer state by one reader; each item names no commits.
- Items that are designed but not built at the newer state are not listed; they are recorded as not yet available.

</div>

</div>

</div>

</div>

