Filter a subset of issues in another filter

[Thomas Cucolo]

I am looking to find all issues in a teams Q1 committed Epics.

So far I have come up with these filters

Project = ProjectX and Status != invalid and labels in (2022q1a, 2022q1b) and issueFunction in issuesInEpics("Project = 'ProjectX'")

Nothing is returned in the above filter, if I replace the AND with an OR before the issuesFunction all issues in the project are returned and I believe that is because of the OR

What is the syntax needed to combine the 2 filters ?

[Josh Costella · Accepted solution]

Hi @Thomas Cucolo

I would try something like this

issueFunction in issuesInEpics("project = ProjectX AND status != Invalid AND labels in (2022q1a,2022q1b)")

[Josh Costella]

This is also assuming you have Scriptrunner installed which from the looks of your initial JQL, you probably do.

[Daniel Turczanski - JQL Search Extensions · Accepted solution]

If you have our JQL Search Extensions, you can run:

issueFunction in childrenOfEpicsInQuery("project = ProjectX AND status != Invalid AND labels in (2022q1a,2022q1b)")

Make sure to check out more examples here.