In this topic you will learn how to Search Using the CONTRACT_SEARCH_LINES Query.
NOTE: To run this query you must know the Vendor Contract Number.
Scenario
Your department has forwarded a request for an item to you. The item is on State contract. You know the Vendor Contract Number and will run the CONTRACT_SEARCH_LINES query to retrieve the contract line information.
Queries are predefined in the system. A portion of the query name will be entered in order to retrieve the information needed. The Query Name field is not case sensitive so upper, lower or mixed case letters can be used.
You can run your query to one of two formats: HTML or Excel. Queries should be run to HTML first to ensure all results are returned.
Click the HTML link. This will open a new window.
Enter the desired information into the Contract ID: field. Enter "000012".
NOTE: If no results are retrieved, make sure your data was correctly entered and re-run the query.
Use the arrows in the scroll area to move from page to page.
Click the View All link to view all lines of the contract. This process may take a few minutes depending on the number of lines the contract contains.
Press [Ctrl+F] search for an item.
Enter the desired information into the Find field. Enter "2B0164".
In this example, 2B0164 is a Vendor Item ID number.
Click the Next button to view the next match until all matches have been viewed or you have found the match you want.
Click the Open button to view the Excel spreadsheet. This will open a new window.
Click the Close button to return to your Search results.
Click the Close button to return to Query Viewer.
The system also allows you to run your query and display the results directly into an Excel spreadsheet.
Click the View Results button.
NOTE: If no results are retrieved, make sure your data was entered correctly and re-run your query.
Click the Close button to return to your Search results.
Click the Close button to return to Query Viewer.
Query Results
The query results display at the bottom of the page with the first 100 lines available for view. In this example 1029 lines are retrieved, but only the first 100 display.
The system automatically highlights and scrolls to the first match. Matches are highlighted in blue. In this example 5 matches were identified. Click Next to view additional options.
Once all matches have been viewed, a message displays on the Find toolbar stating the last match has been reached.
Output Query Results
You can download the query results in either of the following:
Excel Spreadsheet - The results will display on a web page in Internet Explorer. The Excel functionalities (Data, Sort and Filter, Format, etc.) are available in the web page.
CSV Text File - The results download into Microsoft Excel. The Excel functionalities (Data, Sort and Filter, Format, etc.) are available in the spreadsheet.
The data contained in the spreadsheet can be sorted or filtered as needed. You may hover your mouse over the lines between the column headings to resize the column widths. The file can also be saved to your computer.
The data contained in the spreadsheet can be sorted or filtered as needed. You may hover your mouse over the lines between the column headings to resize the column widths. The file can also be saved to your computer.
This completes Search Using the CONTRACT_SEARCH_LINES Query.
Queries are predefined in the system. A portion of the query name will be entered in order to retrieve the information needed. The Query Name field is not case sensitive so upper, lower or mixed case letters can be used.
Enter the desired information into the Contract ID: field. Enter a valid value e.g. "000012".
NOTE: If no results are retrieved, make sure your data was correctly entered and re-run the query.
Enter the desired information into the Find field. Enter a valid value e.g. "2B0164".
In this example, 2B0164 is a Vendor Item ID number.
