In this topic you will learn how to Run a Predefined Query to Query Viewer.
Scenario
In this example, you will run the APY3001 _AP_VENDOR_SUMMARY query to retrieve a list of approved vendors.
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.
A total of 109 options were returned using the Advanced Search method.
Scroll down through the list of queries to find the APY3001_AP_VENDOR_SUMMARY query.
NOTE: It is recommended that you run your query first to HTML to determine the number of result rows returned. Running your query to HTML will return all available results.
NOTE: A list of approved suppliers will be retrieved and displayed below the View Results button.
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.
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.
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.
The system retrieves a list of query names that begins with APY. A total of 104 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.
HTML results can be downloaded to an Excel spreadsheet. This will open a new window, and allow you to manipulate the data, move columns, hide columns, etc.
If you want to change column widths, sort data, add formulas, or utilize other features available in Excel, you must enable editing for your spreadsheet.
You may save the query results to a network drive for later use, or you may print the results.
CSV is an abbreviation for Comma Separated Value file. This type of file is not generally used by end users, but is available. XML File is not available for general use.
The View All link displays all 31,065 suppliers at one time.
NOTE: It may take a few minutes to process your request when you search has retrieved a large number of results. The Processing indicator will display in the top right corner of the page.
The total number of approved suppliers retrieved displays above the Description column. In this example, 31,065 suppliers were retrieved. The first 100 suppliers are displayed in ascending order by Supplier ID number.
NOTE: The number of approved suppliers will vary as new suppliers are added or existing suppliers are unapproved.
The arrows allow you to navigate from page to page. The right arrow allows you to view the next 100 suppliers. The Last link allows you to view the last 100 suppliers. The left arrow allows you the view the previous 100 suppliers, and the First link displays the first 100 suppliers.
This completes Run a Predefined Query to 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.
You must enter all or part of the query name into the Search By field.
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