---
title: "Release-opmerkingen van Invantive Query Tool for Windows"
description: "De verbeteringen en bugfixes van de Invantive-producten per release, en wat u moet controleren voordat u een upgrade uitvoert."
language: nl
canonical: https://documentation.invantive.eu/nl/release-notes/products/invantive-query-tool?importance=3
---

# Release-opmerkingen van Invantive Query Tool for Windows

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

**Releases:** [26.0 tot 27.0](/nl/release-notes/products/invantive-query-tool.md?step=26.0-to-27.0&importance=3) | [nieuw in 27.0](/nl/release-notes/products/invantive-query-tool.md?step=new-in-27.0&importance=3) | [25.0 tot 26.0](/nl/release-notes/products/invantive-query-tool.md?step=25.0-to-26.0&importance=3)

<div class="rn-block" id="invantive-query-tool-26.0-to-27.0">

<div class="rn-head">

Release Note - Installatieprogramma

## Invantive Query Tool for Windows 27.0, van 26.0

| Bouwen | Datum | Omschrijving | Platform |
|---|---|---|---|
| `26.0.4` | 22-03-2026 | first build of release 26.0 | 64-bit Windows; .NET 10 |
| `27.0.92` | 09-11-2026 | latest build of release 27.0 at the time of writing | 64-bit Windows 10 version 1809 or later; .NET 10 |

The older state is the first build of release 26.0, not its last: later builds of 26.0 received ports of changes made for 27.0, so those changes are part of this step. The 27.0 line also contains the beta builds 26.1.x.

- **203** verbeteringen
- **177** foutcorrecties
- **14** wat je moet controleren voordat je een upgrade uitvoert

</div>

<div class="rn-layout">

<div class="rn-index">

**Deze opmerking**

