The Atlassian Community Forums are currently in read-only mode. We will be relaunching on a new platform on September 22 (read more here). We apologize for the extended downtime. For concerns or questions, please email communitymanagers@atlassian.com. See you on the other side, on the new Atlassian Community Forums! :)

×

Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

how to use two historical fields together

Eric Cabot
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
October 26, 2020

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...

0 answers

Comments for this post are closed

Community moderators have prevented the ability to post new answers.