Operator Glossary

Equals

Checks if the values in the comparator fields are equal. If yes, then the condition becomes true and all the rows that satisfy this condition are filtered.

Numeric or String

Not equals

Checks if the values in the comparator fields are not equal. If the values are not equal, then the condition becomes true and all the rows that satisfy this condition are filtered.

Numeric or String

Greater Than

Checks whether values in the column selected in the first dropdown are greater than the value entered in the right side field. If yes, then the condition becomes true and all the rows that satisfy this condition are filtered.

Numeric

Less Than

Checks whether values in the column selected in the first dropdown are less than the value entered in the right side field. If yes, then the condition becomes true and all the rows that satisfy this condition are filtered.

Numeric

Greater than or equals

Checks whether values in the column selected in the first dropdown are greater than or equal to the value entered in the right side field. If yes, then the condition becomes true and all the rows that satisfy this condition are filtered.

Numeric

Less than or equals

Checks whether values in the column selected in the first dropdown are less than or equal to the value entered in the right side field. If yes, then the condition becomes true and all the rows that satisfy this condition are filtered.

Numeric

Contain

Checks whether values in the column selected in the first dropdown contain the value entered in the right side field. If yes, then the condition becomes true and all the rows that satisfy this condition are filtered.

String

In

Checks whether the value(s) entered in the right side field is/are available in the column selected in the first dropdown. If yes, then the condition becomes true and all the rows that satisfy this condition are filtered.

List of numbers or strings separated by comma.