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

Question

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')'.

Leigh Cameron_ozb12v · Answer

(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.

Sita Raghunadh Vedala · Answer

You can refer the below post by Mystic Lin

https://community.atlassian.com/t5/Jira-questions/Show-all-sub-tasks-for-a-specific-Issue-Type/qaq-p/1491133

Earl McCutcheon · Answer

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:

* https://jira.atlassian.com/browse/JRACLOUD-21936
* https://jira.atlassian.com/browse/JRASERVER-21936

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:

* https://docs.adaptavist.com/sr4js/latest/features/jql-functions/included-jql-functions/sub-tasks

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