Skip to main content

Run a Query

Last updated 8/04/2022

While you are creating your queries in the Table and Fields Designer you can run the query and see the results at any time. This will allow you to change your instructions if the data returned is not what you were looking for. The data returned can be filtered and sorted.

Run a SELECT Query​

You use SELECT queries to retrieve and display the data. This data can then be supplied in a report.

Prerequisite

Give your query a title and open the Table and Fields Designer.

Steps

  1. Click the Add Table button.

Add Table Button
Figure 1 - Add Table button

  1. Select a table.

Select a Table
Figure 2 - Select a table

  1. Click outside of the Table Selector dialog box to close the window.

  2. Select the table and drag to the desired position on the Designer.

  3. Double click the field names required for the query.

  4. Click the Run button.


Select Fields and Run the Query
Figure 3 - Select fields and run the query


info

Five will remove the Query Builder and show the Results.



Result Set
Figure 4 - Result set

Hide the Results​

The results can be hidden again so you can return to the Query Builder and continue to work on your query.

  1. Click the Hide Results button.

Hide Results Button
Figure 5 - Hide Results button

View the Results​

To view the current results:

  1. Click the View Results button.

View Results Button
Figure 6 - View Results button


info

You will need to of run your results at least once to have the current results.


If you have added extra fields or conditions to your query:

  1. Click the Run button.

Run Button
Figure 7 - Run button


tip

Your, query, query fields, and form need to be saved.