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