Search set of intervals

Given a set of time intervals in indexed data. is there a way where we can identify if a given time lies in any of the intervals present.
For eg:
If the indexed data has
"time_shifts": [
[11:30:00, 14:30:00]
[15:00:00, 16:30:00]
[18:30:00, 22:30:00]

and if we want to see if 12:00:00 is there then it should return the above document
and if we search for 17:00:00, it should not return anything as it does not lie in any of the intervals


take a look at the range datatypes


Thank you so much Alex

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