Creating Database Queries

Original guide · All levels · Server Connect

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 loca

Creating an API Action

Right click API and select Add API Action:

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

Step 5

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:

Step 13

Step 14

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:

Step 19

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:

Step 21

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: