Skip to content
Adaptam Docs

SATISFY_ALL

Multi-field AND constraint for filtering. Returns rows where ALL specified field conditions are satisfied. Used inside another function’s filter.

SATISFY_ALL function overview

Function syntax

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

Arguments:

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

Examples

  • SUM(revenue{SATISFY_ALL(country{“USA”}, business{“SW”})}) - Sum of revenue where country is USA AND business is SW.
  • COUNT(order_id{SATISFY_ALL(status{“Open”}, priority{“High”}, region{“West”})}) - Count of orders where status is Open, priority is High, and region is West.