How to get the count of a value from a singular select list for an Issue

Nannette Mori

I need to get a count  DRs was rejected. We track this using a customfield singularlist that when the user selects the Failed Verification Transition the customfield is automatically set to "rejected".  I need to get a count for each individual DR how many times the DR was rejected and a total count of how many of our DRs failed Verification.

Is there a way to count how many times an issue was in a specific transition.  When the DR is failed the "Failed Verification" transitions to "In Progress".  So the only way we can tell if the DR was rejected is by the customfield field that automatically updates to "rejected" if the transition "failed Verification" is selected

 

Is there a way I can get this info using Script Runner Scripted Fields?

 

Mark Segall

Hi @Nannette Mori - There's two parts to this:

I'll defer to the community if you prefer scriptrunner, but here's how you can do it with native tools/Jira Automation

1. Tracking on an individual issue
2. Tracking total issues

Tracking on an individual issue

You could simply look at the history for the issue and see how many times the issue has transitioned to the Failed Verification status.  If you need something for reporting like a gadget on a dashboard to say, show all issues where they transitioned more than n times, you would need to do something like this:

• Create a custom numeric field to capture a tally of how many times the issue transitions
• Create an automation rule that will tally it:
  • TRIGGER: Issue Transitioned (to Failed Verification)
  • ACTION: Edit Issue (your custom numeric field)

    • {{#=}}{{issue.your custom numeric field}}+1{{/}}

From here, you'll be able to do whatever reporting you want to use against the new custom field.

Tracking total issues

You could use this JQL as the base for your dashboard gadgets which will bring in any issues that were ever in Failed Verification:

status changed to "Failed Verification"