The new time_frame datatype and filters introduced in 5.2 (https://www.elastic.co/guide/en/elasticsearch/reference/5.2/range.html) allow for very convenient filters on intersects of date ranges, e.g. (inspired by the documentation):
GET range_index/_search
{
"query" : {
"bool" : {
"filter" : {
"range" : {
"time_frame" : {
"gte" : "2015-10-15",
"lte" : "2015-11-10",
"relation" : "intersects"
}
}
}
}
}
}
However, this only tells us that the two time frames intersect, not by how much. Is there any way existing or foreseen to also filter these intersects by minimum / maximum duration, let's say all time_frames that intersect by at least 2 weeks (I couldn't find any, but might have overlooked the obvious)?