Done and was Done

Mimi Peters March 23, 2023

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

3 answers

1 accepted

0 votes
Answer accepted
Mimi Peters April 4, 2023

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_
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
April 4, 2023

Great!!

0 votes
Mimi Peters March 27, 2023

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

0 votes
Alex Koxaras _Relational_
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
March 23, 2023

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 March 24, 2023

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_
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
March 27, 2023

@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

status was.png

Mimi Peters March 27, 2023

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 temp.jpgautomation rule in my Team managed project to change to Closed.

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
STANDARD
PERMISSIONS LEVEL
Site Admin
TAGS
AUG Leaders

Atlassian Community Events