JQL to display the list of overdue epics ?

[Vinayak Biradar]

Hello all.
I need an JQL to display the list of epics which wil display epics which are overdue with reference to due date ?

Also JQL for epics which will be due in next 30 days ? 

Thanks for the support in advance.

[John Funk · Accepted solution]

Hi Vinyak - Welcome to the Atlassian Community!

For the first one, try: project = ABC and issuetype = Epic and duedate <= startOfDay() and statusCategory != Done

For the next 30 days:

project = ABC and issuetype = Epic and duedate >= endOfDay(-30) and duedate <= endOfDay(30) and statusCategory != Done

[Kseniia Trushnikova · Accepted solution]

Hi,

issuetype = Epic AND due <= "0"

issuetype = Epic AND due <= 30d

[Diogo Teles · Accepted solution]

The JQL you would use to display the list of epics which are overdue would be something like this:

issuetype = Epic AND duedate < now()

This will list all Epics where the due date is in the past (overdue).

For the second part of your question, to find the Epics which will be due in the next 30 days, you would use this JQL:

issuetype = Epic AND duedate >= now() AND duedate <= 30d

[Vinayak Biradar]

Thanks all