JQL on sub-tasks

[Pierre-Yves Lebreton]

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

[Jack Nolddor _Sweet Bananas_]

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

[Pierre-Yves Lebreton]

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

[Martin Bayer _MoroSystems_ s_r_o__]

@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?

[Martin Bayer _MoroSystems_ s_r_o__]

@Pierre-Yves Lebreton can you post some screenshot of the relationship between issues? Because Issue and its Sub-task must be always in one project, so is it really subtask to Epic? Or is it issue linked to Epic?