filter-rows

Action

Filter rows based on a condition with comparison operators

Syntax

$result:NUMBER = filter-rows $Gtable where "status" equals "active"

filter rows with literal column and value using equals

$result:NUMBER = filter-rows $Gtable where "age" gt 18

filter rows with literal column and numeric value using gt

$result:NUMBER = filter-rows $Gtable where $column:TEXT equals $Avalue

filter rows with variable column and value using equals

Developer Reference
Set: rowfn
Version: 0.0.0-6
Encoding: T_OP_S8
Actcode: 2053141587
Set ID: 92