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.

1. Select Queries in the menu.

2. Click the Add Item button in the list app bar.

3. Type a title in the Title field.

4. Click in the Query field to open the Table and Fields Designer.

Figure 1 - Add a query

5. Click the Add Table button.

Figure 2 - Add Table button

6. Select the table name.

Figure 3 - Select table name

7. Click out of the Table Selector dialog box to close the window.

8. Select the table and drag to where you would like it to be positioned on the Designer.

9. Double click the field name.

Figure 4 - Add a query field

info

After selecting a field it will be added to the Query Builder.

10. Click the Save button in the Table and Fields Designer app bar.

Figure 5 - Save the query

11. Click the Fields tab.

Figure 6 - Fields tab

tip

All query fields will be listed on the Fields page and can be edited here.

12. Click the Save button in the form app bar.

Figure 7 - Save the Form

danger

Ensure to click the Fields tab to have all your query fields saved before committing the form.

Add Mulitple Fields

1. Double click the first field name.

2. Continue to double click the field names required for the query.

Figure 8 - Add multiple fields

Add a Multiple Table Query

Requirement

There needs to be a relationship between the tables, or the tables can be connected via another table.

1. Select Queries in the menu.

2. Click the Add Item button in the list app bar.

3. Type a title in the Title field.

4. Click in the Query field to open the Table and Fields Designer.

Figure 9 - Add a query

5. Click the Add Table button.

Figure 10 - Add Table button

6. Select a table.

7. Select table two.

Figure 11 - Add multiple tables

8. Click out of the Table Selector dialog box to close the window.

9. Select each table and drag to where you would like it to be positioned on the Designer.

10. In table one, double click the field names required for the query.

11. In table two, double click the field names required for the query.

Figure 12 - Add query fields

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.

12. Click the Save button in the Table and Fields Designer app bar.

Figure 13 - Save the query

13. Click the Fields tab.

Figure 14 - Fields tab

14. Click the Save button in the form app bar.

Figure 15 - Save the Form

tip

All queries you make using the Table and Fields Designer will require you to:

1. Click the Save button in the Table and Field's Designer app bar.

2. Click the Fields tab.

3. Click the Save button in the form app bar.