The OMNIA Platform system queries are developed in SQL (Postgres), but external ones may be coded in any language the modeler intends and until now the code expression presented was SQL by default to any Query. This expression is then sent to the ReadList Data Behaviour and since it runs externally the user must code the query according the external system’s requirements.

From now on modelers can switch the language of external advanced queries, making it easier to code. Currently we’re supporting the three most used and requested languages, SQL, JSON and XML, adding the possibility to also select plain Text. This only affects code formatting, which means the external queries may be coded in any other language that the external system supports.

You can select the language of an external query when you’re adding or editing a query:

Changing the language changes syntax highlights, code completion and other features the Code Editor supports. For example:

JSON:

XML: