where

Synopsis

Filters (i.e. narrows) the complex search results to display only those column values that meet specific criteria.

Syntax

where [SEARCH QUERY on column results]

Required Arguments

SEARCH QUERY on column results

Syntax: A search query (simple or complex)

Description: Runs a search query on the complex search summary table, to extract and display values that meet specific criteria.

Optional Arguments

None

Description

Filters the summary table resulting from a complex search, to extract and display only those values that meet specific criteria defined in the "where" search query. The "where" search query can be built using the simple search syntax (see Simple Searches) or complex search syntax (see Complex Search Syntax Reference).

Examples

Example 1:   

in log.access log | count | group by status | order by count desc | where count < 500 

Shows only those statuses in the summary table which have less than 500 events.