Done and was Done

[Mimi Peters]

Hi there,

I tried a simple filter to look up all the ticket was in "Done" and now is "Done" and something it only show those that are now Done but not was "Done". What did I do wrong?

==============

project = "XX" AND status = Done AND createdDate < endOfMonth(-1) AND createdDate >= startOfMonth(-1) OR project = "XX" AND status was in (Done) AND createdDate < endOfMonth(-1) AND createdDate >= startOfMonth(-1) order by priority DESC, created ASC

==============

Thanks for solving the mystery in advance.

Regards

MM

[Mimi Peters · Accepted solution]

Hi Guys, 

Got a solution from Jira so posted back here for sharing.

Apparently I need to locate the status ID and replace the actual word "Done" with the ID number then it works perfectly fine :) 

[Alex Koxaras _Relational_]

Great!!

[Mimi Peters]

Actually tried out the other one also did not pick up any status "was", perhaps its a known bug?

project = "XX" and status was in ("Review") AND createdDate < endOfMonth(-1) and createdDate >= startOfMonth(-1) order by priority DESC, created ASC

[Alex Koxaras _Relational_]

Hi @Mimi Peters 

Straight out of Atlassian's documentation:

The "WAS" operator is used to find issues that currently have or previously had the specified value for the specified field.

So your JQL should be

project = "XX" AND status was in (Done) AND createdDate < endOfMonth(-1) AND createdDate >= startOfMonth(-1) order by priority DESC, created ASC

[Mimi Peters]

Hi Alex, I tried this just now and it said no issues were found matching. I deliberately change one of last month ticket's status from "Discard" to "Done" and then back to "Discard" so that should pick it up.

Will this have to do with "Resolved" ticket as this Team managed jira I have automation in place to resolve the ticket? 

[Alex Koxaras _Relational_]

@Mimi Peters can you try the following?

project = "XX" AND status was "Done" AND createdDate >= startOfMonth(-1) AND createdDate < endOfMonth(-1) order by priority DESC, created ASC

[Mimi Peters]

Hi Alex, I copy and paste with your comments and only replace XX with my project name and its not showing. I believe it could be to do with Resolved as I do have an automation rule in my Team managed project to change to Closed.