nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

How do I count the parents that have a subtask

Karen FitzGerald _ICT Programme Delivery_

Hi, how do I create a count of parent tasks that have a subtask (and exclude the ones that don't have some tasks) i.e.

Count the number of tasks in this project that have any subtasks (at least 1)

Simply, count/tell me the parents that have children

Don't count the childless parents

Thanks

Accepted answers

All comments

Vishal Biyani_2pr07j

@Karen FitzGerald _ICT Programme Delivery_

Can you share more context as to what business problem you are trying to solve?

How will the automation be triggered?

if it is going to be scheduled, then it has a limit (i think 100) beyond which it can't fetch the issues

Epic can have child issues (like Story/Task etc). Are you only interested in standard issue types other than Epic?

Once the count is found, where should that be saved (in a custom field or somewhere else)?

Marc -Devoteam-

HI @Karen FitzGerald _ICT Programme Delivery_

You could create an automation rule, that triggers manually or on a schedule.

Use a lookup issues action to find all tasks and then make a log action or edit a number field.

Both need to have set {{lookupIssues.count}} as smart value in the action.

The main issue is that JQL can't perform this search ootb, you will need a marketplace app for this

Pasam Venkateshwarrao

Hi @Karen FitzGerald _ICT Programme Delivery_

Thanks for reaching out to the community,To create a count of parent tasks that have at least one subtask in JiraCloud, you can use a JQL query within the "Automation" feature, leveraging the "subtasks" operator to identify parent issues with associated subtasks and then use a count function to get the total number of such parent issues

Create a new rule:
Trigger: Choose a trigger based on when you want the count to update (e.g., "Issue updated", "Issue created").
Condition: Use the following JQL query in the condition section

issueType in ("Story", "Task") AND project = "YourProjectName" AND issuetype != "Subtask" AND subtasks.size > 0

Action

Create a custom field: Add a custom number field to your issues where the count will be stored.

Update issue: Use a "smart value" to populate the custom field with the count of matching issues.

Smart Value: {issue.subtasks.size}

Thanks

Karen FitzGerald _ICT Programme Delivery_

Hi Vishal, I want to do it in a Smart Filter on a dashboard

So I have 100 offices (parent task) and I want to know how many of them need a PC (subtask) - not all the office do.

So I have a list of PCs that were uploaded and attached to the office number.

I want to COUNT Number of Offices that need a PC i.e count the parents that have a subtask uploaded for them

Karen FitzGerald _ICT Programme Delivery_

Hi Marc,

I want to do it in a Smart Filter on a dashboard

So I have 100 offices (parent task) and I want to know how many of them need a PC (subtask) - not all the office do.

So I have a list of PCs that were uploaded and attached to the office number.

I want to COUNT Number of Offices that need a PC i.e count the parents that have a subtask uploaded for them

Karen FitzGerald _ICT Programme Delivery_

Hi Pasam, thank you. Looks like I can use this in a smart filter? I'll give it a try.

Vishal Biyani_2pr07j

Looks like you have a marketplace app Rich Filters for Jira Dashboards that you want to use. Is that correct?

Pasam Venkateshwarrao

@Karen FitzGerald _ICT Programme Delivery_ Thanks can you try and let me know if it works for you

Marc -Devoteam-

Hi @Karen FitzGerald _ICT Programme Delivery_ and @Pasam Venkateshwarrao

This will provide the number of sub-tasks counted on each issue.

This will not solve the issue to count the number of tasks which. have no sub-tasks as total.

Then you would need another automation that runs manually or scheduled an in that rule do a lookup for issues where the custom number field has value 0

Then have another custom number field in the system that stores this information as that will be the total of issues with no subtasks,

This field can be found by JQL.

This field can be update by the smart value {{lookupIssues.count}

Stephen.Lugton

Hi @Karen FitzGerald _ICT Programme Delivery_

You've said that you want to know how many offices need a PC. Do the subtasks have the phrase 'PC' or similar either in the summary or description

If so you could create a filter using the following JQL:

summary ~ "PC"

Description ~ "PC"

This would give you a count of issues with PC in the summary or descsription

You can also apply further logic to make sure only open subtasks in your project appear:

summary ~ "PC" AND Project = "Offices" AND statuscategory != Done AND issuetype = sub-task

You could then use this filter in a dashboard.

Hannes Obweger - JXL for Jira

Hi @Karen FitzGerald _ICT Programme Delivery_

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 long list 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, and also use it 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

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira

cloud

jira-cloud