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
Is there a way to search for subtasks under closed standard tickets not using Issuefunction? (as I've no access to ScriptRunner)
Hi @Anqi Zhang -- Welcome to the Atlassian Community!
That is not possible with the out-of-the-box features of JQL, as it cannot do sub-queries or joins, like a SQL.
As you note no access to marketplace addons like ScriptRunner, a few possible work-arounds are:
Hi @Anqi Zhang,
You could try using the Work Breakdown Structure (WBS) gadget offered by our Great Gadgets plugin for visualizing the sub-tasks.
This gadget takes the issues from a specified filter and displays them in a tree structure, by their hierarchy, in form of Epics > Stories, Tasks > Sub-tasks along with their status.
All you have to do it to have a filter that returns the closed parent tasks and sub-tasks and to configure the gadget to use this filter. It will do the grouping for you and you will be able to visualize the subtasks of closed stories/tasks. The JQL of the filter can be like this:
((issueType in standardIssueTypes() and statusCategory = Done) OR issuetype in subTaskIssueTypes()) AND project in ("Project1", "Project2")
Please note that this app offers many other gadgets that you will find useful. Just have a look over the articles from our blog to make an idea. It can be a great asset for your team and company.
I hope this helps.