Count Issue Types

Marcelo Ignacio Cid Abud

Hi Community,

I try to count issue type story through an automation.

For example:

Actions:

1. When I create one issuetype = story the custome field (Correlative) is equal to 1

2. When I create other issuetype = task the custome field (Correlative) is equal to 1

3. When I create one issuetype = story the custome field (Correlative) is equal to 2

 

Because I created two story (Action 1 and 2)

Andy Heinzer

Hi Marco,

I think I understand what you are trying to do here, I have put together an automation rule example, that I think might meet your criteria here.  Check it out:

In my example, I have a numeric field called NewNum.  My trigger is upon issue creation.  This is also a project specific automation rule (not a global or multi-project rule).  By doing a Lookup issues and then choosing the JQL of

NewNum is not EMPTY ORDER BY key desc

This way automation will do a JQL query to return the issues in this project that have some value for that custom field, and order them from most recently created to oldest, since Jira increments the issue keys when new issues are created.

From there I do a re-fetch data, just to make sure we give the lookup enough time to gather that info, before you can then do an edit issue action to set the NewNum on the newly create issue. I used the smart value of

{{lookupIssues.get(0).NewNum.plus(1)}}

To look at the first entry of the JQL lookup (0 being the first indexed issue), you can use the get(0) along with the custom field name, and then we can use a simple math operation of plus(1) to increment the other issue's value and store it to that field.

 

This method should allow you to have potentially deleted issues in the project and still new issues will lookup the most recently created issue and use that issues field value when determining the next number to use.

Does this help?

 

Andy