JQL child issue query accross project

[Michael Rückert]

We have several projects which have issues in each other projects, i.e

P1
P2

We are working with epics i.e. P1-1,P1-2, etc. and P2-1,P2-2 having issues in epic P1-1

P1-10
P2-10

and in epic P2-1

P2-20
P1-20

To summarize the worklog we need to select all issues by JQL on per project base. Of course, the total sum of hours is higher than the real sum, as the issues are collected multiple times.

The JQL query

project='P1' or issue in childIssuesOf('P1-1')

returns all issues, but the parameter P1-1 is fixed and should collect all epics from P1, i.e. P1-1, P1-2, etc.

I hope, I was clear enough, some help is appreciated, thanks in advance.

Regards Andreas

[Alexey Matveev · Accepted solution]

Hello,

If you want a flexible solution then you need a plugin like ScriptRunner. You can use the issueInEpics JQL function.

https://scriptrunner.adaptavist.com/latest/jira/jql-functions.html#_issuesinepics

[Michael Rückert]

Thanks mate, made my day. Was not issueInEpics , but the function linkedIssuesOfRecursive was the solution:

project="P1" OR issueFunction in linkedIssuesOfRecursive("project = P1") ORDER BY key ASC