Filter Statement

The Add Filter Statement dialog box lets you create a statement that can be added as a filter for the selected asset field.

The Add Filter Statement dialog box presents the following options:

Select condition parameter type

Lets you select a parameter for the condition. You can choose to have a specific value for the condition or a special value.

Operator

Lets you select an operator from the list.

Specify Value

Lets you specify a value for the condition to be true.

For example, if 'Description' is the field that is to be used as a filter for an asset type, your filter statement could be as follows:

IF Description <Operator> <Value>

Table N-0 lists descriptions of the operators that can be used for creating a filter statement.

Table: Field filter statement operators

Operator

Operator Name

Filter Statement using sample values A, B, and the operator

Description

=

The equality operator

A = B

A must be equal to B

<=

The less than or equal operator

A <= B

A must be less than or equal to B

>=

The greater than or equal operator

A >= B

A must be greater than or equal to B