Group by in Filter

[bee_eo]

Hi, 

I have a bunch of user stories with sub tasks. I would like to create a filtered list that shows the sub tasks group by user stories so that i can display them through MS Teams. I have no success on that. Anyone? 

[Vishal Biyani · Accepted solution]

@bee_eo 

JIRA JQL does not allow subquery by default. The best you can do is query for subtask and include parent while displaying the filter result in dashboard gadget

You have to use some marketplace app, scriptrunner or REST API for your use case.

[bee_eo]

Thank you. I was googling around before posting this question here and all pointed to the same answer. I can now gave up trying :).  

[Hannes Obweger - JXL for Jira]

Hi @bee_eo

if you're open to solutions from the Atlassian Marketplace, there's a number of apps available that can help with showing your issues in their hierarchy, e.g. with sub-tasks grouped by their parent.

E.g., this is how this would look in 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 advanced features, including support for (configurable) issue hierarchies, issue grouping by any issue field(s), sum-ups, or conditional formatting.

The part that I'm unclear on is the MS Teams integration. Mind elaborating on what you have in mind here?

Any questions just let me know,

Best,

Hannes

[Yousif Hassan]

There is a paid version of this - it's called Plans (you need Jira prem) 

A potential workaround - you can use the "List' tab on a project with the user stories + sub-tasks and format based on hierarchy (dark green if parent, light/no-colour if child) and show the relationship that way.

Good luck 😅

[bee_eo]

Thank you, not able to go down the path of paid version unfortunately. 

Thanks for the suggestion too however as i am only interested in showing the issues that are in active sprint, the list will show everything which is not ideal. 

[Yousif Hassan]

you can filter by active sprint too!