Let's say I have 10 documents in an index. document 2 has the k-v pair: 'activity': 'start' and document 8 has 'activity':'end'. I want to exclude all documents between and including documents 2 and 8. How can I do this in elasticsearch?

How to exclude records in between two records in elasticsearch?

dadoonet (David Pilato) August 3, 2017, 9:14am 2

I don't think there is an easy way to do that.
I believe you need to think about your model in a different way and basically solve that problem at index time instead.

Topic		Replies	Views
Get documents based on timespan Elasticsearch	2	378	March 4, 2020
Return all events between two events Elasticsearch	4	903	January 18, 2019
Performing between operation on documents in Elasticsearch Elasticsearch	2	608	July 5, 2017
Date between two indexed fields Elasticsearch	3	937	July 5, 2017
Elasticsearch - return records having a field falling in the given range Elasticsearch	11	1683	April 2, 2019

How to exclude records in between two records in elasticsearch?

Related topics