JQL: How to write a JQL to find issues status changed to (e.g. Closed) X number of times

[Alexey Sao]

Hi. 

Plz, help me - How to write a JQL to find issues status changed to (e.g. Closed) X number of times? 

I need to get certain number of times (e.g. 10) status was change to ... (not interested in period, number of times only)

Thank you. 

[Jack Nolddor [Sweet Bananas] · Accepted solution]

Hi,

What about to create a Scripted field and use it within a native JQL?

Check No. of Times In Status field by Script Runner for Jira

Regards

[Alexey Sao]

Good idea, will try. 

Thank you

[Thomas Schlegel · Accepted solution]

Hi @Alexey Sao 

this is not possible. You can just query, whether an issues status changed to closed at least one time.

If you want to query the exact number, you have to define a custom field of type number and increment this number in your workflow transition every time the issue is closed (or whatever you want to count). But of course, this will not count the past transitions.

[Meissam Rezapuran]

JQL SYSTEM