Search based on value between two fields #33

Hi there,

Apologies, not really an issue but hoping to seek some help.

My use case is I'm storing events with startTime and endTime as Unix values in numeric fields. I need to be able to search for events where a given time is between the startTime and endTime fields so that I can find all events in progress at the given time.

I'm aware you can search where a single field is between two given values, I guess I need the reverse where a single given value is between two fields.

Is this something that is at all possible? Or is there anyway I can mimic this behaviour using or queries?

Any advice would be most appreciated! :)