Question

Can i use OQL to set values in mendix database

0

I see there is no update or set for oql mendix documentation is it not supported ?

asked 2021-04-30

JP

1 answers

Alexander Keßler · Accepted Answer · 2021-05-12

Hi John,

currently, Mendix does only support OQL for reading data from the database.
In fact, if you retrieve data via OQL, it will create copies of the database values and you will not get the “real” Mendix objects.

So as you can see, OQL support is limited, but can increase performance a lot, if you have to retrieve data via complex queries. For creating or updating database entries, you should only use nano/- microflows, or JavaScript/JAVA via the respective Mendix Client API calls.