...
A SQL template is a parameterized query for retrieving data from the database. It represents one or more SQL statements that point to the data. Click on a SQL data set to view the templates that were used to query the SQL database.
You can perform the following actions.
...
Using the Data Sets Toolbar
- Click the refresh button to load any changes to the SQL template.
- You can download the data set as a JSON file
- Click the download icon and specify an encoding option (default is UTF-8).
- Click Download to proceed.
- Click the trash icon in the SQL Data Set toolbar and confirm that you want to delete the data set when prompted. If the data set contains record types that do not reference or are not referenced by another component, you can enable the Delete orphaned record types option to ensure that the data set is completely removed.
- Click the Select drop-down to show the search field. Enter a search term and press ENTER to search the data set. Searches return SQL templates that match the search terms exactly; enter keyword phrases to narrow your search.
Adding SQL Templates
You can add, edit, and move SQL templates in the data set.
...