How to write a query to remove certain epics from issuesInEpics

Question

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")

Walter Buggenhout · Accepted Answer

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!

Bharat Kalia · Accepted Answer

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