filter
filter [expression]
Filters results based on the provided expression
arguments:
expression
An expression containing boolean logic (and/or, ()) and equivalences (>=, <=, !=, ==). Quoted values are evaluated as strings and unquoted strings are evaluated as column row values. (type: string)
examples:
Query
seed '[{"key": "match", "key2": 5},{"key": "match", "key2": 11}]'
|| filter '(key == "match") and (key2 >= 10)'
Results prior to filter stage:
| key | key2 |
|---|---|
| match | 5 |
| match | 11 |
Results after filter stage:
| key | key2 |
|---|---|
| match | 11 |
flags:
--appendStage
Used to append the results from a previous stage to the current stage. (provide a label, stage index, or boolean true to append the previous results)
--attributes
A comma separated list of attributes to include in the command results. If not provided, all attributes will be included.
--cache
A boolean value of true/false that determines whether or not to use the cache. Generally most commands will default to true.
--filter
A filter to run on the command results before completing the command. If not provided, no filter is run on the results.
--labelStage
Used to label a stage with a user provided label.
--stats
Controls if a stats calculation is run on a stage after it completes.