New Formula Function: data_table_query
The data_table_query is a powerful upgrade to data_table_lookup — bringing multi-record returns, advanced filter operators, record identity, and built-in correctness guards, all directly in formula mode.
- Record Identity — Every match includes record_id, created_at, and updated_at, so query results flow straight into downstream Update, Delete, or relation steps.
- Real Filter Operators — $gt, $gte, $lt, $lte, $ne, $in, $starts_with, and $and combinations replace equality-only matching.
- Multiple Records — mode: ‘all’ or mode: ‘some’ returns every match as an array up to a configurable limit, instead of silently returning just the first row.
- Built-In Correctness Guards — Six mode options make the formula throw an explicit error when match-count assumptions are wrong, instead of quietly returning the wrong row.
- Sorting — order ranks results by any field so you can grab the most recent or highest-value match with one_first_optional.
Learn more about data_table_query formula.