Skip to main content

Create and Open a Query

The following article is a brief overview on creating and opening queries.

Create a New Query

  1. From the Query Designer landing page, click the New Query button. The New Query Information panel appears.
  2. NewQuery
  3. In the New Query Information panel, specify a unique name and (optional) description for the query.
    1. Click the Select available connection drop-down list, select the appropriate connection, then click OK.
    2. Based on the setup of the connection, either a login, or the Add Tables panel appears.
  4. If the login panel appears, enter your credentials, and click Login. The Add Tables window appears.
  5. 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.

  6. Proceed to the next step: Add a Table.

Open an Existing Query

  1. 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.
  2. Select the query, and, click Open.

Was this article helpful?

We're sorry to hear that.

Powered by Zendesk