Filter to see Epics that have an Issues assigned to me

[Sydney Peason]

Hello, I am looking for JQL which will show me "Epic" but only if there has been a child issue on that epic that has been assigned to me.

Ultimately, I am looking for a list of epics which I have worked on (even if I myself was never assigned the epic)

Thanks!

[Prosper Agwegiokhe]

Hi @Sydney Peason,

Welcome to the Atlassian Community!

My name is Prosper, a support engineer at Appfire, and I’m here to help.

If you are open a plugging suggestion, you can try out our App JQL Search Extension for Jira.

You can try out this query:

issue in epicsOfChildrenInQuery("assignee = currentUser()")

This query will return all epics, where the child or children of the epics have the current user as the assignee.

You can see more information about this query here, and please contact our support if you have any other questions about this query.

We’ll be happy to help you!

Best regards,
Prosper.

[Sydney Peason]

I can't use the plug in but thank you- this is giving me other ideas to try!

[Josh Costella]

Hi @Sydney Peason 

Welcome to the Atlassian Community!

Out of the box, what you are asking for is a bit complex through normal JQL search. However, one saved filter and a dashboard gadget and you can get the results.

All I did was create a filter for all tickets assigned to me and made sure to designate they had to have a parent.

assignee = currentuser() and parent is not empty

Then, in my dashboard, I used an Issue Statistics gadget and chose the filter I just created as the source. Then I selected Parent as the statistic. This gives me the list of Epics I've contributed towards. It's a bit of a workaround but you can still get the data.

You can also see this data at any time when you save your filter. You just need to make sure the Parent column is present.

 

[Sydney Peason]

This is good, but I realize (now) I missed a detail in my original ask:

I am looking for a list of epics, which have child issues that I have worked on, but there is a field on the Epic that is "null" - I want to build a list of epics which i need to populate this field on

Is there JQL that can reference the field on the Epic and product issues based on that?
Issues whose parent/epic "Campaign Name" is EMPTY?