Skip to main content
Conga Support

Filter Operators

 

This page applies to: Analytics Add-on module

  Applicable data types are text and numeric values. Numeric values include dates.

Operator

Description

Applicable Data Type(s)

General Filtering

Equal To

Equal to a single alphanumeric or string value

Text & Numeric

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

Text & Numeric

Between

Between Variable 1 and Variable 2 where variables are legitimate parameters such as dates

Numeric

Not Between

Not between Variable 1 and Variable 2 where variables are legitimate parameters such as dates

Numeric

In List

One or more alphanumeric or string values

Text & Numeric

Not In List

Two or more alphanumeric or string values

Text & Numeric

Is Null

Record contains no value for selected attribute; therefore, no parameter can be set.

Text & Numeric

Is Not Null

Record contains any value; therefore no parameter can be set.

Text & Numeric

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 a 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 ends with a 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 record that is not an empty string

Text

Equals Column

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

Text & Numeric

Different From Column

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

Text & Numeric

Greater Than Column

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

Numeric

Greater Than or Equal to Column

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

Numeric

Less Than Column

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

Numeric

Less than or Equal To Column

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

Numeric

Minimum Date

Will find the earliest date value available.

Numeric

Maximum Date

Will find the latest date value available.

Numeric

Link to Filter

Allows the user to select one value on the report page and have it used across multiple filters. Example: Have Company Location set as a User Prompt filter and link the Contract Address to it. When the user selects the company location, the contract address will be set to the same value.

Text & Numeric