JQL for Epic

[Gor Greyan]

Hi, Dear Community,

I need a JQL that will retrieve all Epics, where all issues in the Epic are in the Done Category status.

Thanks in Advance.

[Marc -Devoteam- · Accepted solution]

Hi @Gor Greyan 

This is not doable using native JQL.

You will need a 3rd party app for this or query the database (backup first), still not recommended.

[Gor Greyan]

Hi @Marc -Devoteam-

Thanks for the answer.

I have Scriptrunner, but couldn't find any appropriate JQL. Do you know any?

[Marc -Devoteam-]

Hi @Gor Greyan 

As you are on DC, you could use;

• issueFunction in issuesInEpics("statusCategory = 'Done'")

See documentation: issue-links#issuesInEpics 

[Gor Greyan]

Dear @Marc -Devoteam-

Thanks a lot, my friend.