Create and Open a Query
The following article is a brief overview on creating and opening queries.
Create a New Query
- From the Query Designer landing page, click the New Query button. The New Query Information panel appears.
- In the New Query Information panel, specify a unique name and (optional) description for the query.
- Click the Select available connection drop-down list, select the appropriate connection, then click OK.
- Based on the setup of the connection, either a login, or the Add Tables panel appears.
- If the login panel appears, enter your credentials, and click Login. The Add Tables window appears.
- Proceed to the next step: Add a Table.
Note: The first time the Add Tables panel is accessed for a connection, the system builds a cache of available tables. The time required to load the tables varies, based on the number of tables. When the Add Tables panel is subsequently accessed for the connection, the process will be faster, as the tables are loaded from the cache.
Open an Existing Query
- From the Query Designer landing page, click the Open Query button. The Select Query panel appears, allowing the user to locate a query anywhere in the network. This defaults to the
Queries
folder location. - Select the query, and, click Open.