The following filtering options are available to compare a parameter to its value:
Option |
Description |
---|---|
Equals |
The parameter has this exact value. |
Does not equal |
The parameter does not have this exact value. |
Is greater than |
The parameter value is greater than this value. |
Is greater than or equal to |
The parameter value is greater than or equal to this value. |
Is less than |
The parameter value is less than this value. |
Is less than or equal to |
The parameter value is less than or equal to this value. |
Is between |
The parameter value is between these two values (a second value must be entered if this option is selected). |
Is not between |
The parameter value is not between these two values (a second value must be entered if this option is selected). |
Contains |
The parameter value contains this value. This allows a string contained in another string to be included. |
Does not contain |
The parameter value does not contain this value. This allows all strings that contain another string to be excluded. |
Begins with |
The parameter value starts with this letter or string. |
Ends with |
The parameter value ends with this letter or string. |
Is like |
The parameter is similar to this value. |
Is not like |
The parameter is not similar to this value. |
Is null |
The parameter has no value. |
Is not null |
The parameter has any value. |
Is any of |
The parameter is any of the listed values. You can add more than one value by clicking the + that is displayed at the end of the condition line. This is the same as separate conditions compared using the OR operator. |
Is none of |
The parameter is not any of the listed values. You can add more than one value by clicking the + that is displayed at the end of the condition line. This is the same as separate conditions compared using the NOT OR operator. |
Is blank |
The parameter has a value that is empty. |
Is not blank |
The parameter has any value that is not empty. |