Querying secondary links between issues

[bduncan]

I'm trying to build a list of issues (tasks) that are children to an issue (epic) that implements an issue (project).

I've attempted to query for this without success. I found some examples of traversing the relationships but I could only locate solutions that require ScriptRunner - I do not have access to ScriptRunner.

I've also explored using Automation to mark the Epic from the Project, and then mark the Task from the Epic. When an Epic is created, if there is a relationship 'implements' then flag the issue as 'project-epic'. When a Task is created, if there is a Parent and the Epic has this 'project-epic' flag then flag the Task with 'project-task.' But I'm having issues with the nesting and when best to trigger the behavior.

Ideas?

[Kristian Walker _Adaptavist_]

Hi bduncan,

I can confirm that you can achieve this requirement using either the Enhanced Search for Jira Cloud plugin or the Enhanced Search feature of the ScriptRunner for Jira Cloud plugin.

Using this, you can use the issuesInEpics() function to find all issues that are tasks inside Epics.

I hope this information helps.

Regards,

Kristian

[bduncan]

Can the functions be nested? In my example it would need to be something like...

 issueInProject(issuesInEpic(Tasks)))

[Kristian Walker _Adaptavist_]

You can nest functions but please note in Jira cloud you need to use the issueFunction keyword first like the examples in the docs mention and you must run these on the enhanced search page in Jira Cloud.

[Harrison Ponce]

Hi @bduncan , just want to clarify here. You want a way in JQL that you can find tasks where:

• The task is underneath an epic
• The epic of that task has a linked issues relationship to a project (assuming custom issue type)

Is that right?

[bduncan]

Yes, a list of Task where this relationships is present - the Task is a child to an Epic that implements a Project.