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: ![]() In the Description field enter: *% Execute Query: Click on the menu bar "Query" and "Execute", click the "Execute Query" icon: ![]() 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 |
Banner 9 > Banner How To's >