How can I get the parent JIRA by searching the sub-task JIRA

[Yi Liang]

Hi All,

I would like to retrieve the parent jiras by searching their subtasks.

For example, I would like to get the list of parent JIRAs whose sub-task is tested.

How can I write the JSQL?

Many Thanks 

[Vishal Biyani]

@Yi Liang 

if you have access to JIRA Automation, then you can use it to get details in an email.

Example rule

1. Trigger

You could define a trigger based on your need. I have used Manual Trigger for demo purpose.

2. In the Lookup issues, add the JQL as per your requirement.

Let me know if this is something that works for you

[Trudy Claspill]

Hello @Yi Liang 

With only native Jira searching capabilities you can create a search for the subtasks and display the Parent issue key and summary in the results output.

Do you need information from the parent issues besides their key and summary? Only the parent key and summary is available in this manner with native Jira issue search capabilities.

What do you want to do with the output? Depending on what you want to do with the output there may be alternative ways to get the information without using the Jira issue search UI.

If you specifically need to construct and save an issue search filter where the results set is only the parent issues and you can also see other information from the parent issue, that would require a third party app that extends the Jira issue search capabilities.

Some of those app remain Free if you are using a Free Jira subscription. I notice your post tags indicate you are on the Free plan. Would you be willing to consider a third party app, if you requirement is to get a list of only the parent issues and more information about each parent issue?

[Yi Liang]

Hi @Trudy Claspill ,

I tried your suggestion, and I got a list of sub-tasks.

I would like to have the output to be the parent jira no, description, reporter, etc., , not the sub-task.

Sometimes, there are multiple sub-tasks pertaining to one parent jira.

Is there any way to make it happen?

Thanks

Liang Yi

[Trudy Claspill]

As I said in my response...

The initial solution gives a list of subtasks, and you can show the key and summary for the parent issue by adding the Parent column to the output.

With only native functionality you cannot get what you want. It will require a third party app.

[Yi Liang]

However, I cannot create a confluence page to show the parent jiras.

I cannot find a proper field on the setup