Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
Deleted user
Level
0 / 0 points
Next:
badges earned

Your Points Tracker
Challenges
Leaderboard
  • Global
  • Feed

Badge for your thoughts?

You're enrolled in our new beta rewards program. Join our group to get the inside scoop and share your feedback.

Join group
Recognition
Give the gift of kudos
You have 0 kudos available to give
Who do you want to recognize?
Why do you want to recognize them?
Kudos
Great job appreciating your peers!
Check back soon to give more kudos.

Past Kudos Given
No kudos given
You haven't given any kudos yet. Share the love above and you'll see it here.

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Can I get a count of specific subtasks when an issue is moved to a designated status Edited

So my problem is this:

I want to know how many "eng feedback" subtasks QA has made per parent ticket when the parent is in X status.

 

Is this possible with using JQL and not a tool like script runner?

 

Any help would be appreciated

2 answers

Hi @Phillip Talbot 

With JQL, you need to either have a field value to refer to, or have a JQL function which references the required need.

You can do this with a field value in Jira Cloud without an app, although it will required a custom field and an automation rule.

You'll need to be a Jira Admin for this.

Custom Field:

  • Go to Jira Settings > Issues
  • On the left-hand side, select Custom Fields
  • Press the blue Create Custom Field button, and select the Number Field
  • Give the field a name (eg. Count of Sub-Tasks) and press Create

I'd either not have this field on a screen, or only add it to a View screen (via Screen Scheme operations). You don't want this to be manually editable from an issue's view.

Automation Rule:

  • Either...
    • Project: Go to Project Settings > Automation or...
    • Global: Go to Jira Settings > System > Automation Rules
  • Press the blue Create Rule button. Then for the rule...
    • Trigger: Select Issue Transitioned. Enter the required status parameters.
    • Action: Select Edit Issue. Add your custom field, and in the box enter this smart value: {{issue.subtasks.size}}
  • Give the rule a name, and activate it.

^ This will then count the number of sub-tasks below an issue when transitioned to the appropriate status. You can then reference it in JQL like any other number field.

Remember with global automation rules there is an execution limit per month, which is different depending on which plan you're on. Project executions however are almost unlimited.

Ste

Hi @Phillip Talbot ,

You can use the Enhancer Plugin for Jira for this.

It has a custom field called Status Counter that does the exactly what you're asking for: Counts the number of times the issue is in that particular status.

This custom field can be used to sort or search in issue navigator.

image2021-1-8_17-16-34.png

Enhancer Plugin for Jira has many more custom field types that can fit your different requirements.

Please let me know if you have further questions.

Regards,

Gökçe

Please note that I'm one of the members of the Snapbytes team.

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
STANDARD
TAGS

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you