Can I use JQL to find sub-tasks with a parent having a specific Component?

Angie Weller March 19, 2021

I am trying to find sub-tasks where the parent User Story has a specific component.

This is the closest JQL I could find using other community answers, but I'm getting an error on the function.

project = MyProject AND issuetype = sub-task and issue in parent("component = 'Data Migration'")

 

error: Unable to find JQL function 'parent(component = 'Data Migration')'.

4 answers

3 votes
Earl McCutcheon
Atlassian Team
Atlassian Team members are employees working across the company in a wide variety of roles.
March 22, 2021

Hello @Angie Weller ,

The JQL function for the field referance "Parent" is a native ot Jira JQL covered in more detail in Advanced search reference - JQL fields noting:

Parent

Search for all subtasks of a particular issue in classic projects or subtasks of a particular epic in next-gen projects. You can search by issue key or by issue ID (i.e. the number that Jira automatically allocates to an Issue).

It will allow for the addition of a singular parent issue with something like "Parent = EXE-123"  or the addition of multiple parents in the form of something like "Parent in (EXE-123, EXE-124, EXE-125)"

However, the function does not support nesting a subquery into the in function and we are tracking interest in adding this as a new feature via the following requests for both the Server and Cloud platform respectively, but it is not available yet so make sure to add a vote to show your interest and help bump up the priority for implementation:

For current workarounds you will need to look into add-on apps that can extend the native functionality:

First as mentioned by @Mohamed Benziane , the add-on ScriptRunner for Jira  does have an option for you that does allow nesting subqueries through the add-on apps extended JQL functions, particularly the JQL

issueFunction in subtasksOf("Additional JQL search here to look for the parent issues you want to define")

The above example and more for this add-on can be seen in their documentation pages here:

Additionally, you could also look at using the  JQL Search Extension plugin, which will allow you to create a subquery and then uses it in other complex queries, as described in the apps documentation pages 

Another option that is a free option would be to export the data to an external spreadsheet application using either the Jira Cloud for Google Sheets (Official) or Jira Cloud for Excel (official) extensions to pull live data into the spreadsheet application and run lookup and comparison operations from that external toolset.

Regards,
Earl

0 votes
Leigh Cameron
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
November 15, 2023

(I know this is old, but found my way here high in search results)

 

Previously on Jira server I've done queries like this with the "Structure" plugin, when you build a structure you first add JQL for the issues, then add an extender which adds to the query all the children/parents.

0 votes
Mohamed Benziane
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
March 22, 2021

Hi 

Welcome to the community

 The function "parent" seems to be provided by the plugin Scriptrunner. So you need to have this addon installed in your Jira to use it.

 

Hope this helps

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
PREMIUM
TAGS
AUG Leaders

Atlassian Community Events