Specify Filter Criterion Window
The Specify Filter Criterion window provides for inserting a new or modifying an existing criterion for a filter or an alert. This window opens when you click Add or Edit in either the Build Filter pane in the Filter file or the Build Alert pane in the Alert file. For example, you might build a filter for the System Tree Items table to show only items with more than some user-specified number of FRACAS incidents. The following table describes the options that can appear in the Specify Filter Criterion window.
|
Option
|
Description
|
||
|---|---|---|---|
|
Conjunction
|
The link from the previous criterion to the criterion to add next in a filter with multiple criteria. This field is unavailable if you are modifying a filter’s first selection criterion.
|
||
|
Table type
|
The table containing the field for which to specify one or more values. Related tables are also available for selection if applicable.
|
||
|
Data field
|
The field for which to specify one or more values.
|
||
|
Where
|
The aggregate function for selecting child records. You can limit the records shown in the parent table based on a count of the number of matching child records or the maximum, minimum, sum, or average value for a specified field for matching child records.
|
||
|
Child table type
|
The child table containing the field with the values by which to select records. All supported tables that are turned on in the Table Settings pane in the Project properties are available for selection.
|
||
|
Child field name
|
The child field on which to perform the aggregate function.
|
||
|
Child table filter
|
The filter to apply to the child table to limit the records that either count as matching or for which to evaluate the aggregate function.
|
||
|
Condition
|
The condition or logical operator to use in the selection criterion. The conditions available in the list depend on the field selected. For more information, see Valid Conditions for Each Field Type.
|
||
|
Value
|
The one or more values by which to select records. If the condition you have selected requires multiple values, such as a lower value and an upper value, labels indicate the type of values to enter. Depending on the field type, a selection control might be available for supplying values. Two examples follow.
• For a date field, a calendar control is shown. A Today checkbox is also available so that you can select it to use the date that the filter is applied as the field value. If you select Today, Value is set to Today and both this field and Use parameter become unavailable. If you select either in the last X days or in the next X days as the condition, Today is unavailable.
• For a text field that is attached to a list, a browse button is shown. Clicking this button opens a window in which you select the one or more values to include in the filter criterion. For more information, see Selection Window for List Values.
|
||
|
Use parameter
|
Indicates whether values are to be supplied when the filter is applied, which creates what is known as a parameterized query. This checkbox does not appear when you are building an alert criterion. When you selected it for a filter criterion, the Select Filter window opens when the filter is applied so that you can supply the parameter value. For a text field that is attached to a list, a window opens for selecting checkboxes for the one or more values to use. Because you can supply values for a criterion at run time, a parametrized query provides great flexibility. For more information, see Supplying Parameter Values at Run Time.
|
