Discuss

Creating Database Queries

After you created your Database Connection, now it's time to setup a Database Query. The first thing we need to do is to create a new API Action (also known as Server Action). The API Actions are located under the API section of the Server Actions panel:

Creating an API Action

Right click API and select Add API Action:

Give it a name, we call our API Action - records:

You can see the API Action, loaded in a separate tab. There you will find its steps and that’s where we define all the server side logic that we need.

Creating a Database Query

Right click steps:

Open Database Actions and select Database Query:

Basic Options

Your existing database connection will be automatically selected in the dropdown. If you have more than one database connections defined, make sure select the one you need:

Click the Query Builder button:

Selecting Tables and Columns

Open the database tables drop-down and select a table:

If you want to add all the table columns to the query, you don’t have to do anything else - the table is already added. If you want to add specific columns to the query, just select them (using Ctrl + click / Cmd + click) and click the add button:

Query Conditions

You can add conditions/filters to your database query. Click the Conditions tab:

Here you can setup your query conditions, just select a column:

Then select a condition:

And add a value for the condition. This can be a dynamic value, or a static one. In our example we add a static value:

You can add multiple conditions or groups of conditions to your queries. Click the Add New Condition buton:

Just select how to combine these conditions - using the AND or OR operators. Clicking the operator toggles it from AND to OR.
Selecting AND will only return records which match both conditions, while using OR will return any records matching any of the conditions.
We set the operator to AND: