filter
Returns a table that has been filtered.
Syntax
filter(<table>, <filter>)
| Parameter | Type | Description |
|---|---|---|
| table | Table | The table to be filtered. |
| filter | Boolean | A boolean (True/False) expression that is to be evaluated for each row of the table. |
Return values
Table
Usage
Returns orders where the discount equals 0.
filter(orders, orders.discount == 0)
Returns customers who have never placed an order.
filter(customers, is_empty(customers.last_ordered_at))