Say you want to find the tickets assigned to "John Doe" with the status "in progress" in 2018.
If you do this:
status was "in progress" during ("2018/01/01","2018/12/31") and assignee was "John Doe" during ("2018/01/01","2018/12/31")
you will have a union of both conditions instead of the intersection...
e.g:
if a ticket was in the following two states in 2018
assignee="John Doe" and status = "open"
assignee="Jane Doe" and status = "in progress"
but never in the following state
assignee="John Doe" and status="in progress"
it will still be part of the result...
How can we use both historical conditions with a AND type of logic ?
a ticket that at some point in 2018 was assigned to "John Doe" and the status was "in progress" at the exact same time...
Community moderators have prevented the ability to post new answers.