Absent

% 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)

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

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

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