Running Queries

Using the HTML, Excel, or XML links on the Query Manager search page, you can run a predefined query from your browser and view it online in a new browser window. These links are useful when you run the same query multiple times with different runtime prompt values and then compare the results of the queries.

If you want to run the query that you haven't saved, you can use the Run page in the Query Manager.

To run a query:

  1. Select Reporting Tools > Query > Query Manager.

    The Query Manager Search page appears.

  2. Search for a query using the basic or advanced search function.

    Both search types enable you to use the following search by criteria: access group name, description, folder name, owner, query name, type, uses field name, and uses record name. The basic search allows you to search using the begins with condition. The advanced search enables you to perform a progressively narrower search by using one or more search by criteria and selecting from a broad choice of conditions. These are instructions on using search by criteria:

    • If you know the entire name of the query that you want to run, select Query Name from the Search By drop-down list, and then enter the query name in the Search By field.

      If you do not know the name of the query and want to search through a list of queries, leave the Search By field blank and click the Search button to display a list of up to 300 queries.

      Perform a partial search by entering part of the search string in the Search By field.

    • To search using any other search by criteria, select the appropriate item from the Search By drop-down list, and then enter the search string in the field.

  3. To perform an advanced search, click the Advanced Search link on the Query Manager Search page.

    On the Advanced Search page, select the appropriate search by criteria and conditions, and then enter a search string in each of the corresponding fields.

  4. Click the Search button to display a list of queries that match your search criteria.

    The Search Results page appears. The results list all the queries that match the search criteria. The following information appears:

    • Query name

    • Query description

    • Owner (public or private)

    • Folder

  5. Scroll to the name of the query that you want to run.

    By default, only the first 30 queries appear on the page. To see more of the list, click the navigation buttons and links located on the header bar.

    To display 100 of the queries, select View 100 and use the scroll-bar to view the remainder of the list.

  6. To run a query, use the following links on the row of the query:

    • HTML: Click to generate an HTML version of the query.

    • Excel: Click to download the query to a Microsoft Excel spreadsheet.

    • Schedule: Click to schedule a time for the query to run.

    • XML: Click to download query result to browser as webrowset format. There are options that enable you to open, save, or cancel the downloaded file.

Note: If a Query—that is used as a data source for BI Publisher— is run through Reporting Tools, Query, Query Manager, the BI Publisher-related prompts do not appear. The normal basic table-formatted query results are generated.

See Scheduling Queries.