The Select Action panel has the following functions:
On the left side of the panel:
Action Name: Used to name the query.
Choose Source: Allows you to select the data source.
In the upper right corner of the panel:
Relations: You can create queries by adding and linking data tables.
Fields: Allows you to select fields from data tables.
Filter: Helps you filter the data.
Sort Order: Allows you to determine the sorting order of the data.
Preview: Allows you to preview the query and view the results.
Code View: Allows you to view the technical query structure generated by the system for the created query. It is used to examine how the query is created in the background and to perform technical verification.
Enable Pagination: Enables query results to be retrieved in pages (pagination). It is used to improve performance in large data sets and to ensure that data is loaded in chunks.
Convert to SQL Action: Allows you to convert your query to an SQL query.
