Possibility to run SQL query in Application Database

0
Hi all,   XPath and OQL are nice, but sometime necessary to run plain sql statement due to performance or functionality reason. I'm aware that MX app can be configured to use different db engines having different syntax.   However: is there any way to run direct sql query in local (not external!) database?   Regards Stan        
asked
2 answers
1

To run sql queries see this documentation: https://docs.mendix.com/howto/extensibility/howto-datastorage-api/#retrieving-objects-using-sql

 

View entities will offer a better solution for most use cases: https://docs.mendix.com/refguide/view-entities/

answered
0

Hi Stanislav,

You can check out my OQL series for mendix which is similar to SQL.

 

https://medium.com/@mohammad.saqib_1262/oql-series-part-1-introduction-to-object-query-language-in-mendix-213a0ff132a6

 

answered