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. To filter out null values, you can use the null keyword ex. "column != null" (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)

--cache

A boolean value of true/false that determines whether or not to use the cache. Generally most commands will default to true.

--checkpoint

Format: "{CHECKPOINT NAME}:{COLUMN}" Used to store the value of the provided column (in the first row of results) in the provided name for use as a checkpoint in scheduled queries or other stages. Can be accessed using $CHECKPOINTS.{CHECKPOINT NAME}$

--filter

A filter to run on the command results before completing the command. If not provided, no filter is run on the results.

--guid

Adds a populated random guid column.

--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.

--table

A comma separated list of columns to include in the command results. If not provided, all columns will be included.

support

AMI_ENTERPRISE AMI_FREE AMI_PRO BINARY_ENTERPRISE BINARY_FREE BINARY_PRO DESKTOP_ENTERPRISE DESKTOP_FREE DESKTOP_PRO DOCKER_ENTERPRISE DOCKER_FREE DOCKER_PRO