When defining a filter initially set the operator drop down to the desired value. The options within the drop down will vary based upon the type of field that the filter is to be applied to.
Possible values for the operator include:
Operator | Description |
---|---|
Equal to | Equal to a single alphanumeric or string value |
Greater than | Greater than a single alphanumeric or string value |
Greater than or equal to | Greater than or equal to a single alphanumeric or string value |
Less than | Less than a single alphanumeric or string value |
Less than or equal to | Less than or equal to a single alphanumeric or string value |
Different from | Not equal to or different from a single alphanumeric or string value |
Between | Between variable 1 and variable 2 these will need to be legitimate parameters such as date, age etc. |
Not Between | Not between variable 1 and variable 2 these will need to be legitimate parameters such as date, age etc. |
In List | One or more alphanumeric or string values |
Not In List | Two or more alphanumeric or string values |
Is Null | Record contains no value for selected attribute. No Parameter can be set |
Is Not Null | Record contains a value for selected attribute. No Parameter can be set |
Like | Records that contain the same letter or letters. |
Starts With | String starts with letter or letters |
Ends With | String end with letter or letters |