Query for all tasks that were assigned to a person in specific status

Nina Andrić

I want to create a query with a list of tasks that were assigned to a specific person in a specific sprint while in status "In progress" (or any other specific status).

When I use assignee WAS person_x it lists me all the tickets when that person was assigned in any status, but I want to limit it to only specific status (something like assignee WAS person_x WHEN status WAS "In progress", but JQL does not work that way )

Have somebody tried to do something similar?

Harsh_v2xlv7

Hi @Nina Andrić 

 

To filter all the tickets where assigned to one person you can use -

Project= Xyz and status in ("in progress", "done") and assignee = "1234" 

 

Status in () is used when you want to look for the assignee is Multiple Status

But if you want to search in only status you can use -

Project= Xyz and Status= "in progress" and assignee = "12345"

 

I hope this helps you with your problem.