How to write a query to remove certain epics from issuesInEpics

[mattics phi]

Hello!

Background: I made a query to get issues in all epics with a certain field but now I want to cherry pick certain epics to remove from the filter.  How can I do that?  When searching google, I have not been able to find a solution.  Here is the current filter I have:

issueFunction in issuesInEpics("'TextField1' is not EMPTY")

[Bharat Kalia · Accepted solution]

Hi @mattics phi - Thank you for reaching out to the community. Just to clarify your result is showing children of the epics, right? If that is the case then you can add something like below - 

issueFunction in issuesInEpics("'TextField1' is not EMPTY") and parentEpic not in (issueskey1,issuekey2)

I am just guessing it because I can't really test the "issueFunction" and please forgive me if this doesn't work. 

Give it a try and let me know if helped. 

Thanks,

Bharat

[mattics phi]

Thank you, this worked!  I appreciate the quick help!

[Walter Buggenhout · Accepted solution]

Hi @mattics phi,

Assuming that you know the issue keys of the epics you would like to exclude, the following approach should work:

issueFunction in issuesInEpics("'TextField1' is not EMPTY AND Key NOT IN
(ABC-1,ABC-2,ABC-5)")

 In my example, ABC-1, ABC-2 and ABC-5 are the issue keys of 3 epics I would like to exclude.

Hope this helps!

[mattics phi]

Seeing that this helped with IssuesInEpics, I would take this answer.  Thank you for the quick response and help!