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 |
Banner 9 > Banner How To's >