JQL on sub-tasks

Question

Hi,

I'm new in JIRA and after checking documentation I still need help on a JQL filter.

I have different EPIC created from different JIRA projects.

Some tasks are defined as sub-tasks to EPICS , but on different project.

How can I filter EPICS where sub-tasks="project_A" ?

Thanks for your help

Martin Bayer _MoroSystems_ s_r_o__ · Answer

@Pierre-Yves Lebreton  at least second part of the query "project in (PRJ_B) AND issueFunction in subtasksOf("project = PRJ_A")" should return no results as the Parent issue and Sub-task issue is always in one project. Can you post some screenshots of your tasks so we can help you? Or did your query work for you?

Pierre-Yves Lebreton · Answer

Thanks for your replies already

The "best" test I've done was with the follwing JQL :

project in (PRJ_A) OR (project in (PRJ_B) AND issueFunction in subtasksOf("project = PRJ_A"))  ORDER BY Classement ASC

That returns only tasks from PRJ_A, nothing of PRJ_B where sub_task=PRJ_A

I expected to get a dashboard per Epic name with related tasks

Jack Nolddor [Sweet Bananas] · Answer

Hi,

Sadly you cannot achieve the desired search using standard features on Jira, you must go for a third-party app instead. Using i.e. JQL Booster Pack if you are on Server / DataCenter, you can type the following:

1) Search all Epics linked to issues on 'EMEA' project

issue IN epicsOf(' project = EMEA ')

(*) Note that this is just an example, you must tune above query to fit your needs.

Using this app you can also query other issues relations, check:

* epicsOf()
* hasSubtasks()
* issuesInEpics()
* linkedIssuesOf()
* parentsOf()
* portfolioChildOf()
* portfolioParentOf()
* subtasksOf()

References:

* Official documentation