Create Queries
Last updated 6/04/2022
Add a Single Table Query
You can use a query to request data from the database. Five will give you access to all your tables held in the database in the Table and Fields Designer. Selecting a table will make it available on the Designer for you to work with and build out your queries.
Select Queries in the menu.
Click the Add Item button in the list app bar.
Type a title in the Title field.
Click in the Query field to open the Table and Fields Designer.
- Click the Add Table button.
- Select the table name.
Click out of the Table Selector dialog box to close the window.
Select the table and drag to where you would like it to be positioned on the Designer.
Double click the field name.
info
After selecting a field it will be added to the Query Builder.
- Click the Save button in the Table and Fields Designer app bar.
- Click the Fields tab.
tip
All query fields will be listed on the Fields page and can be edited here.
- Click the Save button in the form app bar.
warning
Ensure to click the Fields tab to have all your query fields saved before committing the form.
Add Mulitple Fields
Double click the first field name.
Continue to double click the field names required for the query.
Add a Multiple Table Query
Requirement
There needs to be a relationship between the tables, or the tables can be connected via another table.
Select Queries in the menu.
Click the Add Item button in the list app bar.
Type a title in the Title field.
Click in the Query field to open the Table and Fields Designer.
- Click the Add Table button.
Select a table.
Select table two.
Click out of the Table Selector dialog box to close the window.
Select each table and drag to where you would like it to be positioned on the Designer.
In table one, double click the field names required for the query.
In table two, double click the field names required for the query.
info
While the Table Selector dialog box is open, you can choose all of the required tables or return later if you need to add another table to your query.
The tables can be moved around the Designer until you are happy with the design layout.
For linked tables, Five will create the relationship line and the relationship type.
- Click the Save button in the Table and Fields Designer app bar.
- Click the Fields tab.
- Click the Save button in the form app bar.
tip
All queries you make using the Table and Fields Designer will require you to:
Click the Save button in the Table and Field's Designer app bar.
Click the Fields tab.
Click the Save button in the form app bar.