BOOL_OR() GROUP BY ...

All functions > GROUP BY > BOOL_OR() GROUP BY ...

Returns TRUE if any value in the group is true.

Syntax

BOOL_OR(expr)
 [ FILTER (WHERE condition) ]
  [ GROUP BY feature [, feature ...] ]

BOOL_OR(expr)
 [ FILTER (WHERE condition) ]
  [ GROUP BY feature [, feature ...] ]

Notes

• Logical OR aggregation across all values in the group
• Returns TRUE if any value is TRUE
• Returns FALSE if all values are FALSE
• NULL values are ignored in the calculation
• Returns FALSE for empty groups
• Can be used with WHERE clause to filter before aggregation
• Can be used with GROUP BY clause for grouped aggregation

Examples

SELECT
    f1 := ZIP(ARRAY[TRUE, FALSE, TRUE] AS value).TRANSFORM(SELECT BOOL_OR(value)).UNWRAP_ONE(), -- OR of values
    f2 := ZIP(ARRAY[FALSE, FALSE, FALSE] AS value).TRANSFORM(SELECT BOOL_OR(value)).UNWRAP_ONE() -- OR of values
;