Filter Form
The Filter Form is illustrated below.

The filter screen allows the user to restrict the records that are displayed on the screen. Filters can be created and then saved to be used over and over. Each user can create as many filters as they like and save them for future use. When the filter screen loads, the combo box at the top of the screen will show all the filters that the current user has saved for the current screen.

  • The fields that appear on this screen are defined below.

    Saved Filters
         		This combo box is located at the top of the screen and is loaded with any saved filters. These filters will only belong to the current user for the screen being filtered. The user can select saved filters and then press Finish to quickly apply common filters.
    		Clicking the Delete Filters Button at the top of the screen will delete the currently selected filter.
    Field
    		The field column is a dropdown that contains all the columns that you can filter on for the current screen you are wanting to filter.
    Operator
    		The Operator column is a dropdown that contains the legal operators for the currently selected Field. These operators change depending on the Field that is selected.
    Value
    		Value is a dropdown that is filled with all the values for the currently selected Field that are currently stored in the database. If the user has chosen the LIKE operator in the operator dropdown, this column will not have a dropdown attached and will allow the user to freely type in the column using any of the predefined LIKE Operators. There is a list of these Operators Here.
    Value2
    		Some Fields like dates and numeric fields give you the choice of selecting the "BETWEEN" Operator. When BETWEEN is selected, for example on a date field, the Value2 field becomes enabled allowing you to filter between a date range.
    AND/OR
    		The AND/OR column is the last column in the grid. This allows you to tie together multiple rows in the grid. For example, you may want to have a filter like this; Task Date = 7/5/2000 AND Milepost = 1. Using this example, The first row in the grid would look like this, Task Date = 7/5/2000 AND

    The second row in the grid would look like this, Milepost = 1
    Buttons - found at the top of the Filter screen.
    Selecting the Apply Filter button will apply the filter to the current screen you are wanting to filter. This button will not save the filter so if you want to save it, be sure to press the save Filter Button before applying the filter.
    Pressing the clear button will clear the grid of any records.
    If you select a row in the grid by selecting the record selector on the left side of the grid and then press the Delete Row button, the row will become grayed out effectively removing it from the filter. If you save the filter, any rows grayed out will not be saved with the filter. If you press the finish button to apply the filter, any rows that are gray will not be used in the filter.
    Selecting the save button will bring up a dialog asking you for the name you would like to save the filter under. After providing a name, the current filter will be saved and added to the combo box at the top of the screen.
    Selecting the Cancel Button will dismiss the filter screen without applying a filter.

    Back

    		•