Skip to content
Adaptam Docs

SATISFY_ANY

Multi-field OR constraint for filtering. Returns rows where ANY of the specified field conditions are satisfied. Used inside a data field for specifying the filter value.

SATISFY_ANY function overview

Function syntax

SATISFY_ANY(field1{constraint1}, field2{constraint2}, ...)

Arguments:

  • field1{constraint1}, field2{constraint2}, …: Two or more field-and-constraint pairs. Returns rows that match any one of them.

Examples

  • SUM(revenue{SATISFY_ANY(continent{“Americas”}, country{“China”})}) - Sum of revenue from continent Americas OR country China.
  • COUNT(order_id{SATISFY_ANY(status{“Open”}, status{“Pending”}, priority{“High”})}) - Count of orders where status is Open or Pending, or priority is High.