Filter by Sub-task and sprint won´t work, why?

[Erick Díaz]

I try making a filter to show only sub-task from a specific Sprint, in this case "TM Sprint 01" from the project "Project TM". But when using this filter, there is no error, it just won´t show up anything, not even if I use "Basic" filter instead of "JQL".

Notes: if I use `Task` instead of `Sub-task` it does work. When I use: issueType = "Sub-task" it does work too. 

The reason I am doing this is to get status from all sub-task of the ongoing week (our sprint in this case) and see: To do, Doing, Done. So I can generate KPIs from a specific week, specific project, by team member.

Filter I am using:

project = "Project TM" AND Sprint = "TM Sprint 01" AND issueType = "Sub-task" AND status in ("To Do", "In Progress", "Done") AND assignee is not EMPTY

[Hannes Obweger - JXL for Jira · Accepted solution]

Hi @Erick Díaz,

welcome to the community!

I believe that - at least in team-managed projects - JQL searches based on sprints don't work for sub-tasks. Sub-tasks are a bit special, in that they always "inherit" the sprint from their parent issue. I could imagine that our bug is somehow related to this this special behaviour.

This being said, if you are open to solutions from the Atlassian Marketplace, you'll have options available. E.g., your use case would be easy to solve using 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 advanced features, including support for (configurable) issue hierarchies, issue grouping by any issue field(s), sum-ups, or conditional formatting.

Plus, filtering sub-tasks by their sprint works as expected, for company-managed as well as team-managed projects. This is how it looks in action:

Any questions just let me know,

Best,

Hannes

[Erick Díaz]

Hi Hannes, this is very helpful, thank you.

[Danut M _StonikByte_ · Accepted solution]

Hi @Erick Díaz,

Welcome to the Atlassian Community. 

Indeed, filtering sub-tasks by sprint does not work in team-managed projects. This is a known bug/limitation of Jira Cloud. See https://jira.atlassian.com/browse/JRACLOUD-90898. On company managed projects it works. 

So a solution would be to switch to company-managed projects.

Another option for getting the statistics you need would be to try using a plugin (app) from Atlassian Marketplace that is capable to generate multi-field statistics.

If you want to try a plugin, our Great Gadgets app offers a Pivot Table & Pivot Chart gadget that can display display stats by multiple fields, in your case by Assignee, Sprint, and Status Category.

To get a table like the one above, the gadget should be configured like this:

The gadget is highly configurable. You can split by additional fields, and instead of count you can choose to display display sum of story points, hours spent or percentage of total. If you need any help with the configuration of gadget, feel free to contact support@stonikbyte.com.

Danut

[Erick Díaz]

Very detailed, thank you!

[Gor Greyan]

Hello @Erick Díaz
You need to filter sub-tasks based on their parent issue’s sprint. Unfortunately, JQL doesn't support native parent-child filtering across custom fields like Sprint. But there are workarounds:
I can suggest 2 solutions.

1. If you have ScriptRunner, you can try the following JQL.

issueFunction in subtasksOf("project = 'Project TM' AND Sprint = 'TM Sprint 01' AND status in ('To Do', 'In Progress', 'Done') AND assignee is not EMPTY")

2. Create a filter for parents
project = "Project TM" AND Sprint = "TM Sprint 01" AND issueType in (Task, Story) AND status in ("To Do", "In Progress", "Done")

Then note the parents' keys.

Create a second filter.

parent in (TM-101, TM-102, TM-103) AND issueType = "Sub-task" AND status in ("To Do", "In Progress", "Done") AND assignee is not EMPTY

It is manual work, but it works. :)

Hope I can help you.

[Erick Díaz]

Thank you Gor, I am going to try the alternatives.

Note: if this is useful to anyone, here are some "solutions" that I am currently trying and might work for you as well. My main goal is to generate weekly KPI (or tracking) based on subtask only of the ongoing week. 

This one shows pending work for this week (due to the end of the week), showing the work that was not finished previously and the work schedule for this week.

project = "Project TM" AND parent is not EMPTY AND status in ("To Do", "In Progress") AND dueDate <= endOfWeek()

This one is to show pending work, from past weeks and current week (due to the end of the week) and also finished work from this week only (any pending subtask that was closed or finish the current week).

project = "Project TM" AND parent is not EMPTY AND (

    (status in ("To Do", "In Progress") AND dueDate <= endOfWeek())

    OR

    (status = "Done" AND resolved >= startOfWeek() AND resolved <= endOfWeek())

)

Something I found out early using filters, is that you have to use Jira properly, otherwise it become a little chaotic.

[Gor Greyan]

@Erick Díaz
Thanks for the provided alternative.

Will use if needed.

[Varsha Joshi]

Hi @Erick Díaz 

Welcome to the community!

I noticed that too. I think the sprints are not designed to track at sub-task level, instead they track tasks. Sub tasks show up under the tasks in a sprint.

Hope this helps.

[Erick Díaz]

oh I see. Thank you Varsha.