SQL “where not exists” equivalent for Elastic

Hello,

I have a set of stages I am logging. A GUID is on each record to tie the stage together.
Example:

Guid Stage
1 Stage 1
1 Stage 2
1 Stage 3
1 Stage 4
1 Stage 5
2 Stage 1
2 Stage 2
2 Stage 3
2 Stage 4
2 Stage 5

I am looking to put a visual together on any GUID which has any missing stages.
In SQL I would use something along the lines of:

select * from tbl as a
where stage = 1 and
not exists (
select * from tbl as b where
stage = 5 and a.guid = b.guid
)

Any advice on how to achieve this in elastic/kibana?

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.