Having trouble including Epics in this filter

[Andrei Pogorelet]

Hello, I am using the following JQL to get all issues from specific projects that have an epic link, however I can't get the epics themselves as well. A little help please?

project in (123, 234, 345, 456, 567, 678) AND issuetype in ("Analysis/Estimation Request", Bug, Epic, "New Feature", Story, Task, "Issue Bug", Sub-Task) and "Epic Link" is not EMPTY 

Thanks!

[Tarun Sapra · Accepted solution]

Hello @Andrei Pogorelet

This should do the trick

project in (123, 234, 345, 456, 567, 678) AND ((issuetype in ("Analysis/Estimation Request", Bug,  "New Feature", Story, Task, "Issue Bug", Sub-Task) and "Epic Link" is not EMPTY) OR type = epic)

[Andrei Pogorelet]

Thanks for the reply Tarun, but unfortunately this brings me all the epics from Jira, and I need only the ones from the projects mentioned in the query.

Sorry if I wasn't clear about this in my original post.

[Tarun Sapra]

try this one

project in (123, 234, 345, 456, 567, 678) and (type = epic or (issuetype in ("Analysis/Estimation Request", Bug,  "New Feature", Story, Task, "Issue Bug", Sub-Task) and "Epic Link" is not EMPTY))

[Andrei Pogorelet]

Thanks a lot Tarun. All seems to work great now!

[Tarun Sapra]

your welcome @Andrei Pogorelet , please accept/upvote answer so that others are helped as well.