9.18.5

Stable

April 04, 2023

Mendix Studio Pro is our low-code IDE for professional developers. It's a powerful visual model-driven development environment to build apps on the Mendix Platform. With Studio Pro you can easily create, change, integrate, test and deploy your applications, all in one place. Moreover, you can manage branch lines and security as well as extend your app with custom code using the built-in editors. Click 'Download Studio Pro' to get the installer for free (Windows OS required*). Learn more about the installation and the Studio Pro capabilities in our documentation. Not a professional developer? Learn How Mendix supports different developer profiles .Before installing, please read the Release Notes to learn about improvements, bug fixes, backwards compatibility, breaking changes and known issues. *If you are using a Mac, check out these instructions first.

Release Notes - **Release date: April 4th, 2023** ### Improvements * We added support for the following database versions: * MariaDB 10.11 * Microsoft SQL Server 2022 * Oracle 21c * PostgreSQL 15 ### Fixes * We fixed an issue where a reference selector with an XPath data source using a **Constrained by** condition incorrectly cleared its value if it was inside a data view listening to a widget and the selection of that widget changed. (Ticket 162340) * We fixed an issue where historical dates stored in a non-localized date attribute were off by several seconds in certain time zones. (Ticket 165972) * We fixed an issue where a newly created object displayed in the client could not be retrieved over an association in a microflow. (Ticket 170969) * We fixed an issue where pluggable widgets (such as [Data Grid 2](https://docs.mendix.com/appstore/modules/data-grid-2/)) with a microflow or nanoflow data source sorted an AutoNumber attribute alphabetically instead of numerically. (Ticket 172287) * We fixed an issue where fields in the **App Settings** dialog box were not visible when the dialog box opened. (Ticket 172556) * We fixed an error that appeared when you clicked quickly on a tree control cell. (Ticket 172770) * We fixed an issue that caused an error in the runtime and the client if a pluggable widget was retrieving data over an association that was not accessible for the current user. (Tickets 173477, 173663) * We fixed an issue in published OData services where comparing a number with null resulted in a "400 Bad Request" message. (Ticket 175746) * We fixed an issue in consumed OData services where retrieving an external entity with the XPath `[NULL = NULL]` (or an XPath using variables with the same effect) resulted in an error. (Ticket 175746) * We fixed an issue where the list view search did not work if an AutoNumber attribute was included in the search. (Ticket 176396) * We fixed an issue in consumed OData services that caused an error to occur when filtering on Boolean attributes in a data container widget. (Ticket 176502) * We fixed an issue with consumed OData services where retrieving the associated entities that had equivalent key fields and values led to unpredictable query results. (Ticket 177537) * We fixed an issue where the sorting of a microflow or association data source in a pluggable widget (for example, Data Grid 2) resulted in unnecessary network requests. (Ticket 177792) * We fixed an issue in published OData services where serialization stopped when an error occurred, with no way for the client to discover that. Now, there is an error appended to the resulting JSON. * We fixed an issue that caused an association property of a pluggable widget to malfunction if it was linked to a data source and configured with more than one association step. * We fixed an issue where importing a module from Studio Pro [9.17](https://docs.mendix.com/releasenotes/studio-pro/9.17/) or below did not correctly convert a page parameter if its entity was defined in a domain model outside of the imported module. * We replaced a third-party dependency to prevent a potential security vulnerability. * We fixed an error that appeared when you changed the access rules of an entity. ### Deprecations * We dropped support for MariaDB 10.2, as it is no longer supported by the vendor. ### Breaking Changes * We removed support for the `FileID` parameter in the File API.