ID's of issues with number of times they were in REOPENED status.

[Sandeep Vashisht]

Hello All,

I need a help in getting the report which will tell the ID's of issues with number of times they were in REOPENED status irrespective of their current status. For e.g.: There are 10 issues which get reopened multiple times and the report should tell me those 10 IDs.

Thanks in advance for any help. 

[Sandeep Vashisht · Accepted solution]

@Nir Haimov 

Can you please explain more about this field.

[Nir Haimov]

If you have the add-on "scriptrunner" you can create customfield of type "scripted field"

There you can write in groovy a script to count how many time an issue was in a specific status

[Nir Haimov]

Hi,

You can get what you want with simple JQL:

status was in (Reopened)

[Sandeep Vashisht]

but it doesn't tell me number of times it get reopened in his life span.

[Nir Haimov]

That's right...

you said "There are 10 issues which get reopened multiple times and the report should tell me those 10 IDs."

The JQL above will give you that.

If you also want the number of times it get reopened in his life span, you need to create a customfield of type "scripted field" of scriptrunner.

[Sandeep Vashisht]

Thanks Nir, but that was a example :)

Any way thanks again for your help.

[Nir Haimov]

You are welcome :)

if i solved your issue, please mark my answer as the solution.

Or if you need anything else, let me know and i will continue to help if i can :)

[Jack Brickey]

You might be able to achieve your goal of count by using the filter Nir suggested in conjunction with a dashboard gadget, e.g. the two dimensional gadget. Maybe on y- axis the issue ID and the x-axis the project. Something to play around with.  

[Nir Haimov]

Didn't think about it @Jack Brickey

The two dimensional gadget may actually work.

@Sandeep Vashisht you should give it a try :)

[Sandeep Vashisht]

@Jack Brickey your suggestion will not give "number of times issue comes in re-open state in a life span"