Count Child Issues within a Story

Question

Hello Jira Community,

I have created several stories under different projects within my Jira Cloud. Is there a way to count the number of child issues within each story and sort it by stories? 
Eg:
Project 1 has 5 Stories created. Each story has 5 Child issues (or sub tasks)
Project 2 has  10 srories created. Each story has 10 child issues (or Sub tasks)
OR  I want a query that works something like below

Count (number of child issues) Where Due Date of Story= 31 December 2022

The answer should be a list of all individual child issues whose Story has a due date of 31 Dec. Note that individual child issues have no Due Dates only the Story has a due date

unknown · Answer

Hi @Omkar Borle

thanks to different plugins you can get what you need.
I work at DEISER, we are marketplace vendor and solution partner, our product Projectrak could help you with your question, I leave here the link so you can access directly to the documentation and an explanatory video, and if you want you can contact me for more information or even download a free trial for 30 days.

I hope it is of your help, and as I said before, if you need more information both me and the DEISER team, we will be happy to help you and go deeper into the subject.

Yousef

Dave Rosenlund (Trundl) · Answer

Hi, @Omkar Borle.  As @Gaurav suggests, this is some you can def. do with Structure.

If you decide to give it a try (free 30-day trial), the Structure team at Tempo would be happy to help you with your use case if you get stuck. Reach out to me here if you'd like that assistance.

-dave

Aron Gombas _Midori_ · Answer

You can export all the issue included in the calculation to Excel, then filter and count there with a few clicks.

Our app will help with it: https://marketplace.atlassian.com/apps/1212652/better-excel-exporter-for-jira?hosting=cloud&tab=overview