Skip to main content
On this page

Kater SQL Functions Conditions

Conditions

A condition is TRUE or FALSE for each row.

Write it in WHERE to keep the rows where it is TRUE, in a filter that a reader turns on, or in a dimension that flags rows. The Filters menu writes them. A value can come from a parameter that a reader supplies, such as :region. See Filters and parameters.

FunctionWhat it does
KATER__IS_EQUAL_TOTrue where the field equals the value.
KATER__IS_NOT_EQUAL_TOTrue where the field does not equal the value.
KATER__IS_GREATER_THANTrue where the field is greater than the value.
KATER__IS_AT_LEASTTrue where the field is greater than or equal to the value.
KATER__IS_LESS_THANTrue where the field is less than the value.
KATER__IS_AT_MOSTTrue where the field is less than or equal to the value.
KATER__IS_BETWEENTrue where the field is between the low and the high end, both ends included.
KATER__IS_ONE_OFTrue where the field equals one of the values.
KATER__IS_NOT_ONE_OFTrue where the field equals none of the values.
KATER__TEXT_CONTAINSTrue where the text contains the value, in any letter case.
KATER__TEXT_DOES_NOT_CONTAINTrue where the text does not contain the value, in any letter case.
KATER__IS_NULLTrue where the field is empty.
KATER__IS_NOT_NULLTrue where the field has a value.