Skip to main content

WHERE

Filter rows based on a boolean condition.

Syntax​

WHERE expression

Parameters​

  • expression - Boolean expression that evaluates to true or false for each row

Description​

The WHERE command filters rows by evaluating a boolean expression against each row. Only rows where the expression evaluates to true are kept. Rows where the expression evaluates to false or null are excluded.

You can chain multiple WHERE commands in a pipeline. Each command acts as an additional filter with logical AND behavior. The expression can reference any field available at the point where the WHERE command appears in the pipeline.

The expression can be any valid Hamelin expression, including those that use comparison, logical, membership, and null-checking operators.