Filtering the Contents of a Grid

To filter the contents of a grid

1 Start a process that uses grids or forms.

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, not including “where”.

You 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:

location = “location name

For example, enter this statement:

location = “main”

5 Click OK.

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

 


© 1998-2017 Sirsi Corporation