Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

JQL Filter to find overdue items will not work

Dietrich Lehr
Contributor
May 20, 2020

This filter works right up until I specify the project, and then returns nothing even though I know the duedate fields should give me some results. I can switch the project to a next gen board and get results, but my current team's board is not a next gen project because those still like key features.

Here is the filter I'm using

project = SNET AND issuetype = Epic AND status != Done AND duedate < now()

 

If I remove the project part, i can return the entire organization's projects. Changing the < to a > doesn't return anything either despite changing the Due date field

 

It seems like this should work...but it doesn't.

 

1 answer

0 votes
Jack Brickey
Community Champion
May 20, 2020

Why do you think it is failing? Are you saying the filter results in no matches? Are you sure that there are epics that are overdue in the SNET project? What does the following reveal?

project = SNET AND issuetype = Epic AND status != Done

Dietrich Lehr
Contributor
May 21, 2020

that filter you asked me to run returns 12 epics

Dietrich Lehr
Contributor
May 21, 2020

figured out the issue...for some reason the duedate value didnt work when referencing the project and I had to use the the specific name of the custom field "deadline date". Weird...

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
STANDARD
TAGS
AUG Leaders

Atlassian Community Events