Filtering the Contents of a Grid

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 requests that are from a specific location, you can filter the Closed Stack Request List to display requests with that criteria.)

In order to filter the contents of a grid, you must understand SQL statements. (For basic SQL information, see SQL Basics . For more specific information, see your Sybase or Microsoft documentation.)

Some grids in Closed Stack Access have default filters that cannot be changed. In addition, your system administrator may have previously set up restrictions that a grid may be filtered by. (For example, the system administrator can set up the Closed Stack Request List grid to display requests from a specific location.) 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

To filter the contents of a grid

1 Start a Closed Stack Access process.

Horizon displays the grid for the process you chose.

2 Click the Grid menu options button ().
3 Choose Filter Grid.

Horizon displays the Select filter for grid contents window:

4 Enter the SQL statement you want to use to filter the rows.

Yo should not include “where” in your SQL statement, since Horizon automatically adds it to the statement when you click OK.

Here is an example:

To filter a grid using this

Do this

The location column

Enter this statement, including spaces and quotation marks:

csa_location =location name

For example, enter this statement:

csa_location = “main”

Note: To see a list of column names for a specific grid, see Closed Stack Access Grids and Columns.

5 Click OK.

Horizon displays only the rows that match the “where” clause parameters.

To turn off a filter in a grid

Do one of these options:

If you are finished with your task, close the grid that you filtered.
When you open the grid again, the contents is not filtered.
If you want to clear the filter without closing the grid, follow these steps:
1 Click the Grid menu options button ( ) again.
2 Choose Filter Grid.
3 Horizon displays the Select filter for grid contents window.
4 Delete the SQL statement you entered.
5 Click OK.
6 Horizon redisplays all the rows in the grid.

 


© 1998-2017 Sirsi Corporation