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

Question

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"

Anna Hryhoruk _Appfire_ · Answer

Hello @jira_admin_cu ,

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 · Answer

Hi @jira_admin_cu

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

Luis Felipe Studzinski Santos_5srb7f · Answer

@jira_admin_cu

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.