Querying secondary links between issues

bduncan
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
December 10, 2024

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?

 

2 answers

0 votes
Kristian Walker _Adaptavist_
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
December 12, 2024

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
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
December 12, 2024

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

 issueInProject(issuesInEpic(Tasks)))

 

Kristian Walker _Adaptavist_
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
December 12, 2024

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.

0 votes
Harrison Ponce
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
December 10, 2024

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
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
December 10, 2024

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

Suggest an answer

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

Atlassian Community Events