Help me write a query to search for issues with a Parent Link and specific assignee

Question

I am attempting to create a query that would show a custom issue type that is expected to have a parent link to an epic. Furthermore, I'd like to only see custom issues with a parent link to an epic and a specific user.

Is this possible? I figured I'd save the hours of testing this and just ask the community!

Walter Buggenhout · Answer

That is going to be difficult to impossible without marketplace apps I'm afraid. Finding issues of a specific type assigned to a user would be possible like this:

issuetype = Task and assignee = currentUser() and parent is not empty

would return all issues where the assignee is the logged in user, while the parent is filled out. Jira's hierarchy enforces that the parent of a task is an Epic, so you know that all returned issues have an epic as a parent.

If you want to find a list of epics based on what is essentially a sub-query, Jira has its limitations. There are a couple of marketplace apps that may help you overcome this constraint.

With Scriptrunner enhanced search, you can use the function epicsOf(), while JQL Search Extensions offers an equivalent function called EpicsOfChildrenInQuery().

Jordin_ebsw53 · Answer

Something like that 😂

It feels what I am trying to do is a bit backwards but it would be really insightful to the work I am doing to be able to get a list of epics that are linked to a sub-level custom issue type.

Jordin_ebsw53 · Answer

Yes, #1. I'd like to query and get a list of epics that are directly linked to a sub-level custom issue type.