You're on your way to the next level! Join the Kudos program to earn points and save your progress.
Level 1: Seed
25 / 150 points
1 badge earned
Challenges come and go, but your rewards stay with you. Do more to earn more!
What goes around comes around! Share the love by gifting kudos to your peers.
Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!
Join now to unlock these features and more
I have this filter to give me what was completed this week across a couple projects. I only get the Tasks, but no Sub-tasks. Anyone know how to get the done tasks and done sub-tasks? I would want the done sub-tasks even when the parent tasl may still be open.
project in (project1, project2) AND status = Done AND resolved >= -1w AND assignee in (user1, user2, user3) ORDER BY "Epic Link"
you can include subtasks in filters without a plugin... here is an example that works - we used components to segregate boards on PROJECTNAME:
project = PROJECTNAME AND component = COMPONENTFORFILTER OR issueFunction in subtasksOf("component = COMPONENTFORFILTER ") ORDER BY Rank ASC
Seems can't find subtasksOf function today in (2021), also write a comment about the alternative:
linkedissue = SAPP-10885 OR linkedissue = SAPP-10787
Are there any subtasks macthing this query? If you expect the subtasks that belong to all the tasks matching this query, that is not how it works.
Subtasks are just another issuetype and they will be returned in the result only if they match the conditions in the query. If you need subtasks from tasks matching to certain criteria, you will need a pliugin like JQL Tricks.
Yes, it seems you have to buy a plugin to do many basic things in Jira. I'm glad Atlassian is investing in new technologies, but I wish they would go back and address so many of the simple things that instead get resolved by third parties.
I've wasted countless hours searching for solutions only to find I need to buy a plugin.
This is an old question but I'm sure this answer is helpful today.
With standard JQL, you can only get a list of issues and export them to Excel for further processing. This works if you want to do a one-off analysis. If your use case is more dynamic than that, look beyond standard Jira.
Standard JQL doesn't easily allow it, but you can quickly find the results using our professional indexing service JQL Search Extensions
After you install the app, you can simply search:
issue in subtasksOfParentsInQuery("project in (project1, project2) AND status = Done AND resolved >= -1w AND assignee in (user1, user2, user3)")
Check out the documentation for more examples.
I hope this helps!