Banner INB (9)‎ > ‎Banner How To's‎ > ‎

Querying a Form or List

Limit the number of options when attempting to select a value from a list in Banner.

The method outlined below will work to limit the available data from almost any form, including SSASECQ.

Example:
Active Departments:
Active departments are designated with an * before their name (description).  In order to limit your search to only active departments you can do the following:

In the Department List (STVDEPT)

Enter Query:
Click on the menu bar "Query" and "Enter", click the "Enter Query" icon:  or press the F7 key on your keyboard.

In the Description field enter:  *%

Execute Query:
Click on the menu bar "Query" and "Execute", click the "Execute Query" icon:  or press the F8 key on your keyboard.

The result will be a list of active departments designated by a preceding * in the description.


To further limit the results to a specific department you can enter part of the department name once again using the "%" wildcard.

For example:



when executed results in 



Correct Capitalization is Required

Comments