Like what you see? Have a play with our trial version.

Operator

Description

Type *

 

General Filtering

 

Equal to

Equal to a single alphanumeric or string value

 

Greater than

Greater than a single alphanumeric or string value

Numeric

Greater than or equal to

Greater than or equal to a single alphanumeric or string value

Numeric

Less than

Less than a single alphanumeric or string value

Numeric

Less than or equal to

Less than or equal to a single alphanumeric or string value

Numeric

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.

Numeric

Not Between

Not between variable 1 and variable 2 these will need to be legitimate parameters such as date, age etc.

Numeric

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 any value. No Parameter can be set

 

 

Advanced Filtering

 

Contains

Records that contain text that matches the input value

Text

Does Not Contain

Records do not contain text that matches the input values

Text

Starts With

String starts with letter or letters

Text

Does Not Start With

Records do not contain text at the start of the string that ends with the input values

Text

Ends With

String end with letter or letters

Text

Does Not End With

Records do not contain text at the end of the string that ends with the input values

Text

Is Empty String

A record that is an empty string

Text

Is Not Empty String

A String that is not empty

Text

Equals Column

The records in the filtered column will have values equal to the values of an alternate column

 

Different From Column

The records in the filtered column will not have values equal to the values of an alternate column

 

Greater Than Column

The records in the filtered column will have values greater than the values of an alternate column

Numeric

Greater Than or Equal to Column

The records in the filtered column will have values greater than or equal to the values of an alternate column

Numeric

Less Than Column

The records in the filtered column will have values less than the values of an alternate column

Numeric

Less than or Equal To Column

The records in the filtered column will have values less than or equal to the values of an alternate column

Numeric

Minimum Date

This option will find the earliest date value available.

Numeric

Maximum Date

This option will find the latest date value available.

Numeric

Link to Filter

This filter allows the user to select one value on the report page and have it used across multiple filters. For example have Athlete Region set as a User Prompt filter and link the Camp Region to it. This will mean that the user selects the Athlete Region and the Camp Region will be set to the same value.

 


* The Type column is only specified if the operator is not common across all data types. Numeric Types include date data types.