JQL for returning issues movement from one status to another by a particular user

[Michael Leak]

I need the JQL to be able to see where a specific user has changed the status of issues from a particular status to any other status in the project. 

[Phill Fox]

Hi @Michael Leak 

The JQL I would use for your query (and picking up on some of the excellent points by @JimmyVanAU )  is 

project = ABC AND status CHANGED FROM "In Progress" BY michaelleak AFTER "1/1/2020"

You will notice here I am using the CHANGED operator with two additional predicates BY and AFTER, although the after is not essential for your scenario it makes sure to restrict the changes to only recent changes. 
I suspect you are looking for activity in a particular period though and you might want to change this predicate from AFTER to DURING(date1,date2) 

You can find more information on the CHANGED operator and its predicates at 

https://confluence.atlassian.com/jirasoftwareserver/advanced-searching-operators-reference-939938745.html (server/DC)

https://support.atlassian.com/jira-software-cloud/docs/advanced-search-reference-jql-operators/ (for those users on cloud here is the equivalent reference in case they ever diverge)

Hope this helps

Phill

[JimmyVanAU]

Hi Michael,

Try something like:

project = ABC AND status was "In Progress" AND status != "In Progress" AND status changed BY michaelleak

I'm not confident the results will be 100% perfect, but it will get you some of the way there. It's the last clause I'm not sure about, as if the status has been updated since this person moved it out of the particular status, it may filter too much, or it may show too much. Can't tell you.

Depending on the size of the project, I'd also suggest putting some date filters on it, just so you don't query every single issue needlessly. Add something like "updated < -30d", so you're only looking for what changed in the last month.