Download Queries from Query Exchange

Query Exchange is an online depository of queries that allows users to access the online query depository, download selected queries to Query Designer, and utilize them in Excel. Query Exchange may be accessed from within either Query Designer or Excel. A user's ability to access Query Exchange is determined by the user's Application Configurator settings.

Note: Access to the Query Exchange component requires an internet connection.

Download a Query from Query Exchange

1. Query Designer:

In Query Designer, from the Query Designer Ribbon, select Home > Search Online. Query Exchange opens.

Excel:

• In Excel, access either the Build a Template or Formula Assistant panel, and select the appropriate GEXQ, GEXD, GEXS, or GEXI formula or tab.
• Click the Query Exchange button (). Query Exchange opens.

2. Select and/or type the appropriate search criteria, and click the Search, or, the Advanced Search button. The system lists all queries matching the search criteria.

3. To download:
• A single query: click the Install Query icon () beside the desired query. The Save As panel appears.

• If the connection associated with the selected query does not exist in Application Configurator, the Select a Connection panel appears prior to the Save As panel, allowing users to select a connection to be assigned to the query.

• Multiple queries: select the appropriate check box(es) and click the Download Selected Items button. The Browse for Folder panel appears.
4. In the Save As or Browse for Folder panels, if necessary, navigate to a different folder location and/or change the file name, then click Save or OK. The Query Retrieved panel appears, confirming the query has been saved to Query Designer.
5. In the Query Retrieved panel, click OK. Query Exchange reappears, allowing the user to select another query for downloading.
6. Repeat steps 2-5 as necessary, to download additional queries.
7. Once all queries have been downloaded, click the X to close Query Exchange.
• If Query Exchange was accessed from Query Designer, Query Designer reappears, and opens the last query downloaded through the Install Query icon.
• If Query Exchange was accessed from the Build a Template or Formula Assistant panel in Excel, the original panel reappears, and defaults to the name of the last query downloaded through the Install Query icon in the Query Name field.

Note: See GEXD Formulas, GEXQ Formulas, GEXI Formulas, and GEXS Formulas for the steps required to complete a formula.