The Select Action panel has the following functions:
On the left edge of the panel:
- Action Name (1): Used to name the query.
- Choose Source (2): Allows you to select the data source.
At the top right of the panel:
- Relations (3): You can create queries by adding and associating data tables.
- Fields (4): Allows you to select fields from data tables.
- Filter (5): Helps you filter the data.
- Sort Order (6): Allows you to determine the sort order of the data.
- Preview (7): You can preview the query and view the results.
- Convert to SQL Action (8): Allows you to convert the query you created into a SQL query.
In the bottom right corner:
- CREATE (9): Used to save the query.
