Query to get all epics, tasks in the epics and their subtasks in a project

Question

We are using cloud Jira SW and BigGantt.

We would like to have a portfolio that includes:

- All tasks and epics from project SREST2

- For each epic, all the tasks that have an epic link to it

- For each epic or task, all the tasks that are subtasks of it

It sounds so easy but we’re scratching our heads. I can easily come up with all epics but not get the tasks associated with them.

Robin Raben_i7mqp5 · Answer

Thank you

Ziad Bakhiet · Answer

Hello Robin,

Here are the results that you can get easily using JQL Search Extensions

- For each epic, all the tasks that have an epic link to it

issue in childrenOfEpicsInQuery("project = 'SREST2' AND issuetype = Epic")

- For each epic or task, all the tasks that are subtasks of it

subTaskOfQuery = "project = 'SREST2' AND issuetype in (Epic, Task)"

The full documentation can be found here & here

Regards,

Ziad

Anna-BigPicture · Answer

Hello @Robin Raben,

You can use JQL query: 
“issuekey” = EPIC-KEY OR "Epic Link" = EPIC-LINK OR parent in (ISSUE-KEY).

However, if you have a number of epics and stories, we recommend using ScriptRunner. It’s the best way for you to write your own JQL functions.

Once a  filter is created and saved in Jira, you can add it to your Program scope in BigGantt (Program Box Configuration >> Tasks >> Scope definition). See my image as a reference.

Anna

SoftwarePlant Support