You can use SQL statements to filter the contents of a grid to return contents that match certain criteria. (For example, if you are interested only in certain MARC tags in Cataloging’s Syntax and Validation grid, you can filter the grid to display only those MARC tags with that criteria.)
In order to filter the contents of a grid or form, you must understand basic SQL statements. (For more information about SQL statements, see your Sybase or Microsoft documentation. For more information about using the “where” clause, see “Using SQL Statements in the Table Editor” in the “Horizon Table Editor” section of the “Getting Started” chapter of the System Administration Guide or talk to your system administrator.)
Some grids have default filters that cannot be changed. In addition, your system administrator may have previously set up restrictions by which the grid may be filtered. (For example, the system administrator can set up the grid to display specific MARC tags.) If a filter has been set up previously, any filter you create will not override the filter but act as a secondary filter.
This section explains these topics:
• | Filtering the Contents of a Grid |
• | Turning Off a Filter in a Grid |
© 1998-2017 Sirsi Corporation