Can we perform a between query within multiple documents?
For eg:
consider document1. There is message field in this document which says "Call initialised".
Consider document 2. There is a message field which says "Call started".
Consider document 3. There is a message field which says "Call ended".
Now I want to search between "Call Initialised " and "Call end" messages which should fetch me all messages between these two messages.
Range query on timestamp is not possible, as I have 1000 records for the same timestamp.
Can anyone help me with the same?