Possible to join 2 search results like following?
field3 (common field)
fieldA (multiple values, contains start/end time)
Then join with common field3, together with:
fieldA (start) < _time (Set1) < fieldA (end)
Thanks a lot.
Rename _time in query 2 as part of the join, then you will be able to do your comparison / filter after the join
Thanks. Seems if join first with common field3, unable to do filter afterwards. Would you advise how? Sorry for the newbie question.
@stwong I don't understand what you mean. Perhaps if you gave some concrete examples of your queries and data we might be able to help more.