SQL Query Designer
The SQL Query Designer is used to design a custom SQL query to pull information from a database. It can be opened via the Settings pane when extracting data from a database.
- Tables: Lists all tables and stored queries in the database.
- Custom Query: Displays the query that retries information from a database. Each database type has their own version of the SQL query language. To learn how to build your own query, please refer to your database's user manual.
- Test Query button
: Click to test the custom query to ensure it will retrieve the appropriate information. - Results: Displays the result of the SQL query when clicking on Test Query.