Finding issues reopened in last week

I would like to create a filter that shows issues that have been reopened in the last week, but there doesn't seem to be a 'reopened date'.

Does anyone have any suggestions for how I could do this?

Edit: we are using jira v5.1.1

7 answers

1 accepted

what about the "status changed to" JQL syntax?

i.e.

status changed to Reopened BEFORE startOfWeek()

But better use

status changed to reopened during (startOfWeek(-1w),startOfWeek())

Perfect, that's just what I was looking for, not sure how I missed the 'changed' operator in the docs. Thanks!

This is nice, never heard of the changed operator! :)

@Udo Brand yeah exactly

'during' is cool too, not seen that either. When I said "during the last week" I meant "in the last seven days", so I'm actually using "changed to reopened after -1w"

+1 for "changed to"

It has a clear syntax and an additional predicate "FROM".

2 votes
Daryl Chuah Atlassian Team May 01, 2013

Hi there

Perhaps you can try using JIRA Enhancer Plugin which could provide a First & Last Reopened Date Custom Field in JIRA.

Hope it helps!

Cheers :)

Thanks, unfortunately we don't have that plugin currently, and our licence is for a few thousand users, plugins get quite expensive at that point so I won't be able to get it purchased without a *really* good reason either. Thanks for pointing this plugin out though, looks useful.

2 votes
Richie Gee Atlassian Team May 01, 2013

Hi there,

You can also achieve this by using Advance Search, JQL query like below:

project = TEST AND status = Reopened AND updatedDate >= "1w"

Hope this helps, cheers :)

Nice idea, but our issues get updated (commented, reassigned etc) very regularly, so this would probably end up just showing pretty much all reopened issues I guess?

Richie Gee Atlassian Team May 01, 2013

It is true, but I think this is thus far the most "economical" way of doing it :)

To get an exact clue of reopened issues you need to specify a custom field (reopendate) and add a post-function on the reopen transition that writes the current timestamp to the reopendate. with this, you are able to filter exactly those issues.

This is an awesome suggestion, I'm going to try it as well.

Done. I created the Custom Field ReopenDate and set the field type to Date Picker. Then I added a Post Function to all my workflows on the Reopen Issue transition (Update Issue Custom Field) as follows:

The ReopenDate of the issue will be set to %%CURRENT_DATETIME%%.

Then I temporarily added "Reopen Date" to my Default Screen so that I could manually update the field for existing issues that have been reopened but not yet closed, since they've already been through the transition. I'll probably remove that when done because I don't want users manually setting this field in the future.

Confirmed that I can query on this field for accurate information whether auto-filled as part of transition Post Function, or manually filled.

Only thing missing is that even when this custom field has data in it, it is not displaying in the Details section of individual issues.

Are you sure the field is even missing, when it has value? I remember one custom field in our jira of type date, that shows up on the right side of the details view (under creation date etc), not in the regular information panel left.

Thanks for pointing out how to do it without using a plugin - unfortunately as with plugins in our organisation any admin changes need a really good bussiness reason to go through.

Went back and double-checked and it is not on the view issue screen anywhere. Not critical for this particular custom field, as I can see the date under the Transition Summary, and I don't need users interacting with the field. Just wish I understood when a custom field gets displayed and when it doesn't.

Maybe check your field configuration?! Otherwise make it a new question.

Hi there,

I think you can do it without any plugins or tricks. Let me propose my solution using JQL with "WAS" operator:

project = TEST AND status WAS Reopened AFTER "-1w"

Cheers

This could be a good idea if it works. But then one has to decide, is there a need to have the reopen date visible in the ticket? If so, then your solution will not fit, otherwise good and easy point!

I guessed unless you create a custom date field to track the reopen ticket(copy the value using post function) if you really need to view the date as well.

Otherwise, the JQL proposed by Roman should help you to retrieve the past week issues that been in reopen state. :)

This is the kind of thing I was trying to do, I was thinking that the 'was' operator might help here, but I couldn't quite get the syntax right.

Based on what you suggested I'm now using the following query, which gives me all issues which are now reopened, but were in the 'resolved' status at some point in the last week. It's close enough to what I'm looking for. Thanks for pointing me in the right direction.

status = reopened AND status WAS resolved after "-1w"

If this was the right solution for you, you can mark this answer as accepted! :)

I was about to accept this as the answer (the 'status was reopened' syntax does work) but C. Faysal jumped in with a neater solution.

0 vote

Hi Badger,

For the moment, JIRA do not have the filtering to show the issue of reopened history. However, I can introduce a plugin known as JIRA Enhancer Plugin that contain of custom field where record issue reopened date. To download the plugin please click the link below:

https://marketplace.atlassian.com/plugins/plugin.jep

You can try to test on it and see how it goes. Thanks, John

so which query is most suitable to get reopened bug count for past week

Project = TEST AND issuetype = Bug AND status WAS Reopened AFTER "-1w"

or

Project = TEST AND issuetype = Bug AND status changed to reopened after -1w 

kindly suggest.

is there possiblity to get reopen bug count for any specific period than week using jql?

Suggest an answer

Log in or Join to answer
Community showcase
Sarah Schuster
Posted Jan 29, 2018 in Jira

What are common themes you've seen across successful & failed Jira Software implementations?

Hey everyone! My name is Sarah Schuster, and I'm a Customer Success Manager in Atlassian specializing in Jira Software Cloud. Over the next few weeks I will be posting discussion topics (8 total) to ...

3,323 views 14 20
Join discussion

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you
Atlassian Team Tour

Join us on the Team Tour

We're bringing product updates and pro tips on teamwork to ten cities around the world.

Save your spot