Query Searches Using Multiple Fields

Query searches allow you to locate and extract data from the database such as values for a field, and then use the data in a Banner page.

Query searches may be performed in Validation pages (search pages) or from certain fields in Application pages that have a Search button. The techniques for refining your search are the same in all pages.

You may use wild card characters, which stand for unknown characters, to refine your searches. There are two wild card characters in Banner, the percent sign (%) and the underscore (_):

% = any group of characters

_ = any single character

The following example shows how to query for an Account code using a multiple field query search. The additional filter reduces the number of records displayed as a result of the search.

1.  In the Search field, type FTVACCT and press the ENTER key to open Account Code Validation.

2.  Click the Filter button.

3.  Type your Chart code in the Chart of Accounts field. This will limit the search to only your Chart.

4.  Type %1 in the Account Code field. By using the percent sign (%), you can search for all the expense Account codes that begin with 1. These are all non-payroll expense account codes.

5.  Type %Office% in the Title field. By using the percent sign (%), you can search for all titles that contain that word.

     NOTE: Most query searches are case sensitive.

6.  Click the Go button. You should now see all non-payroll expense Account codes that also contain the word “Office” in their titles.

7.  Click the Close button to return to the main menu.

     NOTE: If you originated the search from an Application page, you may double-click the desired code into the Application page’s field.

Click the print icon to print this page.

Last Updated: November 2, 2018