- [Voordat u de upgrade uitvoert](#invantive-query-tool-26.0-to-27.0-before)
- [Top 25 wijzigingen](#invantive-query-tool-26.0-to-27.0-top)
- [Alle Verbeteringen](#invantive-query-tool-26.0-to-27.0-new) 102
- [Alle Bugfixes](#invantive-query-tool-26.0-to-27.0-fixed) 45
- [Waarop het Voortbouwt](#invantive-query-tool-26.0-to-27.0-builds)
- [Meer Informatie](#invantive-query-tool-26.0-to-27.0-more)

**Verbeteringen**

- [Installation and platform](#invantive-query-tool-26.0-to-27.0-e-installation-and-platform) 4
- [Licensing and sign-in](#invantive-query-tool-26.0-to-27.0-e-licensing-and-sign-in) 9
- [Security](#invantive-query-tool-26.0-to-27.0-e-security) 3
- [SQL engine](#invantive-query-tool-26.0-to-27.0-e-sql-engine) 13
- [Scripting](#invantive-query-tool-26.0-to-27.0-e-scripting) 7
- [Query Tool user interface](#invantive-query-tool-26.0-to-27.0-e-query-tool-user-interface) 19
- [Platforms and drivers](#invantive-query-tool-26.0-to-27.0-e-platforms-and-drivers) 33
- [Export and import](#invantive-query-tool-26.0-to-27.0-e-export-and-import) 2
- [Performance](#invantive-query-tool-26.0-to-27.0-e-performance) 11
- [Documentation](#invantive-query-tool-26.0-to-27.0-e-documentation) 1

**Foutcorrecties**

- [Licensing and sign-in](#invantive-query-tool-26.0-to-27.0-b-licensing-and-sign-in) 3
- [Security](#invantive-query-tool-26.0-to-27.0-b-security) 1
- [SQL engine](#invantive-query-tool-26.0-to-27.0-b-sql-engine) 14
- [Scripting](#invantive-query-tool-26.0-to-27.0-b-scripting) 1
- [Query Tool user interface](#invantive-query-tool-26.0-to-27.0-b-query-tool-user-interface) 8
- [Platforms and drivers](#invantive-query-tool-26.0-to-27.0-b-platforms-and-drivers) 15
- [Export and import](#invantive-query-tool-26.0-to-27.0-b-export-and-import) 3

</div>

<div class="rn-main">

<div class="rn-before" id="invantive-query-tool-26.0-to-27.0-before">

### Voordat u de upgrade uitvoert

Deze wijzigingen moeten worden gecontroleerd:

- [Settings files move from XML to JSON](#QTL-27.0-E001)
  - Settings files are converted from XML to JSON when they are read. From 27.0 the JSON file takes precedence and the XML file is removed in release 28.0: edit the JSON file from now on and keep a copy of the XML file until then.
- [UTF-8 files are written without a byte order mark by default](#QTL-27.0-E094)
  - Check programs that read exported text files and expect a byte order mark.
- [The legacy Oracle driver and the Invantive Web Service driver are removed; Oracle 18 is the minimum](#QTL-27.0-E020)
  - Check connections to Oracle databases older than version 18, and connections that name the legacy Oracle driver or the Invantive Web Service driver: they no longer work.
- [Exact Online companies outside the service area are no longer accepted](#QTL-27.0-E008)
  - Companies in countries outside the service area are no longer available in Exact Online.
- [Remove obsolete Invantive Script statements](#QTL-27.0-E014)
  - Remove the statements for encrypting passwords and variables, deploying static files and showing the keychain from scripts; they are no longer recognised.
- [Remove the compression level option from loading results from the clipboard](/nl/release-notes/products/invantive-query-tool#QTL-27.0-E128)
  - Remove the compression level clause from statements that load a results clipboard.
- [QR code functions take one size value instead of width and height](#QTL-27.0-E012)
  - Adjust statements that call the QR code functions with a separate width and height.
- [Integer constants in SQL keep an integer type](#QTL-27.0-E049)
  - Check expressions that rely on whole numbers being decimal; the data type of the result can differ.
- [Gripp CRM tables now have a schema name](#QTL-27.0-E065)
  - Adjust statements that use the old table names of Gripp CRM; the tables now have a schema name.
- [Row count variable is empty before the first statement](/nl/release-notes/products/invantive-query-tool#QTL-27.0-E129)
  - Check scripts that compare the row count of the previous statement with zero before the first statement.
- [Duration columns in system views have a decimal type and more precise values](/nl/release-notes/products/invantive-query-tool#QTL-27.0-E120)
  - Check queries that expect whole numbers in the duration columns of the session and execution views.
- [Remove the LinkedIn and Loket.nl SOAP drivers and the Dynamics CRM table list](#QTL-27.0-E019)
  - Statements on the LinkedIn driver and the SOAP-based Loket.nl driver no longer work.
- [Loading of provider assemblies from a settings file is blocked](#QTL-27.0-E011)
  - A provider loaded from an assembly named in a settings file now fails; no file is on the allowed list yet.
- [Data Cache no longer runs forced garbage collection; three settings removed](#QTL-27.0-E096)
  - Remove the three garbage-collection settings of the Data Cache driver from settings files.

</div>

<a id="invantive-query-tool-26.0-to-27.0-top"></a>

### Top 25 wijzigingen

<div class="rn-top">

1. [The Progress panel replaces Explain Plan and shows live how a statement runs](#QTL-27.0-E005)
   - *Verbetering*
   - A statement is drawn while it runs: a card per step and platform, the rows flowing between steps, time, calls and bytes, live figures within a running step and an estimate of the time left. Reads over many files, bulk inserts, internet crawls and streaming reads report their progress, and the tab of a document shows a turning ring while its statement runs.
2. [Settings files move from XML to JSON](#QTL-27.0-E001)
   - *Verbetering*
   - **actie nodig**
   - Action needed before or after the upgrade.
3. [More work is sent to the platform: row limit, grouping, selected columns and joins](#QTL-27.0-E006)
   - *Verbetering*
   - A query with LIMIT or TOP is limited by the platform, COUNT, SUM and other group functions are answered by the platform on supported drivers, only the columns that a query needs are requested, join conditions are forwarded, an exists condition on a child table reaches the platform, and OData platforms get shorter filters with the IN operator. Fewer rows are transferred.
4. [Parts of a PSQL block can run in parallel](#QTL-27.0-E003)
   - *Verbetering*
   - PSQL gets a PARALLEL construct that runs branches and loop iterations side by side, SYNCHRONIZE accepts a parallel option, and the package dbms_atomic holds values that parallel branches share safely.
5. [Correlated subqueries are supported](#QTL-27.0-E002)
   - *Verbetering*
   - A subquery can refer to columns of the outer query, as in EXISTS, IN and scalar subqueries. A subquery without outer references is evaluated once per statement and its answer is reused.
6. [A dark appearance that follows the Windows app theme](#QTL-27.0-E022)
   - *Verbetering*
   - The windows, the SQL editor, grids, ribbon, dialogs, scroll bars and tool windows follow the dark appearance when Windows is set to dark mode, including the windows for plug-ins, parameters and running a script.
7. [The Connection Monitor shows the calls of the application to databases and platforms](#QTL-27.0-E028)
   - *Verbetering*
   - A dot shows whether the application talks to a database or platform. It opens a window with the calls, their moment in UTC, duration, rows, bytes and the action, with a load graph; running calls show the time and rows so far.
8. [Joins return the correct rows](#QTL-27.0-B001)
   - *Foutcorrectie*
   - A left, right or full join written without the word OUTER was executed as an inner join and lost rows. A right outer join placed columns in the wrong order, a condition in ON removed rows, a cross join dropped its right-hand side, and a full outer join that could not be answered was not reported.
9. [Data containers and credentials from Invantive Credentials Server](#QTL-27.0-E007)
   - *Verbetering*
   - A database definition can point to Invantive Credentials Server, which supplies the data containers and sign-in credentials. The log-on window and the partition menu show these containers with their own icon, errors of the server are shown with their details, and a retrieval is repeated after a time-out.
10. [Scripts can run operating system commands with the new package dbms_os](#QTL-27.0-E015)
    - *Verbetering*
    - The package dbms_os runs an operating system command with environment variables and a time limit, returns its output and exit code, and calculates a file hash. A command that runs too long is ended together with the programs it started. Files it writes are UTF-8 without byte order mark.
11. [Data is loaded in the background while a session is idle](#QTL-27.0-E030)
    - *Verbetering*
    - A connected session fills caches with predictable data, such as the tables read in the last fourteen days and the incremental tables of Exact Online, Freshdesk and Freshservice, using spare rate allowance. Four loads run in parallel, partitions can be chosen, and the connection monitor shows the loads.
12. [The legacy Oracle driver and the Invantive Web Service driver are removed; Oracle 18 is the minimum](#QTL-27.0-E020)
    - *Verbetering*
    - **actie nodig**
    - Action needed before or after the upgrade.
13. [Filters no longer lose rows or evaluate wrongly](#QTL-27.0-B003)
    - *Foutcorrectie*
    - A condition such as a and (b or c) could return too few rows, lower and upper case conversions and decimal constants were not sent correctly to SQL databases, NOT LIKE dropped rows that differ only in case, and x between 1 and 2 and y = 1 was read wrongly.
14. [Results of every platform are read while scrolling, ahead of the view](#QTL-27.0-E027)
    - *Verbetering*
    - The results grid shows the first rows quickly and reads further rows in the background as the grid is scrolled, for every platform and not only for Oracle and MySQL. A statement with a trailing line comment on Oracle no longer fails.
15. [Loading of provider assemblies from a settings file is blocked](#QTL-27.0-E011)
    - *Verbetering*
    - **actie nodig**
    - Action needed before or after the upgrade.
16. [Add, edit, test and delete database definitions in the Discover Databases window](#QTL-27.0-E023)
    - *Verbetering*
    - The Discover Databases window can add, edit, duplicate, test and delete a database definition on the screen. Settings files are validated and saved without losing members, and the editor has rights for deleting a database and managing settings files.
17. [Invantive License Service: clearer messages, grace period and new modules](#QTL-27.0-E009)
    - *Verbetering*
    - A licence key of the wrong type is explained, a licence service that is unavailable gets a specific message, and a licence that was valid stays in force for a grace period when the service cannot be reached. The check that prolongs a licence runs hourly. New licence modules exist for the Support Assistant, OEM use and subscription software, the built-in trial and open data keys use the new format, and text-mode products show tips about the licence in use.
18. [New platforms: Inspectlet, Matomo, Nextcloud and Tweede Kamer v5](#QTL-27.0-E017)
    - *Verbetering*
    - Four new drivers read Inspectlet (websites and recorded sessions), Matomo web analytics with a package of PSQL procedures, a Nextcloud server (tables depend on the installed apps) and the Tweede Kamer open data on the new API. The earlier Tweede Kamer driver remains available. Each platform has a licence module and an icon.
19. [DeepL driver](#QTL-27.0-E004)
    - *Verbetering*
    - A new driver reads and writes DeepL: languages, billing, translation, writing assistance, documents, glossaries, style rules and translation memories.
20. [Visma.net: new API specification, Visma Connect log-on and the Sales Order APIs](#QTL-27.0-E021)
    - *Verbetering*
    - The Visma.net driver uses the API specification of 18 June 2026 and the new Visma Connect sign-in, and adds tables for the Sales Order APIs with server-side filtering, insert and update. Filters such as not in and not equal on a column with a fixed list of values are sent as requests for the remaining values.
21. [Exact Online incremental tables reload less often and are read faster](#QTL-27.0-E031)
    - *Verbetering*
    - Incremental tables avoid full reloads caused by a rejected previous image or a row count guard, are read from the cache up to six times faster, and stop an incremental run when the deleted rows needed are older than the platform keeps them. The new table IncrementalEntityTypes lists the entity types that can be loaded incrementally.
22. [Big Data JSON reads files much faster and skips files that cannot match](#QTL-27.0-E029)
    - *Verbetering*
    - Collections of NDJSON files, plain or Zstandard compressed, are streamed and only the needed columns are built. A directory gets an index with value ranges, Bloom filters and counts, so filters, counts and group-by statements read fewer files.
23. [Long operations can be cancelled and react quickly](#QTL-27.0-E026)
    - *Verbetering*
    - A stop button ends a Data Loader run and operations such as synchronize and loops of a script, and the stop window names the operation and its progress. Cancelling also stops slow web requests, waits between retries and compression, and closing the application ends its work within a set time.
24. [A script can query its own execution profile](#QTL-27.0-E053)
    - *Verbetering*
    - Runs of Invantive Script, their statements, started operating system commands, variables and exit codes are registered and can be queried with plain SQL through the new data container Script. The name of the profile log can be chosen, and statements register the memory they allocated.
25. [Available Objects handles tens of thousands of objects and lists native packages](#QTL-27.0-E024)
    - *Verbetering*
    - The tree builds and refreshes faster with 30,000 or more objects, shows details of the selected data container beside it, an overlay names the step while it is filled, and a connection that sends statements natively to Oracle, MySQL, PostgreSQL or SQL Server lists the stored packages, procedures and functions, which Describe shows with their parameters.

</div>

<a id="invantive-query-tool-26.0-to-27.0-new"></a>

### Alle Verbeteringen

Wijzigingen in gedrag, platforms, Drivers en instellingen, gegroepeerd per gebied.

<div class="rn-filters">

Belang: [alle](/nl/release-notes/products/invantive-query-tool#invantive-query-tool-26.0-to-27.0-new) | [2 en hoger](/nl/release-notes/products/invantive-query-tool?importance=2#invantive-query-tool-26.0-to-27.0-new) | [3 en hoger](/nl/release-notes/products/invantive-query-tool?importance=3#invantive-query-tool-26.0-to-27.0-new) | [4 en hoger](/nl/release-notes/products/invantive-query-tool?importance=4#invantive-query-tool-26.0-to-27.0-new) | [5](/nl/release-notes/products/invantive-query-tool?importance=5#invantive-query-tool-26.0-to-27.0-new)

Platform: [alle](/nl/release-notes/products/invantive-query-tool?importance=3#invantive-query-tool-26.0-to-27.0-new) | [AccountView](/nl/release-notes/products/invantive-query-tool?platform=AccountView&importance=3#invantive-query-tool-26.0-to-27.0-new) (1) | [ActiveCampaign](/nl/release-notes/products/invantive-query-tool?platform=ActiveCampaign&importance=3#invantive-query-tool-26.0-to-27.0-new) (3) | [AFAS](/nl/release-notes/products/invantive-query-tool?platform=AFAS&importance=3#invantive-query-tool-26.0-to-27.0-new) (1) | [AFAS Online](/nl/release-notes/products/invantive-query-tool?platform=AFAS%20Online&importance=3#invantive-query-tool-26.0-to-27.0-new) (3) | [AFAS Profit](/nl/release-notes/products/invantive-query-tool?platform=AFAS%20Profit&importance=3#invantive-query-tool-26.0-to-27.0-new) (1) | [Autotask](/nl/release-notes/products/invantive-query-tool?platform=Autotask&importance=3#invantive-query-tool-26.0-to-27.0-new) (1) | [Big Data JSON](/nl/release-notes/products/invantive-query-tool?platform=Big%20Data%20JSON&importance=3#invantive-query-tool-26.0-to-27.0-new) (2) | [Brevo](/nl/release-notes/products/invantive-query-tool?platform=Brevo&importance=3#invantive-query-tool-26.0-to-27.0-new) (2) | [Bridge Online](/nl/release-notes/products/invantive-query-tool?platform=Bridge%20Online&importance=3#invantive-query-tool-26.0-to-27.0-new) (4) | [CBS](/nl/release-notes/products/invantive-query-tool?platform=CBS&importance=3#invantive-query-tool-26.0-to-27.0-new) (1) | [Chargebee](/nl/release-notes/products/invantive-query-tool?platform=Chargebee&importance=3#invantive-query-tool-26.0-to-27.0-new) (1) | [Crisp](/nl/release-notes/products/invantive-query-tool?platform=Crisp&importance=3#invantive-query-tool-26.0-to-27.0-new) (4) | [Data Cache](/nl/release-notes/products/invantive-query-tool?platform=Data%20Cache&importance=3#invantive-query-tool-26.0-to-27.0-new) (1) | [DeepL](/nl/release-notes/products/invantive-query-tool?platform=DeepL&importance=3#invantive-query-tool-26.0-to-27.0-new) (1) | [Discourse](/nl/release-notes/products/invantive-query-tool?platform=Discourse&importance=3#invantive-query-tool-26.0-to-27.0-new) (1) | [Dropbox](/nl/release-notes/products/invantive-query-tool?platform=Dropbox&importance=3#invantive-query-tool-26.0-to-27.0-new) (1) | [Dynamics 365 CRM](/nl/release-notes/products/invantive-query-tool?platform=Dynamics%20365%20CRM&importance=3#invantive-query-tool-26.0-to-27.0-new) (2) | [Dynamics CRM](/nl/release-notes/products/invantive-query-tool?platform=Dynamics%20CRM&importance=3#invantive-query-tool-26.0-to-27.0-new) (2) | [Easyflex](/nl/release-notes/products/invantive-query-tool?platform=Easyflex&importance=3#invantive-query-tool-26.0-to-27.0-new) (1) | [EDIFACT](/nl/release-notes/products/invantive-query-tool?platform=EDIFACT&importance=3#invantive-query-tool-26.0-to-27.0-new) (1) | [Exact Online](/nl/release-notes/products/invantive-query-tool?platform=Exact%20Online&importance=3#invantive-query-tool-26.0-to-27.0-new) (37) | [File system](/nl/release-notes/products/invantive-query-tool?platform=File%20system&importance=3#invantive-query-tool-26.0-to-27.0-new) (2) | [Firebird](/nl/release-notes/products/invantive-query-tool?platform=Firebird&importance=3#invantive-query-tool-26.0-to-27.0-new) (2) | [Fortnox](/nl/release-notes/products/invantive-query-tool?platform=Fortnox&importance=3#invantive-query-tool-26.0-to-27.0-new) (1) | [FoxPro](/nl/release-notes/products/invantive-query-tool?platform=FoxPro&importance=3#invantive-query-tool-26.0-to-27.0-new) (1) | [Freshdesk](/nl/release-notes/products/invantive-query-tool?platform=Freshdesk&importance=3#invantive-query-tool-26.0-to-27.0-new) (3) | [Freshservice](/nl/release-notes/products/invantive-query-tool?platform=Freshservice&importance=3#invantive-query-tool-26.0-to-27.0-new) (2) | [FTP](/nl/release-notes/products/invantive-query-tool?platform=FTP&importance=3#invantive-query-tool-26.0-to-27.0-new) (1) | [Gripp](/nl/release-notes/products/invantive-query-tool?platform=Gripp&importance=3#invantive-query-tool-26.0-to-27.0-new) (2) | [Gripp CRM](/nl/release-notes/products/invantive-query-tool?platform=Gripp%20CRM&importance=3#invantive-query-tool-26.0-to-27.0-new) (2) | [HubSpot](/nl/release-notes/products/invantive-query-tool?platform=HubSpot&importance=3#invantive-query-tool-26.0-to-27.0-new) (3) | [IBM Db2](/nl/release-notes/products/invantive-query-tool?platform=IBM%20Db2&importance=3#invantive-query-tool-26.0-to-27.0-new) (1) | [In-memory](/nl/release-notes/products/invantive-query-tool?platform=In-memory&importance=3#invantive-query-tool-26.0-to-27.0-new) (2) | [In-memory storage](/nl/release-notes/products/invantive-query-tool?platform=In-memory%20storage&importance=3#invantive-query-tool-26.0-to-27.0-new) (2) | [Inspectlet](/nl/release-notes/products/invantive-query-tool?platform=Inspectlet&importance=3#invantive-query-tool-26.0-to-27.0-new) (2) | [Invantive Bridge Online](/nl/release-notes/products/invantive-query-tool?platform=Invantive%20Bridge%20Online&importance=3#invantive-query-tool-26.0-to-27.0-new) (1) | [Invantive Business](/nl/release-notes/products/invantive-query-tool?platform=Invantive%20Business&importance=3#invantive-query-tool-26.0-to-27.0-new) (2) | [Invantive Credentials Server](/nl/release-notes/products/invantive-query-tool?platform=Invantive%20Credentials%20Server&importance=3#invantive-query-tool-26.0-to-27.0-new) (1) | [Invantive Estate](/nl/release-notes/products/invantive-query-tool?platform=Invantive%20Estate&importance=3#invantive-query-tool-26.0-to-27.0-new) (1) | [Invantive Web Service](/nl/release-notes/products/invantive-query-tool?platform=Invantive%20Web%20Service&importance=3#invantive-query-tool-26.0-to-27.0-new) (1) | [ionBIZ](/nl/release-notes/products/invantive-query-tool?platform=ionBIZ&importance=3#invantive-query-tool-26.0-to-27.0-new) (1) | [Kadaster](/nl/release-notes/products/invantive-query-tool?platform=Kadaster&importance=3#invantive-query-tool-26.0-to-27.0-new) (1) | [LinkedIn](/nl/release-notes/products/invantive-query-tool?platform=LinkedIn&importance=3#invantive-query-tool-26.0-to-27.0-new) (1) | [Logius COR](/nl/release-notes/products/invantive-query-tool?platform=Logius%20COR&importance=3#invantive-query-tool-26.0-to-27.0-new) (1) | [Loket](/nl/release-notes/products/invantive-query-tool?platform=Loket&importance=3#invantive-query-tool-26.0-to-27.0-new) (1) | [Loket.nl](/nl/release-notes/products/invantive-query-tool?platform=Loket.nl&importance=3#invantive-query-tool-26.0-to-27.0-new) (2) | [Magento](/nl/release-notes/products/invantive-query-tool?platform=Magento&importance=3#invantive-query-tool-26.0-to-27.0-new) (4) | [MariaDB](/nl/release-notes/products/invantive-query-tool?platform=MariaDB&importance=3#invantive-query-tool-26.0-to-27.0-new) (1) | [Matomo](/nl/release-notes/products/invantive-query-tool?platform=Matomo&importance=3#invantive-query-tool-26.0-to-27.0-new) (2) | [Mendix](/nl/release-notes/products/invantive-query-tool?platform=Mendix&importance=3#invantive-query-tool-26.0-to-27.0-new) (1) | [Microsoft Access](/nl/release-notes/products/invantive-query-tool?platform=Microsoft%20Access&importance=3#invantive-query-tool-26.0-to-27.0-new) (1) | [Microsoft Dynamics CRM](/nl/release-notes/products/invantive-query-tool?platform=Microsoft%20Dynamics%20CRM&importance=3#invantive-query-tool-26.0-to-27.0-new) (1) | [Microsoft Graph](/nl/release-notes/products/invantive-query-tool?platform=Microsoft%20Graph&importance=3#invantive-query-tool-26.0-to-27.0-new) (1) | [MySQL](/nl/release-notes/products/invantive-query-tool?platform=MySQL&importance=3#invantive-query-tool-26.0-to-27.0-new) (11) | [Nextcloud](/nl/release-notes/products/invantive-query-tool?platform=Nextcloud&importance=3#invantive-query-tool-26.0-to-27.0-new) (1) | [Nmbrs](/nl/release-notes/products/invantive-query-tool?platform=Nmbrs&importance=3#invantive-query-tool-26.0-to-27.0-new) (2) | [OData](/nl/release-notes/products/invantive-query-tool?platform=OData&importance=3#invantive-query-tool-26.0-to-27.0-new) (1) | [ODBC](/nl/release-notes/products/invantive-query-tool?platform=ODBC&importance=3#invantive-query-tool-26.0-to-27.0-new) (3) | [Odoo](/nl/release-notes/products/invantive-query-tool?platform=Odoo&importance=3#invantive-query-tool-26.0-to-27.0-new) (4) | [Open Archives](/nl/release-notes/products/invantive-query-tool?platform=Open%20Archives&importance=3#invantive-query-tool-26.0-to-27.0-new) (2) | [Open Besluitvorming](/nl/release-notes/products/invantive-query-tool?platform=Open%20Besluitvorming&importance=3#invantive-query-tool-26.0-to-27.0-new) (1) | [Oracle](/nl/release-notes/products/invantive-query-tool?platform=Oracle&importance=3#invantive-query-tool-26.0-to-27.0-new) (22) | [Ossus](/nl/release-notes/products/invantive-query-tool?platform=Ossus&importance=3#invantive-query-tool-26.0-to-27.0-new) (1) | [PayPal](/nl/release-notes/products/invantive-query-tool?platform=PayPal&importance=3#invantive-query-tool-26.0-to-27.0-new) (2) | [Pipedrive](/nl/release-notes/products/invantive-query-tool?platform=Pipedrive&importance=3#invantive-query-tool-26.0-to-27.0-new) (1) | [PostgreSQL](/nl/release-notes/products/invantive-query-tool?platform=PostgreSQL&importance=3#invantive-query-tool-26.0-to-27.0-new) (16) | [Rabobank MT940](/nl/release-notes/products/invantive-query-tool?platform=Rabobank%20MT940&importance=3#invantive-query-tool-26.0-to-27.0-new) (1) | [RDW](/nl/release-notes/products/invantive-query-tool?platform=RDW&importance=3#invantive-query-tool-26.0-to-27.0-new) (2) | [Robaws](/nl/release-notes/products/invantive-query-tool?platform=Robaws&importance=3#invantive-query-tool-26.0-to-27.0-new) (3) | [Salesforce](/nl/release-notes/products/invantive-query-tool?platform=Salesforce&importance=3#invantive-query-tool-26.0-to-27.0-new) (1) | [SFTP](/nl/release-notes/products/invantive-query-tool?platform=SFTP&importance=3#invantive-query-tool-26.0-to-27.0-new) (1) | [Slack](/nl/release-notes/products/invantive-query-tool?platform=Slack&importance=3#invantive-query-tool-26.0-to-27.0-new) (1) | [SnelStart](/nl/release-notes/products/invantive-query-tool?platform=SnelStart&importance=3#invantive-query-tool-26.0-to-27.0-new) (5) | [SQL Server](/nl/release-notes/products/invantive-query-tool?platform=SQL%20Server&importance=3#invantive-query-tool-26.0-to-27.0-new) (16) | [StackExchange](/nl/release-notes/products/invantive-query-tool?platform=StackExchange&importance=3#invantive-query-tool-26.0-to-27.0-new) (1) | [Stripo](/nl/release-notes/products/invantive-query-tool?platform=Stripo&importance=3#invantive-query-tool-26.0-to-27.0-new) (2) | [Stripo Email](/nl/release-notes/products/invantive-query-tool?platform=Stripo%20Email&importance=3#invantive-query-tool-26.0-to-27.0-new) (1) | [Teamleader](/nl/release-notes/products/invantive-query-tool?platform=Teamleader&importance=3#invantive-query-tool-26.0-to-27.0-new) (1) | [Teamleader Focus](/nl/release-notes/products/invantive-query-tool?platform=Teamleader%20Focus&importance=3#invantive-query-tool-26.0-to-27.0-new) (2) | [TeamViewer](/nl/release-notes/products/invantive-query-tool?platform=TeamViewer&importance=3#invantive-query-tool-26.0-to-27.0-new) (1) | [Teradata](/nl/release-notes/products/invantive-query-tool?platform=Teradata&importance=3#invantive-query-tool-26.0-to-27.0-new) (1) | [Tixly](/nl/release-notes/products/invantive-query-tool?platform=Tixly&importance=3#invantive-query-tool-26.0-to-27.0-new) (1) | [Tweede Kamer](/nl/release-notes/products/invantive-query-tool?platform=Tweede%20Kamer&importance=3#invantive-query-tool-26.0-to-27.0-new) (2) | [Twinfield](/nl/release-notes/products/invantive-query-tool?platform=Twinfield&importance=3#invantive-query-tool-26.0-to-27.0-new) (7) | [Twitter](/nl/release-notes/products/invantive-query-tool?platform=Twitter&importance=3#invantive-query-tool-26.0-to-27.0-new) (1) | [VIES](/nl/release-notes/products/invantive-query-tool?platform=VIES&importance=3#invantive-query-tool-26.0-to-27.0-new) (1) | [Visma Severa](/nl/release-notes/products/invantive-query-tool?platform=Visma%20Severa&importance=3#invantive-query-tool-26.0-to-27.0-new) (1) | [Visma.net](/nl/release-notes/products/invantive-query-tool?platform=Visma.net&importance=3#invantive-query-tool-26.0-to-27.0-new) (5) | [Wikipedia](/nl/release-notes/products/invantive-query-tool?platform=Wikipedia&importance=3#invantive-query-tool-26.0-to-27.0-new) (2) | [Windows WMI](/nl/release-notes/products/invantive-query-tool?platform=Windows%20WMI&importance=3#invantive-query-tool-26.0-to-27.0-new) (2) | [WMI](/nl/release-notes/products/invantive-query-tool?platform=WMI&importance=3#invantive-query-tool-26.0-to-27.0-new) (1) | [XAA](/nl/release-notes/products/invantive-query-tool?platform=XAA&importance=3#invantive-query-tool-26.0-to-27.0-new) (1) | [XAF](/nl/release-notes/products/invantive-query-tool?platform=XAF&importance=3#invantive-query-tool-26.0-to-27.0-new) (1) | [Yuki](/nl/release-notes/products/invantive-query-tool?platform=Yuki&importance=3#invantive-query-tool-26.0-to-27.0-new) (5)

</div>

147 van 380 weergegeven.

<a id="invantive-query-tool-26.0-to-27.0-e-installation-and-platform"></a>

#### Installation and platform

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

##### Settings files move from XML to JSON

A settings file in XML is converted to JSON when it is read. The user and installation settings, the cached list of databases and the databases of the user are also written in JSON, through an atomic write, and a damaged XML file is recovered where possible. From 27.0 the JSON file takes precedence; the XML file is still written for older releases on the same workstation and is planned to disappear.

<div class="rn-action">

**Wat te doen**

Settings files are converted from XML to JSON when they are read. From 27.0 the JSON file takes precedence and the XML file is removed in release 28.0: edit the JSON file from now on and keep a copy of the XML file until then.

</div>

<div class="rn-chips">

- **actie nodig**
- belang 5

</div>

</div>

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

##### File names longer than 260 characters work on Windows

Where Windows allows it, file and folder paths up to 32,767 characters are accepted. The setup program declares support for long paths and the trace shows whether they work.

<div class="rn-chips">

- belang 3

</div>

</div>

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

##### Share user and installation settings with release 25.0 products on one device

Release 27.0 products read and write the user and installation settings in a way that does not conflict with release 25.0 products installed on the same device. Licence key settings of both generations are kept apart.

<div class="rn-chips">

- belang 3

</div>

</div>

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

##### The keychain and settings files are written safely

The keychain and settings files hold either the old or the new contents, also after a crash or a full disk, are guarded with a file lock when two programs use them, are written less often and open faster.

<div class="rn-chips">

- belang 3

</div>

</div>

<a id="invantive-query-tool-26.0-to-27.0-e-licensing-and-sign-in"></a>

#### Licensing and sign-in

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

##### Data containers and credentials from Invantive Credentials Server

A database definition can point to Invantive Credentials Server, which supplies the data containers and sign-in credentials. The log-on window and the partition menu show these containers with their own icon, errors of the server are shown with their details, and a retrieval is repeated after a time-out.

<div class="rn-chips">

- Invantive Credentials Server
- belang 4

</div>

[Invantive Credentials Server](https://documentation.invantive.com/Invantive+Credentials+Server/Invantive+Credentials+Server), [Concept of Invantive Credentials Server](https://documentation.invantive.com/Invantive+Credentials+Server/Concept)

</div>

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

##### Exact Online companies outside the service area are no longer accepted

Exact Online divisions of companies in a country on an exclusion list, or outside the service area, are no longer offered, except for a fixed list of companies that were allowed before. A log line states the exclusion.

<div class="rn-action">

**Wat te doen**

Companies in countries outside the service area are no longer available in Exact Online.

</div>

<div class="rn-chips">

- **actie nodig**
- Exact Online
- belang 4

</div>

[Service area of Invantive Cloud](https://documentation.invantive.com/Invantive+Cloud/Concepts/Service+Area)

</div>

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

##### Invantive License Service: clearer messages, grace period and new modules

A licence key of the wrong type is explained, a licence service that is unavailable gets a specific message, and a licence that was valid stays in force for a grace period when the service cannot be reached. The check that prolongs a licence runs hourly. New licence modules exist for the Support Assistant, OEM use and subscription software, the built-in trial and open data keys use the new format, and text-mode products show tips about the licence in use.

<div class="rn-chips">

- belang 4

</div>

[License Service](https://documentation.invantive.com/Environment+Variables/License+Service)

</div>

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

##### Running a script requires the licensed function for scripts

Running all statements of a script, also from the command line options /execute and /script, is refused without the licence function for scripts. The refusal names the function.

<div class="rn-chips">

- belang 4

</div>

</div>

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

##### Accept the licence agreement and give a name from the command line

Command line options and environment variables accept the licence agreement for a named licence variant and supply the first and last name of the person. This lets the product start without a dialog.

<div class="rn-chips">

- belang 3

</div>

</div>

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

##### Invantive MCP Server is recognised as an application

The Invantive MCP Server is now a known application for licence checks and for the choice of client settings.

<div class="rn-chips">

- belang 3

</div>

</div>

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

##### Licence keys can be supplied through environment variables

A licence key can be given in the environment variables INVANTIVE_LIC_KEY and INVANTIVE_LICX_KEY, also with surrounding text or line breaks. This helps with unattended starts, for example in scripts and containers.

<div class="rn-chips">

- belang 3

</div>

[Environment variables](https://documentation.invantive.com/Environment+Variables/Environment+Variables)

</div>

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

##### OAuth redirect hosts of several platforms are unified under one address

The redirect hosts of Dropbox, Loket.nl, Microsoft Graph, PayPal, Visma e-Accounting, Exact Online, Salesforce and Visma.net are unified under clientredirect.invantive.com; Dynamics CRM keeps its own host.

<div class="rn-chips">

- Dynamics 365 CRM
- Loket.nl
- Dropbox
- HubSpot
- Fortnox
- belang 3

</div>

</div>

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

##### Several local functions can no longer be licensed

The licence requirements of a number of local functions and statements were changed so that no licence allows them. These include the encryption of passwords, connection strings and variable values, the keychain statement, the garbage collection statement and a batch import for Exact Online.

<div class="rn-chips">

- Exact Online
- belang 3

</div>

</div>

<a id="invantive-query-tool-26.0-to-27.0-e-security"></a>

#### Security

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

##### Loading of provider assemblies from a settings file is blocked

A provider that a settings file loads from an assembly file now fails with an error, because no files are on the allowed list yet. The EDIFACT provider no longer loads its template assembly from disk. Plan for this when a script or settings file relies on custom providers or EDIFACT templates.

<div class="rn-action">

**Wat te doen**

A provider loaded from an assembly named in a settings file now fails; no file is on the allowed list yet.

</div>

<div class="rn-chips">

- **actie nodig**
- EDIFACT
- belang 4

</div>

</div>

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

##### Prevent SQL injection through inlined values on MySQL and PostgreSQL

String values that are placed in generated SQL for MySQL are now escaped for backslashes as well as quotes. A PostgreSQL session now sets standard_conforming_strings to on and fails with an error when the server does not accept this.

<div class="rn-chips">

- MySQL
- PostgreSQL
- belang 3

</div>

</div>

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

##### Sensitive values are masked in traces, error data and OAuth logs

Passwords, secrets, tokens, API keys, cookies, authorisation headers and one-time codes are no longer written in clear text in traces, exception data and the log text of OAuth calls.

<div class="rn-chips">

- belang 3

</div>

</div>

<a id="invantive-query-tool-26.0-to-27.0-e-sql-engine"></a>

#### SQL engine

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

##### Correlated subqueries are supported

A subquery can refer to columns of the outer query, as in EXISTS, IN and scalar subqueries. A subquery without outer references is evaluated once per statement and its answer is reused.

<div class="rn-chips">

- belang 5

</div>

</div>

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

##### QR code functions take one size value instead of width and height

The functions that create a QR code and a QR code for a European payment (EPC) now take a single size per element instead of separate width and height. Existing statements that pass width and height must be changed. The QR code library has been replaced.

<div class="rn-action">

**Wat te doen**

Adjust statements that call the QR code functions with a separate width and height.

</div>

<div class="rn-chips">

- **actie nodig**
- belang 4

</div>

[Function BARCODE_QR](https://documentation.invantive.com/Invantive+UniversalSQL/Grammar/SQL+Functions/BARCODE_QR)

</div>

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

##### Add data dictionary views for keys and foreign keys

Two new data dictionary views list the primary keys and the foreign keys of tables, including keys of several columns. The columns view gets the original database data type and whether a value is required on update.

<div class="rn-chips">

- belang 3

</div>

</div>

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

##### Add technical documentation and more table and view properties to the data dictionary

The data dictionary lists technical documentation for tables. The view catalogue gains 13 columns, among them the supported operations, documentation, an example, whether the view is partition specific, and the estimated latency and throughput. Technical documentation was added to a number of Exact Online views.

<div class="rn-chips">

- belang 3

</div>

</div>

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

##### Add the DESCRIBE statement to show the columns of a select or table

The new statement DESCRIBE returns the columns that a select statement, a table, a view or a table function answers, without reading any row.

<div class="rn-chips">

- belang 3

</div>

[Describe statement](https://documentation.invantive.com/Invantive+UniversalSQL/Grammar/Statement+Types/Describe+Statement+(describeStatement%29)

</div>

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

##### Column references may carry a schema and table qualifier

A column can be written as column, qualifier.column or schema.table.column, as in SQL Server.

<div class="rn-chips">

- SQL Server
- belang 3

</div>

</div>

<div class="rn-item" id="QTL-27.0-E046">

##### Copying data keeps the original database data type

The data type as the database reports it is kept with a column and used for bulk insert and create table. Wide decimal columns keep their integer digits when copied to MySQL, Oracle or SQL Server.

<div class="rn-chips">

- Oracle
- MySQL
- SQL Server
- belang 3

</div>

</div>

<div class="rn-item" id="QTL-27.0-E047">

##### Division and office list is kept when the USE statement changes the selection

Selecting divisions or offices with the USE statement no longer discards the loaded list. The list is not retrieved again and the state of each entry is kept. Newly selected entries are added to the existing selection.

<div class="rn-chips">

- belang 3

</div>

</div>

<div class="rn-item" id="QTL-27.0-E048">

##### HTTP functions can ignore web errors

The functions that fetch or post web content accept an extra argument to continue when the web server answers with an error, and the error text states the HTTP status code.

<div class="rn-chips">

- belang 3

</div>

</div>

<div class="rn-item" id="QTL-27.0-E049">

##### Integer constants in SQL keep an integer type

A whole number written in a statement is now handled as an integer instead of a decimal number. Result types of expressions on such constants can differ from before.

<div class="rn-action">

**Wat te doen**

Check expressions that rely on whole numbers being decimal; the data type of the result can differ.

</div>

<div class="rn-chips">

- **actie nodig**
- belang 3

</div>

</div>

<div class="rn-item" id="QTL-27.0-E050">

##### Register the SQL functions REGEXP_COUNT and REGEXP_LIKE for licensing

The SQL functions to count and test regular expression matches are registered with the licence requirements of advanced calculation.

<div class="rn-chips">

- belang 3

</div>

</div>

<div class="rn-item" id="QTL-27.0-E051">

##### Table function to split a text into runs of characters

A new table function returns the runs of a given length of a text, with their positions. It can be joined to find texts that resemble each other. Use of the function is controlled by a function right.

<div class="rn-chips">

- belang 3

</div>

</div>

<div class="rn-item" id="QTL-27.0-E052">

##### number_to_speech supports more languages

The SQL function number_to_speech can spell numbers in English in addition to Dutch and now accepts exactly two arguments: the number and the language.

<div class="rn-chips">

- belang 3

</div>

</div>

<a id="invantive-query-tool-26.0-to-27.0-e-scripting"></a>

#### Scripting

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

##### Parts of a PSQL block can run in parallel

PSQL gets a PARALLEL construct that runs branches and loop iterations side by side, SYNCHRONIZE accepts a parallel option, and the package dbms_atomic holds values that parallel branches share safely.

<div class="rn-chips">

- belang 5

</div>

[Package dbms_parallel](https://documentation.invantive.com/Invantive+UniversalSQL/Packages/dbms_parallel), [Package dbms_atomic](https://documentation.invantive.com/Invantive+UniversalSQL/Packages/dbms_atomic)

</div>

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

##### Invantive Script statements are checked with a grammar, with better error messages

Statements of Invantive Script, such as local export results and local log on, are now read by a proper grammar. Keywords may be written in any case and options may follow in any order, while an option given twice or two contradicting options are refused. Errors name the problem more precisely. A few unused statements are withdrawn: the five results-clipboard statements and a variant of define encrypted.

<div class="rn-chips">

- belang 4

</div>

</div>

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

##### Remove obsolete Invantive Script statements

The statements to encrypt passwords, variable values and connection strings, define encrypted variables, deploy static files, show the keychain, run garbage collection, optimise the application, enable the event log, give feedback and import XML batches into Exact Online are no longer available. Scripts that use them must be changed.

<div class="rn-action">

**Wat te doen**

Remove the statements for encrypting passwords and variables, deploying static files and showing the keychain from scripts; they are no longer recognised.

</div>

<div class="rn-chips">

- **actie nodig**
- Exact Online
- belang 4

</div>

</div>

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

##### Scripts can run operating system commands with the new package dbms_os

The package dbms_os runs an operating system command with environment variables and a time limit, returns its output and exit code, and calculates a file hash. A command that runs too long is ended together with the programs it started. Files it writes are UTF-8 without byte order mark.

<div class="rn-chips">

- belang 4

</div>

[Package dbms_os](https://documentation.invantive.com/Invantive+UniversalSQL/Packages/dbms_os)

</div>

<div class="rn-item" id="QTL-27.0-E053">

##### A script can query its own execution profile

Runs of Invantive Script, their statements, started operating system commands, variables and exit codes are registered and can be queried with plain SQL through the new data container Script. The name of the profile log can be chosen, and statements register the memory they allocated.

<div class="rn-chips">

- belang 3

</div>

</div>

<div class="rn-item" id="QTL-27.0-E054">

##### Extend the cloud_http package for web applications

The package offers functions for the public URL of a module, the origin and the query string of the request and a redirect. Functions record the release in which they appeared.

<div class="rn-chips">

- belang 3

</div>

</div>

<div class="rn-item" id="QTL-27.0-E055">

##### Show the PSQL call stack, the statement and the stack trace in error details

An error in a PSQL procedure now shows the unit, the line and the statement it occurred in, also through nested procedures. The error dialog shows the statement and the stack traces as separate items and no longer repeats the message code.

<div class="rn-chips">

- belang 3

</div>

</div>

<a id="invantive-query-tool-26.0-to-27.0-e-query-tool-user-interface"></a>

#### Query Tool user interface

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

##### The Progress panel replaces Explain Plan and shows live how a statement runs

A statement is drawn while it runs: a card per step and platform, the rows flowing between steps, time, calls and bytes, live figures within a running step and an estimate of the time left. Reads over many files, bulk inserts, internet crawls and streaming reads report their progress, and the tab of a document shows a turning ring while its statement runs.

<div class="rn-chips">

- Big Data JSON
- Exact Online
- Oracle
- PostgreSQL
- SQL Server
- belang 5

</div>

[Progress in Invantive Query Tool](https://documentation.invantive.com/Invantive+Query+Tool/Progress)

</div>

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

##### A dark appearance that follows the Windows app theme

The windows, the SQL editor, grids, ribbon, dialogs, scroll bars and tool windows follow the dark appearance when Windows is set to dark mode, including the windows for plug-ins, parameters and running a script.

<div class="rn-chips">

- belang 4

</div>

</div>

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

##### Add, edit, test and delete database definitions in the Discover Databases window

The Discover Databases window can add, edit, duplicate, test and delete a database definition on the screen. Settings files are validated and saved without losing members, and the editor has rights for deleting a database and managing settings files.

<div class="rn-chips">

- belang 4

</div>

[Databases and data containers](https://documentation.invantive.com/Invantive+Query+Tool/Databases+and+Data+Containers)

</div>

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

##### Available Objects handles tens of thousands of objects and lists native packages

The tree builds and refreshes faster with 30,000 or more objects, shows details of the selected data container beside it, an overlay names the step while it is filled, and a connection that sends statements natively to Oracle, MySQL, PostgreSQL or SQL Server lists the stored packages, procedures and functions, which Describe shows with their parameters.

<div class="rn-chips">

- MySQL
- Oracle
- PostgreSQL
- SQL Server
- belang 4

</div>

[Available Objects](https://documentation.invantive.com/Invantive+Query+Tool/Available+Objects), [Describe an object](https://documentation.invantive.com/Invantive+Query+Tool/Describe+Object)

</div>

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

##### Favourite and recently used databases

Databases can be marked as favourite in the log-on window and in text mode, recently used databases are listed first, and the choice is kept per user.

<div class="rn-chips">

- belang 4

</div>

</div>

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

##### Long operations can be cancelled and react quickly

A stop button ends a Data Loader run and operations such as synchronize and loops of a script, and the stop window names the operation and its progress. Cancelling also stops slow web requests, waits between retries and compression, and closing the application ends its work within a set time.

<div class="rn-chips">

- Twinfield
- belang 4

</div>

</div>

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

##### Results of every platform are read while scrolling, ahead of the view

The results grid shows the first rows quickly and reads further rows in the background as the grid is scrolled, for every platform and not only for Oracle and MySQL. A statement with a trailing line comment on Oracle no longer fails.

<div class="rn-chips">

- belang 4

</div>

</div>

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

##### The Connection Monitor shows the calls of the application to databases and platforms

A dot shows whether the application talks to a database or platform. It opens a window with the calls, their moment in UTC, duration, rows, bytes and the action, with a load graph; running calls show the time and rows so far.

<div class="rn-chips">

- Oracle
- Windows WMI
- belang 4

</div>

[Connection Monitor](https://documentation.invantive.com/Invantive+Query+Tool/Connection+Monitor)

</div>

<div class="rn-item" id="QTL-27.0-E082">

##### AI agent mode: agents are detected and marked

Programs detect when they run within an AI agent, show it in the status line, and the Log-on window shows a shield with the type of agent. Agent mode can be forced on or off with a command line option.

<div class="rn-chips">

- belang 3

</div>

</div>

<div class="rn-item" id="QTL-27.0-E083">

##### Add accessibility names so screen readers and UI automation can read the windows

Windows, tabs, lists and buttons of the Query Tool and related windows carry names that screen readers and automation tools read. Before, some items announced a technical type name or nothing.

<div class="rn-chips">

- belang 3

</div>

</div>

<div class="rn-item" id="QTL-27.0-E084">

##### Command line options for the Query Tool

The Query Tool accepts /open to open named documents, /nodocuments to start without the documents of the previous session, /help for the usage and /signal to mark a special run in the title bar. All programs share one reader of options, with a statement to execute.

<div class="rn-chips">

- belang 3

</div>

[Command line options of Invantive Query Tool](https://documentation.invantive.com/Invantive+Query+Tool/Command+Line+Options)

</div>

<div class="rn-item" id="QTL-27.0-E085">

##### Handle DBMS Output of more than a million lines

The DBMS Output window handles outputs of 1 GB and more without freezing, keeps its view in place while output arrives and can save the output. Polling of the output after a statement costs less.

<div class="rn-chips">

- belang 3

</div>

</div>

<div class="rn-item" id="QTL-27.0-E086">

##### Redesign the icons of the application

Icons of the toolbar, ribbon and menus are redesigned. The trace entry gets its own icon.

<div class="rn-chips">

- belang 3

</div>

</div>

<div class="rn-item" id="QTL-27.0-E087">

##### SQL highlighting follows the dialect of the platform

The SQL editor colours keywords, functions, data types and table names separately, using the keywords and functions of the platform in use.

<div class="rn-chips">

- belang 3

</div>

</div>

<div class="rn-item" id="QTL-27.0-E088">

##### Search field on every panel of the Query Tool

The object tree, history, results, DBMS Output and Trace panels each get a search field. The tree and history hide what does not match, the other panels go to matches.

<div class="rn-chips">

- belang 3

</div>

</div>

<div class="rn-item" id="QTL-27.0-E089">

##### Show row counts on Describe tabs and in the Available Objects tree

The Describe window shows the number of rows on each tab caption, and the Available Objects tree shows counts. Some ribbon commands and editor items received a missing icon.

<div class="rn-chips">

- belang 3

</div>

</div>

<div class="rn-item" id="QTL-27.0-E090">

##### Switch faster between query documents; share History and Available Objects panes

History and Available Objects are shared by all documents of a window, so switching documents no longer rebuilds them and reads the objects again. Results, DBMS Output, Explain Plan and Trace stay per document.

<div class="rn-chips">

- belang 3

</div>

</div>

<div class="rn-item" id="QTL-27.0-E091">

##### Trace panel with the trace messages of the application

The Trace panel shows the trace messages of the application in a grid, collected while the panel is switched on, with the latest 100,000 kept.

<div class="rn-chips">

- belang 3

</div>

</div>

<div class="rn-item" id="QTL-27.0-E092">

##### Windows remember their position and size

The main windows are restored at the position and size of the last session. A loss of the width at each start is repaired.

<div class="rn-chips">

- belang 3

</div>

</div>

<a id="invantive-query-tool-26.0-to-27.0-e-platforms-and-drivers"></a>

#### Platforms and drivers

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

##### DeepL driver

A new driver reads and writes DeepL: languages, billing, translation, writing assistance, documents, glossaries, style rules and translation memories.

<div class="rn-chips">

- DeepL
- belang 5

</div>

</div>

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

##### Add write support to AFAS Online

AFAS Online connectors that only write become tables per update connector. Objects below the main element, such as the lines of a financial entry, get a table of their own that can be inserted into within a transaction.

<div class="rn-chips">

- AFAS Online
- belang 4

</div>

</div>

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

##### New platforms: Inspectlet, Matomo, Nextcloud and Tweede Kamer v5

Four new drivers read Inspectlet (websites and recorded sessions), Matomo web analytics with a package of PSQL procedures, a Nextcloud server (tables depend on the installed apps) and the Tweede Kamer open data on the new API. The earlier Tweede Kamer driver remains available. Each platform has a licence module and an icon.

<div class="rn-chips">

- Inspectlet
- Matomo
- Nextcloud
- Tweede Kamer
- belang 4

</div>

</div>

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

##### Pipedrive platform

Pipedrive can be read as a new platform, with labels for custom fields, and the OAuth sign-in window understands its error answers.

<div class="rn-chips">

- Pipedrive
- belang 4

</div>

</div>

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

##### Remove the LinkedIn and Loket.nl SOAP drivers and the Dynamics CRM table list

The LinkedIn driver and the SOAP-based Loket.nl driver are no longer part of the product. The Dynamics CRM driver no longer registers its predefined list of tables and columns.

<div class="rn-action">

**Wat te doen**

Statements on the LinkedIn driver and the SOAP-based Loket.nl driver no longer work.

</div>

<div class="rn-chips">

- **actie nodig**
- LinkedIn
- Loket.nl
- Microsoft Dynamics CRM
- belang 4

</div>

</div>

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

##### The legacy Oracle driver and the Invantive Web Service driver are removed; Oracle 18 is the minimum

The legacy Oracle driver is no longer registered and Oracle is handled by the managed driver, a log-on to a database older than version 18 is refused, and the Invantive Web Service driver and its data container are no longer offered.

<div class="rn-action">

**Wat te doen**

Check connections to Oracle databases older than version 18, and connections that name the legacy Oracle driver or the Invantive Web Service driver: they no longer work.

</div>

<div class="rn-chips">

- **actie nodig**
- Invantive Web Service
- Oracle
- belang 4

</div>

</div>

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

##### Visma.net: new API specification, Visma Connect log-on and the Sales Order APIs

The Visma.net driver uses the API specification of 18 June 2026 and the new Visma Connect sign-in, and adds tables for the Sales Order APIs with server-side filtering, insert and update. Filters such as not in and not equal on a column with a fixed list of values are sent as requests for the remaining values.

<div class="rn-chips">

- Visma.net
- belang 4

</div>

</div>

<div class="rn-item" id="QTL-27.0-E056">

##### A lost connection to a relational database is set up again

A connection to a relational database that was lost is rebuilt and the application log-on is repeated on the new session, so the next statement does not fail. The pool of connections shrinks when it is not needed.

<div class="rn-chips">

- belang 3

</div>

</div>

<div class="rn-item" id="QTL-27.0-E057">

##### Add company and deal attributes to the Brevo driver

The Brevo driver returns the attributes of companies and deals.

<div class="rn-chips">

- Brevo
- belang 3

</div>

</div>

<div class="rn-item" id="QTL-27.0-E058">

##### Bring the ActiveCampaign driver level with API v3

The driver gains columns and tables, such as notes, custom objects, custom field options, deal roles and bulk import of contacts. Writes that the platform could not carry out are withdrawn, and the request rate follows the limits that the platform reports.

<div class="rn-chips">

- ActiveCampaign
- belang 3

</div>

</div>

<div class="rn-item" id="QTL-27.0-E059">

##### Connection forms are described by the attributes of a driver

Provider attributes now state the kind of value, the accepted values and whether a value is required, for more numeric types. Two data dictionary views show these properties. A web service URL is requested at log on only for platforms where the user supplies it.

<div class="rn-chips">

- Bridge Online
- Dynamics 365 CRM
- Magento
- Mendix
- Nmbrs
- belang 3

</div>

</div>

<div class="rn-item" id="QTL-27.0-E060">

##### Crisp: 50 more tables, filters at the platform and procedures to clear fields

The Crisp driver offers about 50 additional tables, sends filters on conversation tables to Crisp and exposes more conversation data. New procedures clear a field of a people profile.

<div class="rn-chips">

- Crisp
- belang 3

</div>

</div>

<div class="rn-item" id="QTL-27.0-E061">

##### Exact Online XML tables follow the XML schema of 3 August 2026 and load faster

The XML tables are updated to the current schema, and the data model is read from a predefined list of fields instead of being derived from the schema on every start.

<div class="rn-chips">

- Exact Online
- belang 3

</div>

</div>

<div class="rn-item" id="QTL-27.0-E062">

##### Extend Gripp CRM with more tables and server-side filtering

Gripp CRM gets more tables, including tables for embedded lists, and more conditions are evaluated by Gripp itself, which reduces the rows transferred.

<div class="rn-chips">

- Gripp CRM
- belang 3

</div>

</div>

<div class="rn-item" id="QTL-27.0-E063">

##### Extend Magento with writes, packages and custom attributes

Magento gets a full data model with read, insert, update and delete, a package for operations that are no table rows, sample statements and one column per custom attribute of a product.

<div class="rn-chips">

- Magento
- Robaws
- belang 3

</div>

</div>

<div class="rn-item" id="QTL-27.0-E064">

##### Extend the Twinfield driver with settings, runs and code lists

New table functions read office, user, VAT code and project rate settings, and payment and collection runs. Code lists of the platform are given in the column descriptions, and a browse that only counts rows asks for one column. Page size on wide transaction tables is limited.

<div class="rn-chips">

- Twinfield
- belang 3

</div>

</div>

<div class="rn-item" id="QTL-27.0-E065">

##### Gripp CRM tables now have a schema name

The tables of Gripp CRM are now placed in a schema. Statements that use the old table names may have to be changed.

<div class="rn-action">

**Wat te doen**

Adjust statements that use the old table names of Gripp CRM; the tables now have a schema name.

</div>

<div class="rn-chips">

- **actie nodig**
- Gripp CRM
- belang 3

</div>

</div>

<div class="rn-item" id="QTL-27.0-E066">

##### Magento and Open Besluitvorming are production platforms; Yuki and Robaws leave run-out

Magento, Open Besluitvorming and Stripo are registered as production platforms, and Yuki and Robaws are production platforms again after they were marked as run-out.

<div class="rn-chips">

- Magento
- Open Besluitvorming
- Robaws
- Stripo
- Yuki
- belang 3

</div>

</div>

<div class="rn-item" id="QTL-27.0-E067">

##### PostgreSQL: setting fail-on-missing-tables

A new setting fail-on-missing-tables on the PostgreSQL driver controls the check that every primary key in the metadata has an accessible table or view. When off, the check is skipped.

<div class="rn-chips">

- PostgreSQL
- belang 3

</div>

</div>

<div class="rn-item" id="QTL-27.0-E068">

##### Read all read operations of the Yuki API

Yuki gets tables for the read operations of its published web services that were not available yet. Yuki stays read-only.

<div class="rn-chips">

- Yuki
- belang 3

</div>

</div>

<div class="rn-item" id="QTL-27.0-E069">

##### Refused Exact Online reads are remembered and listed

Calls that Exact Online refuses are remembered across sessions and no longer requested again and again. The new view RequestTablesWithoutRights lists the tables and companies for which a read was refused because of missing rights.

<div class="rn-chips">

- Exact Online
- belang 3

</div>

</div>

<div class="rn-item" id="QTL-27.0-E070">

##### SFTP connections are really supported and FTP calls are asynchronous

The SFTP driver now connects to an SFTP server with a password, with separate time-outs for connecting and for a single operation. Before, it could not perform the calls. The FTP driver was made asynchronous.

<div class="rn-chips">

- SFTP
- FTP
- belang 3

</div>

</div>

<div class="rn-item" id="QTL-27.0-E071">

##### Set the idle period before SQL connections are closed

A new provider attribute sets after how many seconds an idle connection to a SQL database is closed. Server products keep connections for 300 seconds by default.

<div class="rn-chips">

- SQL Server
- MySQL
- PostgreSQL
- Oracle
- belang 3

</div>

</div>

<div class="rn-item" id="QTL-27.0-E072">

##### SnelStart data model updated to the API definition of 27 May 2026

The SnelStart tables and columns follow the new API definition. More reference columns are included and decimal values are read as decimal numbers. One slow, experimental view stays disabled.

<div class="rn-chips">

- SnelStart
- belang 3

</div>

</div>

<div class="rn-item" id="QTL-27.0-E073">

##### Speed up SnelStart counts and read documents and long text filters

SnelStart gets a table for sales invoice lines from orders. Counts read only the key column. Document tables with an empty parent identifier no longer fail, and a filter on long text is narrowed with a prefix.

<div class="rn-chips">

- SnelStart
- belang 3

</div>

</div>

<div class="rn-item" id="QTL-27.0-E074">

##### Stripo Email platform

Stripo Email can be read and written as a new platform with emails, templates and modules.

<div class="rn-chips">

- Stripo
- Stripo Email
- belang 3

</div>

</div>

<div class="rn-item" id="QTL-27.0-E075">

##### Support SQL Server geography, geometry and hierarchyid data types

Columns of the SQL Server types geography, geometry and hierarchyid can now be read through the SQL Server driver.

<div class="rn-chips">

- SQL Server
- belang 3

</div>

</div>

<div class="rn-item" id="QTL-27.0-E076">

##### Twinfield: more offices can be used with the Invantive client ID

The list of offices that may be used with the Invantive client ID has more offices, including office 00001, and the new setting additional-allowed-offices names further offices.

<div class="rn-chips">

- Twinfield
- belang 3

</div>

</div>

<div class="rn-item" id="QTL-27.0-E077">

##### Update Kadaster to the current OpenAPI specification

The tables of Kadaster follow the OpenAPI specification of the platform.

<div class="rn-chips">

- Kadaster
- belang 3

</div>

</div>

<div class="rn-item" id="QTL-27.0-E078">

##### Update Robaws to the latest API and add a package for operations

Robaws follows the API specification of 2026-11-01. A package offers operations that are no table row, such as archiving, locking, booking an invoice and downloading the PDF of a document.

<div class="rn-chips">

- Robaws
- belang 3

</div>

</div>

<div class="rn-item" id="QTL-27.0-E079">

##### Update Wikipedia with search, pages, history, links and files

Wikipedia gets tables for search, pages with content, the history and links of a page and files, and a parameter to choose the language wiki.

<div class="rn-chips">

- Wikipedia
- belang 3

</div>

</div>

<div class="rn-item" id="QTL-27.0-E080">

##### Update the Logius COR driver to the new host and API version 1

The driver uses the new Logius register host and API version 1. The old host no longer resolves. Error answers use the new format.

<div class="rn-chips">

- Logius COR
- belang 3

</div>

</div>

<div class="rn-item" id="QTL-27.0-E081">

##### Web calls wait and retry better

Timeouts apply as configured, a stalled connection is cut off and treated as temporary, retries wait longer each time with a random part and follow the Retry-After header, a session slows down before the minutely rate limit is used up, a token endpoint that does not answer is dropped after 30 seconds, and damaged compressed answers are read again.

<div class="rn-chips">

- Dynamics CRM
- belang 3

</div>

</div>

<a id="invantive-query-tool-26.0-to-27.0-e-export-and-import"></a>

#### Export and import

<div class="rn-item" id="QTL-27.0-E093">

##### Export to HTML and Rich Text Format; the Excel export follows the settings

Results can be exported to HTML and RTF with the chosen columns, row range and row limit. The Excel export follows the settings for columns, rows and SQL statement and can put the SQL on a separate worksheet.

<div class="rn-chips">

- belang 3

</div>

[Exporting results](https://documentation.invantive.com/Invantive+Query+Tool/Exporting+Results)

</div>

<div class="rn-item" id="QTL-27.0-E094">

##### UTF-8 files are written without a byte order mark by default

Exports, trace files, plug-in files and the input and output of operating system commands are written as UTF-8 without a byte order mark unless one is asked for.

<div class="rn-action">

**Wat te doen**

Check programs that read exported text files and expect a byte order mark.

</div>

<div class="rn-chips">

- **actie nodig**
- belang 3

</div>

</div>

<a id="invantive-query-tool-26.0-to-27.0-e-performance"></a>

#### Performance

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

##### More work is sent to the platform: row limit, grouping, selected columns and joins

A query with LIMIT or TOP is limited by the platform, COUNT, SUM and other group functions are answered by the platform on supported drivers, only the columns that a query needs are requested, join conditions are forwarded, an exists condition on a child table reaches the platform, and OData platforms get shorter filters with the IN operator. Fewer rows are transferred.

<div class="rn-chips">

- ActiveCampaign
- Bridge Online
- Crisp
- Exact Online
- IBM Db2
- Inspectlet
- Invantive Bridge Online
- Matomo
- MySQL
- ODBC
- OData
- Odoo
- Oracle
- PayPal
- PostgreSQL
- SQL Server
- Tweede Kamer
- belang 5

</div>

</div>

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

##### Big Data JSON reads files much faster and skips files that cannot match

Collections of NDJSON files, plain or Zstandard compressed, are streamed and only the needed columns are built. A directory gets an index with value ranges, Bloom filters and counts, so filters, counts and group-by statements read fewer files.

<div class="rn-chips">

- Big Data JSON
- belang 4

</div>

</div>

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

##### Data is loaded in the background while a session is idle

A connected session fills caches with predictable data, such as the tables read in the last fourteen days and the incremental tables of Exact Online, Freshdesk and Freshservice, using spare rate allowance. Four loads run in parallel, partitions can be chosen, and the connection monitor shows the loads.

<div class="rn-chips">

- Exact Online
- Freshdesk
- Freshservice
- belang 4

</div>

</div>

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

##### Exact Online incremental tables reload less often and are read faster

Incremental tables avoid full reloads caused by a rejected previous image or a row count guard, are read from the cache up to six times faster, and stop an incremental run when the deleted rows needed are older than the platform keeps them. The new table IncrementalEntityTypes lists the entity types that can be loaded incrementally.

<div class="rn-chips">

- Exact Online
- belang 4

</div>

</div>

<div class="rn-item" id="QTL-27.0-E095">

##### Bulk insert for Oracle and MySQL

Rows are inserted into Oracle with array binding and into MySQL with the bulk loader, which is faster than row-by-row inserts.

<div class="rn-chips">

- MySQL
- Oracle
- belang 3

</div>

</div>

<div class="rn-item" id="QTL-27.0-E096">

##### Data Cache no longer runs forced garbage collection; three settings removed

The Data Cache driver no longer starts a full garbage collection after replications. The settings garbage-collection-physical-memory-load-threshold, garbage-collection-replication-interval-count and garbage-collection-replication-minimum-interval-sec are removed. Remove them from settings files that still set them.

<div class="rn-action">

**Wat te doen**

Remove the three garbage-collection settings of the Data Cache driver from settings files.

</div>

<div class="rn-chips">

- **actie nodig**
- Data Cache
- belang 3

</div>

</div>

<div class="rn-item" id="QTL-27.0-E097">

##### Disable GSS (Kerberos) negotiation on PostgreSQL connections for faster log-on

Every new PostgreSQL connection first asked the server for Kerberos encryption, which servers without Kerberos refuse by closing the connection. The setting is now disabled by default, which makes opening connections faster.

<div class="rn-chips">

- PostgreSQL
- belang 3

</div>

</div>

<div class="rn-item" id="QTL-27.0-E098">

##### Faster log-on with many data containers

Translations are kept locally and fetched at most once a day, the keychain is read once when switching database, icons are downloaded in parallel, and discovery no longer waits for the slowest platform: a platform that is still busy is shown when it answers.

<div class="rn-chips">

- AFAS Online
- CBS
- Exact Online
- HubSpot
- Salesforce
- belang 3

</div>

</div>

<div class="rn-item" id="QTL-27.0-E099">

##### Lower memory use and faster processing

Encryption, compression, logging, translations, JSON reading, sorting, the in-memory driver and long-running sessions allocate less memory and use less CPU time. Creating a table from a large result streams the rows, and several string functions run faster.

<div class="rn-chips">

- Exact Online
- In-memory
- MySQL
- Oracle
- PostgreSQL
- SQL Server
- XAF
- belang 3

</div>

</div>

<div class="rn-item" id="QTL-27.0-E100">

##### Oracle is read faster and sends fewer extra statements

Data is fetched in larger batches from the first round trip, rows are limited and paged on the server, the output buffer is read only while something listens, and sessions send fewer statements for settings.

<div class="rn-chips">

- Oracle
- belang 3

</div>

</div>

<div class="rn-item" id="QTL-27.0-E101">

##### Zstandard compression for trace files, caches and SQL functions

Trace files, persistent caches, saved result sets and the disk cache of web answers are compressed with Zstandard, which is faster than gzip at a similar size. Two SQL functions compress and decompress with Zstandard, and a text file with gzip or Zstandard content is read as plain text.

<div class="rn-chips">

- belang 3

</div>

</div>

<a id="invantive-query-tool-26.0-to-27.0-e-documentation"></a>

#### Documentation

<div class="rn-item" id="QTL-27.0-E102">

##### Links to documentation, forums and support use the invantive.eu address

Help links, the splash screen, the default address of Customer Service and the links of data sources point to the invantive.eu domain.

<div class="rn-chips">

- Dynamics CRM
- Microsoft Graph
- PayPal
- belang 3

</div>

</div>

<a id="invantive-query-tool-26.0-to-27.0-fixed"></a>

### Alle Bugfixes

Verholpen fouten in de oudere versie.

<a id="invantive-query-tool-26.0-to-27.0-b-licensing-and-sign-in"></a>

#### Licensing and sign-in

<div class="rn-item" id="QTL-27.0-B002">

##### Refresh Exact Online tokens correctly when requests of one session run concurrently

Platforms that renew refresh tokens, such as Exact Online, accept only the newest token. Concurrent requests of one session each held an older copy and failed with an error about an outdated refresh token. A renewed token is now shared by all connections in the process.

<div class="rn-chips">

- Exact Online
- belang 4

</div>

</div>

<div class="rn-item" id="QTL-27.0-B006">

##### Prevent failing entry of the password on the Exact Online sign-in page

Entering the user name and password on the Exact Online sign-in page failed from time to time. The sign-in window now waits for the fields and retries.

<div class="rn-chips">

- Exact Online
- belang 3

</div>

</div>

<div class="rn-item" id="QTL-27.0-B007">

##### Repeat authorisation also when an OAuth error is wrapped in another error

When a sign-in error was wrapped inside another exception, the automatic retry with a new authorisation did not start and the original error was shown. Wrapped OAuth errors are now recognised wherever they occur.

<div class="rn-chips">

- Exact Online
- belang 3

</div>

</div>

<a id="invantive-query-tool-26.0-to-27.0-b-security"></a>

#### Security

<div class="rn-item" id="QTL-27.0-B008">

##### XML from outside is no longer allowed to load external entities

Processing XML from external services, XSLT transformations and the XML of an RSA key no longer resolves DTDs or external entities.

<div class="rn-chips">

- Twinfield
- VIES
- Visma Severa
- belang 3

</div>

</div>

<a id="invantive-query-tool-26.0-to-27.0-b-sql-engine"></a>

#### SQL engine

<div class="rn-item" id="QTL-27.0-B001">

##### Joins return the correct rows

A left, right or full join written without the word OUTER was executed as an inner join and lost rows. A right outer join placed columns in the wrong order, a condition in ON removed rows, a cross join dropped its right-hand side, and a full outer join that could not be answered was not reported.

<div class="rn-chips">

- belang 5

</div>

</div>

<div class="rn-item" id="QTL-27.0-B003">

##### Filters no longer lose rows or evaluate wrongly

A condition such as a and (b or c) could return too few rows, lower and upper case conversions and decimal constants were not sent correctly to SQL databases, NOT LIKE dropped rows that differ only in case, and x between 1 and 2 and y = 1 was read wrongly.

<div class="rn-chips">

- Microsoft Access
- SQL Server
- belang 4

</div>

</div>

<div class="rn-item" id="QTL-27.0-B009">

##### Barcodes: PDF417 symbols are generated and EAN-13 text and short codes are correct

Generating a PDF417 barcode always failed, for numeric, text and binary content. Short numeric PDF417 codes got no padding or error correction, and the text under an EAN-13 barcode repeated a digit and left out the check digit. A code with fewer than 13 digits caused an error.

<div class="rn-chips">

- belang 3

</div>

</div>

<div class="rn-item" id="QTL-27.0-B010">

##### Calling a pipelined table function could fail with error itgenclr009

Calling a pipelined table function in certain statements raised error itgenclr009. The call now passes all required arguments.

<div class="rn-chips">

- belang 3

</div>

</div>

<div class="rn-item" id="QTL-27.0-B011">

##### Databases with the same name in different groups were confused

When two databases in a settings file have the same name in different groups and no explicit id, they got the same internal id. Stored data such as a cached sign-in token could then be used for the wrong database. The group name is now part of the id.

<div class="rn-chips">

- belang 3

</div>

</div>

<div class="rn-item" id="QTL-27.0-B012">

##### Function date_trunc gave wrong dates for millennium, century and decade

Truncating a date to millennium, century or decade returned a date in the next year or a wrong date. The result is now the first day of the period, such as 2000-01-01.

<div class="rn-chips">

- belang 3

</div>

</div>

<div class="rn-item" id="QTL-27.0-B013">

##### Function instr gave wrong results for reverse search and occurrences

The instr function returned wrong positions for a negative start position, for an occurrence higher than one and for a start beyond the text. The search was rewritten.

<div class="rn-chips">

- belang 3

</div>

</div>

<div class="rn-item" id="QTL-27.0-B014">

##### Function normalize removed path separators that were allowed

The function that normalises file names removed the path separators even when they were allowed. It also now treats the forward slash like the backslash when shortening a name.

<div class="rn-chips">

- belang 3

</div>

</div>

<div class="rn-item" id="QTL-27.0-B015">

##### HTTPDOWNLOAD failed with a null reference when it read a cached result

The function HTTPDOWNLOAD could fail with an unexpected error when its earlier result was read back from the memory cache. Cached results are now restored correctly.

<div class="rn-chips">

- belang 3

</div>

</div>

<div class="rn-item" id="QTL-27.0-B016">

##### INTERSECT, EXCEPT and duplicate column names return the standard result

A chain of INTERSECT selects answered a intersect (b union c), SELECT \* EXCEPT skipped columns that were not excluded, EXCEPT with several columns was read ambiguously, and a group function over a select list with duplicate column names failed.

<div class="rn-chips">

- belang 3

</div>

</div>

<div class="rn-item" id="QTL-27.0-B017">

##### Repair and harden the REGEXP functions

REGEXP_INSTR returned a position one past the end and REGEXP_REPLACE started one character too early. Flags that contradict each other follow Oracle, and a pattern that takes more than one second now raises an error instead of hanging.

<div class="rn-chips">

- belang 3

</div>

</div>

<div class="rn-item" id="QTL-27.0-B018">

##### Repeated and parallel CREATE OR REPLACE and IF NOT EXISTS statements work

Concurrent create or replace of functions and procedures, a function that kept calling its old body, and parallel create table if not exists or drop table if exists on the same table no longer fail.

<div class="rn-chips">

- In-memory
- belang 3

</div>

</div>

<div class="rn-item" id="QTL-27.0-B019">

##### Rows after the first page are read

Grids and collections that load rows in pages did not read rows beyond the part already loaded. All rows are returned now.

<div class="rn-chips">

- belang 3

</div>

</div>

<div class="rn-item" id="QTL-27.0-B020">

##### Send the correct value for user functions in set-based updates

An update such as set modified_by = user, or with coalesce over the user, sent a null to the database instead of the name of the logged-on user. A not-null column then refused the update, for example on PostgreSQL.

<div class="rn-chips">

- PostgreSQL
- belang 3

</div>

</div>

<a id="invantive-query-tool-26.0-to-27.0-b-scripting"></a>

#### Scripting

<div class="rn-item" id="QTL-27.0-B021">

##### An operating-system command that exceeds its maximum duration is now ended

A command started from a script that ran longer than its maximum duration was left running, and the failure showed as an unrelated internal error about a process that had not yet exited. The command and the programs it started are now ended and a message names the command and the limit.

<div class="rn-chips">

- belang 3

</div>

</div>

<a id="invantive-query-tool-26.0-to-27.0-b-query-tool-user-interface"></a>

#### Query Tool user interface

<div class="rn-item" id="QTL-27.0-B005">

##### The Cancel button of a running query works again

Cancel on the progress band stopped a query by aborting a thread, which modern .NET does not support, so a running query could not be cancelled and an error was shown. Cancel now goes through the cancellation of the run.

<div class="rn-chips">

- belang 4

</div>

</div>

<div class="rn-item" id="QTL-27.0-B036">

##### Closing and cancelling no longer freeze the application

Closing the application ends within five seconds, and cancelling a statement no longer leaves the window standing still while tips are loaded; after a cancel, work stops instead of starting again.

<div class="rn-chips">

- Oracle
- SQL Server
- belang 3

</div>

</div>

<div class="rn-item" id="QTL-27.0-B037">

##### Help opens the online documentation when no local help file exists

The Help action raised a cannot-find-help error when no local help file existed, although each product has an online documentation address. It now opens the online page.

<div class="rn-chips">

- belang 3

</div>

</div>

<div class="rn-item" id="QTL-27.0-B038">

##### History pane and Run buttons follow the documents that execute

The History pane showed statements of earlier sessions only. Run and Run All also stayed enabled during a script, and a run with exit after execute never closed. The pane and the buttons now follow every document.

<div class="rn-chips">

- belang 3

</div>

</div>

<div class="rn-item" id="QTL-27.0-B039">

##### Open the user messages window in obfuscated releases

The user messages window failed to open in every obfuscated release with an XML parse error. It opens now.

<div class="rn-chips">

- belang 3

</div>

</div>

<div class="rn-item" id="QTL-27.0-B040">

##### Race conditions and locking in the discovery of databases at log-on repaired

Database discovery at log-on could update the window from the wrong thread, lose results through shared state or hang through locking. Discovery results of all platforms are now merged safely.

<div class="rn-chips">

- belang 3

</div>

</div>

<div class="rn-item" id="QTL-27.0-B041">

##### The Query Tool no longer freezes on the clipboard

Reading or writing the clipboard no longer waits indefinitely for another program that holds it.

<div class="rn-chips">

- belang 3

</div>

</div>

<div class="rn-item" id="QTL-27.0-B042">

##### The scrollbar thumb of the results grid is visible again, also in dark mode

In the results grid the scrollbar showed its track but no visible thumb. The grid styles are now loaded and applied so the thumb shows in light and dark appearance.

<div class="rn-chips">

- belang 3

</div>

</div>

<a id="invantive-query-tool-26.0-to-27.0-b-platforms-and-drivers"></a>

#### Platforms and drivers

<div class="rn-item" id="QTL-27.0-B004">

##### Exact Online incremental data is no longer damaged or overwritten

Users of one subscription replaced each other's incremental image, a request that ended while an image was saved could leave chunks of two versions, a refresh that only added rows was taken as unchanged, and incremental data could end up in the folder of other cache settings or ignore the disk cache settings of the statement.

<div class="rn-chips">

- Exact Online
- belang 4

</div>

</div>

<div class="rn-item" id="QTL-27.0-B022">

##### A write that is refused with HTTP 403 is reported as an error

An update or synchronize on Exact Online Employees reported rows updated while every write was refused with Forbidden. The refusal is now raised as an error for writes and is still ignored for reads.

<div class="rn-chips">

- Exact Online
- belang 3

</div>

</div>

<div class="rn-item" id="QTL-27.0-B023">

##### Close connections that remain open after a failed log-on

When one data container refused to log on, the data containers opened before it stayed open. Repeated attempts left idle connections on the database; 101 failed attempts left about 120 connections.

<div class="rn-chips">

- belang 3

</div>

</div>

<div class="rn-item" id="QTL-27.0-B024">

##### Do not repeat an Exact Online XML write after a server error

A write that Exact Online answered with HTTP 500 was sent again, although Exact Online may have carried it out. A write is repeated only when the driver says it is safe.

<div class="rn-chips">

- Exact Online
- belang 3

</div>

</div>

<div class="rn-item" id="QTL-27.0-B025">

##### Exact Online: GLAccountClassificationsEx failed with itgendcr011

A statement on the table function GLAccountClassificationsEx with the parameter GLSchemeCode failed with itgendcr011 because the filter column was renamed. The renaming now applies only to the tables that use it.

<div class="rn-chips">

- Exact Online
- belang 3

</div>

</div>

<div class="rn-item" id="QTL-27.0-B026">

##### Exact Online: repeated error when reading account classifications

After a failed or cancelled retrieval of the account classifications, the same error (itgenshr062) was returned for every following request. The retrieval is now started again after a failure.

<div class="rn-chips">

- Exact Online
- belang 3

</div>

</div>

<div class="rn-item" id="QTL-27.0-B027">

##### Fix error on statements against five platforms and Invantive Business connectors

The Query Tool refused every statement on Slack, StackExchange, Teradata, Twitter, Ossus and the Invantive Business connectors with an error about a missing partition. The connectors are now accepted.

<div class="rn-chips">

- Slack
- StackExchange
- Teradata
- Twitter
- Ossus
- Invantive Business
- belang 3

</div>

</div>

<div class="rn-item" id="QTL-27.0-B028">

##### Make WMI queries return rows with their values

Queries on WMI classes failed or returned empty values because of several defects, for example missing catalogue and schema names, columns taken from the first instance of a class and values stored in the wrong position. These are repaired. Selected columns and row limits are now passed to WMI, and seven more classes are available.

<div class="rn-chips">

- Windows WMI
- belang 3

</div>

</div>

<div class="rn-item" id="QTL-27.0-B029">

##### Oracle query could fail with a null reference error on .NET 10

A query on an Oracle database could stop with a null reference error when running on .NET 10. The logging of the executed statement is now done safely.

<div class="rn-chips">

- Oracle
- belang 3

</div>

</div>

<div class="rn-item" id="QTL-27.0-B030">

##### Oracle: errors when a SELECT with IN runs in parallel

A SELECT with an IN list on Oracle could fail with a null reference inside the Oracle driver. The Oracle driver now runs one native call at a time to avoid this.

<div class="rn-chips">

- Oracle
- belang 3

</div>

</div>

<div class="rn-item" id="QTL-27.0-B031">

##### Prevent a null reference error on Oracle selects with long IN lists run in parallel

A select with a filter on more than 1000 values could fail with a null reference error inside the Oracle managed driver, because several fragments of the result were read at the same time. Reads from one connection are now done one at a time.

<div class="rn-chips">

- Oracle
- belang 3

</div>

</div>

<div class="rn-item" id="QTL-27.0-B032">

##### Recover an Oracle session that lost its application log on after a connection loss

After a dropped Oracle connection, the rebuilt session lacked the roles of the application log on. The resulting errors were shown as a wrongly installed software without a retry. The statement is now retried after the session and its application log on are rebuilt. Looking up the columns of a table tries the name as given and in the casing recommended for Oracle.

<div class="rn-chips">

- Oracle
- belang 3

</div>

</div>

<div class="rn-item" id="QTL-27.0-B033">

##### Setting divisions failed when the Exact Online Premium connector is enabled

Selecting divisions did not work when the Exact Online Premium connector was enabled. The selection is now passed on to the Exact Online connection.

<div class="rn-chips">

- Exact Online
- belang 3

</div>

</div>

<div class="rn-item" id="QTL-27.0-B034">

##### Shorten the retry wait on HubSpot rate limit answers and use the 10-second window

HubSpot rate limiting now uses the window that the platform prescribes. After an HTTP 429 answer the driver retries a few times with a bounded wait. Before, one page request could wait over 30 minutes and then hide the real cause.

<div class="rn-chips">

- HubSpot
- belang 3

</div>

</div>

<div class="rn-item" id="QTL-27.0-B035">

##### Twinfield: no licence error for offices when a custom client ID is used

A user with an own Twinfield client ID could get error itgentfr280 for an office that is not on the Invantive list. The check now applies only to the Invantive client IDs.

<div class="rn-chips">

- Twinfield
- belang 3

</div>

</div>

<a id="invantive-query-tool-26.0-to-27.0-b-export-and-import"></a>

#### Export and import

<div class="rn-item" id="QTL-27.0-B043">

##### Apply export settings consistently and keep dates in universal time

Exports to HTML and RTF now use the same selection of columns, rows and row limit as other formats. A text date with a fixed format no longer shifts with the time zone of the machine. An export that cannot carry the SQL statement, such as CSV, refuses to omit it silently.

<div class="rn-chips">

- belang 3

</div>

</div>

<div class="rn-item" id="QTL-27.0-B044">

##### Repair Excel export with empty user or company name and apply the output password

An Excel export no longer fails with an internal error when the user name or company name is empty. A workbook with an output password is now encrypted, and the footer shows the application name and version.

<div class="rn-chips">

- belang 3

</div>

</div>

<div class="rn-item" id="QTL-27.0-B045">

##### Repair NDJSON output of several result sets

NDJSON output wrapped the result sets in an object. The rows now follow each other as lines, as the format requires.

<div class="rn-chips">

- belang 3

</div>

</div>

<a id="invantive-query-tool-26.0-to-27.0-builds"></a>

### Waarop het Voortbouwt

| Soort | Naam | Van | Aan |
|---|---|---|---|
| invantive component | Invantive Query Tool | 26.0.4 | 27.0.92 |
| invantive component | Invantive Producer Windows | 26.0.4 | 27.0.92 |
| invantive component | Invantive Producer Base | 26.0.4 | 27.0.92 |
| invantive component | Invantive Producer Data | 26.0.4 | 27.0.92 |
| invantive component | Invantive SQL for Core | 26.0.4 | 27.0.92 |
| invantive component | Invantive SQL for Windows | 26.0.4 | 27.0.92 |
| invantive component | Invantive SQL | 26.0.4 | 27.0.92 |
| invantive component | Invantive Basics | 26.0.4 | 27.0.92 |
| build tool | Invantive Deploy | 26.0.4 | 27.0.92 |
| build tool change | Installing and upgrading a .NET 10 product no longer runs the NGEN tool per assembly |  |  |
| build tool change | Installer shows an error when another installation is already running |  |  |
| build tool change | Final installer window shows the version link |  |  |
| build tool change | Progress bar of the installer follows the measured duration of the installation stages |  |  |
| build tool change | Installer windows flicker less when moving to the next step |  |  |
| build tool change | Installer no longer stalls on an unreachable Customer Service and cancels reliably |  |  |
| build tool change | Installer explains in a window why installation settings cannot be downloaded |  |  |
| build tool change | Maintenance window checks that the product is still installed |  |  |
| build tool change | Installer shows unexpected errors in its own window |  |  |
| build tool change | Repair Office add-in name, optional email check and installs run as SYSTEM |  |  |
| build tool change | Installs run as SYSTEM are attributed to the end user, not to the SYSTEM account |  |  |
| build tool change | Each product gets one .NET 10 installer; the .NET Framework installer is no longer built |  |  |
| build tool change | Installer includes the files .NET needs to find native libraries such as WebView2 |  |  |
| build tool change | Installer carries native runtime folders and Catalan, Hungarian and Romanian resources |  |  |
| build tool change | Installer no longer includes the crash dump tool |  |  |
| build tool change | Supported Windows versions in release information follow mainstream support dates |  |  |
| build tool change | Installer writes its trace to the Invantive Trace folder when trace to file is on |  |  |
| build tool change | Installer texts for new messages are available in all supported languages |  |  |
| build tool change | Installer email step rejects example and test domains |  |  |
| target framework | Invantive.Producer:src/Invantive.Producer.QueryTool/Invantive.Producer.QueryTool.csproj | net10.0-windows |  |
| target framework | Invantive.Producer:src/Invantive.Producer.QueryTool.Setup/Invantive.Producer.QueryTool.Setup.csproj | net48 |  |
| target framework | Invantive.Producer:src/Invantive.Producer.Windows.Forms/Invantive.Producer.Windows.Forms.csproj | net48;net10.0-windows |  |
| target framework | Invantive.Producer:src/Invantive.Producer.QueryTool/Invantive.Producer.QueryTool.Build.csproj |  | net10.0-windows10.0.17763.0 |
| target framework | Invantive.Producer:src/Invantive.Producer.QueryTool.Setup/Invantive.Producer.QueryTool.Setup.Build.csproj |  | net48 |
| target framework | Invantive.Producer:src/Invantive.Producer.Windows.Forms/Invantive.Producer.Windows.Forms.Build.csproj |  | net48;net10.0-windows10.0.17763.0 |
| third party changed | Infragistics.WPF | 23.1.41 | 26.1.14 |
| third party changed | Oracle.ManagedDataAccess | 23.26.100 | 23.26.300 |
| third party changed | Oracle.ManagedDataAccess.Core | 23.26.100 | 23.26.301 |
| third party changed | Microsoft.Data.SqlClient | 7.0.0 | 7.1.1 |
| third party changed | Npgsql | 10.0.2, 8.0.9 | 10.0.3 |
| third party changed | Microsoft.Web.WebView2 | 1.0.3856.49 | 1.0.4129.50 |
| third party changed | EPPlus | 8.5.0 | 8.6.3 |
| third party changed | QuestPDF | 2026.2.3 | 2026.7.2 |
| third party changed | FluentFTP | 53.0.2 | 54.2.0 |
| third party changed | SSH.NET | 2025.1.0 | 2026.0.0 |
| third party changed | Dirkster.AvalonDock | 4.72.0 | 4.74.1 |
| third party changed | AWSSDK.S3 | 4.0.19 | 4.0.102 |
| third party changed | Elastic.Clients.Elasticsearch | 9.3.3 | 9.5.0 |
| third party changed | Microsoft.SqlServer.SqlManagementObjects | 181.15.0 | 181.25.0 |
| third party added | Dirkster.AvalonDock.Themes.VS2013 |  | 4.74.1 |
| third party added | Nodify |  | 7.3.0 |
| third party added | QRCoder |  | 1.8.0 |
| third party added | Scintilla5.NET |  | 7.0.0 |
| third party added | System.IO.Hashing |  | 10.0.13 |
| third party added | System.Linq.Async |  | 7.0.1 |
| third party added | System.Reflection.Metadata |  | 10.0.12 |
| third party added | System.Resources.Extensions |  | 10.0.12 |
| third party added | System.Security.Cryptography.Xml |  | 10.0.13 |
| third party added | ZstdSharp.Port |  | 0.8.8 |
| third party summary |  |  |  |

<a id="invantive-query-tool-26.0-to-27.0-more"></a>

### Meer Informatie

- [Invantive Query Tool 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/)

### Hoe deze notitie tot stand is gekomen

<div class="rn-small">

- None of the 12 flagged items was already in the first build of 26.0 (10 new, 2 partly new with narrowed text); the one exclusion on content was refuted and its item is published.
- Range: commits of origin/release-27.0 that are not reachable from the first build of release 26.0 (stamp 26.0.4, per repository). Commits that were ported to later builds of 26.0 are therefore included.
- Scope: commits that touch a project of the product, found through the solution and its project references; test projects are left out.
- Version stamp commits of the build pipeline are left out.
- A change whose changed lines are for 70 % or more already in the first 26.0 build is left out; items between 50 % and 70 % and all such exclusions were checked by reading the code of that build.
- A bug fix whose repaired lines were written by another commit of the same range is merged into its feature or left out.
- Texts were written from the commit messages and from the changes themselves; items carry a confidence.
- 1346 koppelingen tussen een wijziging en een broncommit worden vastgelegd.
- 66 uitsluitingen worden vastgelegd in het controleverslag bij de toelichting.

</div>

</div>

</div>

</div>

