The SQL Queries Configuration allows you to create various stored SQL queries to select data from database tables and views.
To access SQL Queries configuration, navigate to the App Designer (Settings > Applications > App Designer) then select SQL Queries. The Create SQL queries that can be used in your forms and reports screen appears as shown below:
The options available on the SQL Queries configuration screen are described in the following table:
Action | Description |
New | Create a new SQL Query. |
Edit | Edit the selected SQL Query |
Search | The Search Bar in the top right corner can be used to filter the queries |
Delete | Delete the selected Query |