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.
 
  • Last Topic Update: 27, June, 2017 06:10 AM
  • Last Published: 23, May, 2019 01:55 PM