Question

Link SQL Database

0

Where in Mendix do you access SQL entities like a table..?

asked 2019-10-24

Kobus Pretorius

3 answers

Mike Kumpf · Answer 1 · 2019-10-24

You can use a Data View, Data Grid, List View or Template Grid on a page to display either one or multiple rows from a given entity.

Miroslav Samoylenko DO NOT USE · Answer 2 · 2019-10-24

Look for OQL module is you are a big fan of SQL.

Tim v Steenbergen · Answer 3 · 2019-10-24

Not. That is kind of the idea of a LowCodeDevelopment platform. Mendix does this for you with the Mendix Business Server, aka the MBS.

You can check out what the MBS does for you by checking out the ConnectionBus-logs. To do that, in Mendix Studio Pro go to your console panel, click on the dropdown “Advanced”, click “Set log levels” and set the ConnectionBus_Retrieve to trace. Now do some actions in your local running app and then check the console log. You now see all SQL-retrieve statements given by the MBS to the underlying database engine.