In this topic you will learn how to Run a Predefined Query from Query Viewer.
Scenario
In this example, you will run the APY3001 _AP_VENDOR_SUMMARY query to retrieve a list of approved vendors.
You can access existing, predefined queries (Public and/or Private) from the Query Viewer page. Public queries are available to all end users with query access. Private queries are queries associated only with your UserID. Private queries can be created or can be amended Public queries. Creating and amending queries are discussed later in this manual.
Enter the desired information into the field. Enter "APY%".
A total of 107 options were returned using the Advanced Search method.
Scroll down through the list of queries to find the APY3001_AP_VENDOR_SUMMARY query.
Click the View Results button.
NOTE: A list of approved vendors will be retrieved and displayed below the View Results button.
HTML results can be downloaded to an Excel spreadsheet. Downloading results into an Excel spreadsheet will allow you to manipulate the data, move columns, hide columns, etc.
Click the Excel Spreadsheet link. This will open a new window.
You may change column widths, sort data, add formulas or utilize any other features available in Excel. You may save the query results to a network drive for later use, or you may print the results.
The "wildcard" can be utilized to focus your search. The wildcard is a percent (%) sign. The wildcard may be placed before, in the middle, at the end, or bracket the query name. For example:
1. If the wildcard is placed at the end of the query name, APY%, the system will retrieve query names that begin in APY.
2. If the wildcard is placed in the middle of the query name, %APY%AP, the system will retrieve query names that contain APY somewhere in the name and ends with AP.
3. If the wildcard brackets the query name %APY%AP%, the system will retrieve query names that contain APY and AP somewhere in the query name.
NOTE: It is recommended that you run your query first to HTML to determine the number of options returned. Running your query to HTML will return all available results. Excel contains a finite number of rows and cannot always display large numbers of results.
The system retrieves a list of query names that begins with APY. A total of 102 results were retrieved, with the first 30 displaying at the bottom of the page.
Query results can be displayed in two formats: HTML and Excel. Both options will be demonstrated in this example, beginning with the HTML option.
NOTE: Results run to HTML can only be viewed as displayed. If you want to be able to manipulate the results, download your results directly to Excel.
The total number of approved vendors retrieved display above the Description column. In this example, 30,544 vendors were retrieved. The first 100 vendors display in ascending order by Vendor ID number.
The right arrow allows you to view the next 100 vendors. The Last link allows you to view the last 100 vendors. The left arrow allows you to navigate to the previous page, and the First link displays the first 100 vendors.
The View All link displays all 30,544 vendors at one time.
NOTE: It may take a few minutes to process your request when your search has retrieved a large number of results. The Processing indicator will display in the top right corner of the page.
You must enter all or part of the query name into the Search By field. The Search By field is not case sensitive. You may enter information in upper, lower or mixed case.
CSV is an abbreviation for Comma Separated Value file. This type of file is not generally used by end users, but is available.
The XML File option is not available for use at this time.
The "begins with" operand cannot be changed on the Query View page, but can be changed using the Advanced Search link. The Advanced Search link offers an alternative method of retrieving information.
This completes Run a Predefined Query from Query Viewer.
You can access existing, predefined queries (Public and/or Private) from the Query Viewer page. Public queries are available to all end users with query access. Private queries are queries associated only with your UserID. Private queries can be created or can be amended Public queries. Creating and amending queries are discussed later in this manual.
Enter the desired information into the field. Enter a valid value e.g. "APY%".
The "wildcard" can be utilized to focus your search. The wildcard is a percent (%) sign. The wildcard may be placed before, in the middle, at the end, or bracket the query name. F
You must enter all or part of the query name into the Search By field.