Display total count of sub-tasks of the parent in custom field

[Lakshmi S]

Hi Team,

How to display the sum of the count of all "sub-task" tickets to the Story or Bug issue type ticket in a specific custom field? The custom field on Parent ticket.

Ex : If the story has 11 sub-tasks, it will tally the 11 subtasks and exhibit the total as 11 in the Custom Field for the "Total Sum of subtasks"

[Luis Felipe Studzinski Santos]

@Lakshmi S 

Hello,
You can do it through automation. I'll send you an example automation, adjust your trigger and the field where you'll make the number of subs available.

[Lakshmi S]

Thank you for your quick response @Luis Felipe Studzinski Santos . We want to filter the results using JQL, so that's the reason I want to store it in the field.

[Luis Felipe Studzinski Santos]

@Lakshmi S 

Yes, I understand your request. Instead of putting the value in the comments (here was just an example because there is no specific field) you can add the value of the variable by editing the field and putting the smart value in the field and thus use it in JQL or in a dashboard or even in a BI.

[Anna Hryhoruk _Appfire_]

Hello @Lakshmi S ,

If you are considering using marketplace apps (or already have some), you can easily achieve this using Power Custom Fields 

Please refer to this page SIL Script Custom Field .There, you will find an example of the same use case:  Showing the number of subtasks for a ticket 

Additionally, if you already have the Power Scripts app in your Jira, it's also possible to set up something similar with a slightly different approach. If you're interested, please let me know.

Best regards,
Anna

[Hannes Obweger - JXL for Jira]

Hi @Lakshmi S

if you're open to solutions from the Atlassian Marketplace, you may want to have a look at the app that my team and I are working on, JXL for Jira.

JXL is a full-fledged spreadsheet/table view for your issues that allows viewing, inline-editing, sorting, and filtering by all your issue fields, much like you’d do in e.g. Excel or Google Sheets. It also comes with a number of so-called smart columns that aren’t natively available, including the number of sub-tasks.

This is how it looks in action:

As you can see above, you can easily sort and filter by the number of sub-tasks. You can also use your smart columns across JXL's advanced features, such as support for (configurable) issue hierarchies, issue grouping by any issue field(s), sum-ups, or conditional formatting.

This all just works - there's no scripting or automation whatsoever required.

Any questions just let me know,

Best,

Hannes

[Shawn Doyle - ReleaseTEAM]

I'd attempt to do this via automation.  

On creation of a new issue of type bug or story, check for parent, increment custom field on parent.