elasticsearch/docs/reference/query-languages/esql/_snippets/functions/examples/absent.md

% This is generated by ESQL's AbstractFunctionTestCase. Do not edit it. See ../README.md for how to regenerate it.

Examples

FROM employees
| WHERE emp_no == 10020
| STATS is_absent = ABSENT(languages)

is_absent:boolean
true

To check for the absence inside a group use ABSENT() and BY clauses

FROM employees
| STATS is_absent = ABSENT(salary) BY languages

is_absent:boolean	languages:integer
false	1
false	2
false	3
false	4
false	5
false	null

To check for the absence and return 1 when it's true and 0 when it's false you can use to_integer()

FROM employees
| WHERE emp_no == 10020
| STATS is_absent = TO_INTEGER(ABSENT(languages))

is_absent:integer
1