Tabular Operators
where operator
Filters out a dataset to a branch of rows that meets a condition when executed.
Syntax
| where condition
Arguments
name | type | description |
---|---|---|
Condition | boolean | A bool expression over the columns of the dataset, it is then checked for each row in your dataset |
Returns
Rows in dataset for which condition is true.
Example
['http-logs']
| where method == 'GET' and content_type == 'image/jpeg'