Skip to content

Latest commit

 

History

History
38 lines (26 loc) · 942 Bytes

where.rst

File metadata and controls

38 lines (26 loc) · 942 Bytes

where

Table of contents

The where command bool-expression to filter the search result. The where command only return the result when bool-expression evaluated to true.

where <boolean-expression>

  • bool-expression: optional. any expression which could be evaluated to boolean value.

The example show fetch all the document from accounts index with .

PPL query:

os> source=accounts | where account_number=1 or gender="F" | fields account_number, gender;
fetched rows / total rows = 2/2
+------------------+----------+
| account_number   | gender   |
|------------------+----------|
| 1                | M        |
| 13               | F        |
+------------------+----------+