Is it possible to count the number of times issue made specific transaction?

[Akshay Laykar]

I want to get number of times the issue made some transaction. 

Suppose my workflow has Ready to Retest--> Reopen. Now if 1 issues is marked as ready to retest but it was reopened, again after fixing that issue was marked ready to retest but again tester reopens the issue. 

Considering above scenario I want to know how many times the issue was reopened.(need its count) 

Thanks in Advance.

[Veronica Mapes]

Found another simple way to do this: 

Set up a rule on your project to listen for a specific issue transition (either using JQL condition or the transition options, then add an Edit issue action.

Select the field you want (My Customfield) to increment and use the following value:

{{#increment}}{{issue.My Customfield}}{{/}}

This will increase the value every time the issue goes into that status.

Found this from @Nick Menere

https://community.atlassian.com/t5/Marketplace-Apps-Integrations/How-may-I-increment-a-custom-field-s-number-on-a-specific/qaq-p/742636

[Christine Corona]

Hi @Veronica Mapes , I was trying to implement your solution and I continue to get this error: Error while parsing additional fields. Not valid JSON.

Would you mind looking at my screenshot and tell me where I'm going wrong? I know it's user error I just don't know what I'm failing to do. 

Thank you, 

Christine

[Veronica Mapes]

@Christine Corona - It looks like you have spaces between the brackets, though I can't be sure. If so, try removing those. If not, I'm not sure =/

{{#increment}}{{issue.My Customfield}}{{/}}

[Christine Corona]

Thanks @Veronica Mapes, I indeed had spaces so I removed those. I also needed to remove the value from the Additional fields section and place it only under the identified custom field section, then it worked perfectly!

[Noor Syairah Zarifah Binti Asmuni (Erra)]

Hi Veronica and Christine,

I'm also finding this way to count my transition and it is working. Thanks a lot!.

So I just want to share an image of what does Christine said about remove value from the additional field section and place it under identified custom field section. Bcos previously I could not understand it. Probably this can help others too. <3 

[Radhika Vijji _Innovalog_]

Hi Akshay,

Do you have Jira Misc Workflow Extensions plugin in your Cloud instance? If yes,

1. Create a custom type number field "Reopened count"
2. Add the Increase value of field post-function to the "Reopen" transition (https://innovalog.atlassian.net/wiki/x/PICcBQ) 
3. Select the "Reopened Count" field
4. Save the post-function
5. Publish the workflow.

Now every time the ticket is reopened the "Reopened Count" field value increments by 1.

Hope this helps,

Regards,

Radhika

[Burak Kocak]

Hi @Akshay Laykar

I found a free plug in https://marketplace.atlassian.com/apps/27136/jira-misc-custom-fields?hosting=server&tab=overview

that has the functionalty of your needs.  You can check that one. As Elifcan mentioned above, its  not easly possible to find transtion count without searching history tab.

Formula-based Calculated Custom Fields

Transition date/time and transition caller

JQL functions

Create calculated custom fields that evaluate a Java expression to compute the value of the field. Can be of type Number, Date or String.

Create custom fields that will hold the date/time or the name of the caller of any transition in your workflow.

Additional JQL functions you can use in your issue filters.

More details

The Jira Misc Custom Fields plugin's objective is to provide several new types of custom fields for use in custom Jira workflows as well as useful JQL functions.

Included custom fields:

• Calculated Number Field: a calculated custom field returning a number
• Calculated Text Field: a calculated custom field returning a String.
• Calculated Date/Time Field: a calculated custom field returning a java.util.Date (which represents a date+time).
• Transition Date/Time Field: the date and time of the last execution of a specified workflow transition.
• Transition Caller Field: the caller of the last execution of a specified workflow transition.
• Transition Count Field: the number of times a specified workflow transition was executed.
• Parent Status Field: the Status of the issue's parent issue.

Included JQL function:

• currentUserPropertyAsList: a JQL function that returns the value of a property of the current user, transforming comma-separated values into a list of values.

[Akshay Laykar]

@Burak Kocak Thank you for your suggestion too.. but may be Jira Misc Custom Fields plugin is available for server and we are using cloud version. 

[Sergio Renzo]

hey Burak ... I know it's a lot time ago, but JMCF plugin is not free anymore ... do you have other suggestion to do the same for FREE ? thx !!!

[Elifcan Cakmak]

Hello,

I don't think it's possible without any add-ons. For example with Script Runner plugin you can define a scenario like this:

• Create a number custom field
• Write a script that increases the field value each time the issue transitioned.
• Add the script as a post function to your transition.

It is the best possible solution that I can think of on Cloud. 

Regards,

Elifcan

[Akshay Laykar]

@Elifcan Cakmak Thank you for the valuable suggestion. But can I get the count of transactions which are already made.  

[Elifcan Cakmak]

Hey, 

I'm afraid there is no automatic way to get that number. You can check issues one by one, you can see the transitions made on the transition tab but I'm sure you already know that and it is not an ideal solution. I'm sorry I couldn't be more help.

Regards,

Elifcan

[Filip Tanevski]

Hi @Elifcan Cakmak ,

Regarding your solution with ScriptRunner:
 I am new to JIRA and ScriptRunner - do you have an example of how can that script look like?