It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Filter Issues by Due Date

I have three filters on a dashboard that list tasks due within 1d, 1w and 2w respectively; however using the JQL 'duedate <= 1d' etc means that an issue due within 1d will appear in all three filtered lists.

As issues cross filter date boundaries I want them to appear in only one of the three lists. So if an issue is due within one day I only want it to show in the filter that says duedate <=1 and not in the one that says duedate <= 1w or duedate <=2w (even though technically the condition is met in all cases so JIRA is displaying the correct logical result).

I can't quite work out the syntax required to filter issues between dates in this way and I may be asking for the impossible - anyone else managed to crack this or am I the only one with this particular use case?

Any assistance appreciated.

Andy

3 answers

1 accepted

6 votes
Answer accepted

Your filter for 1w should say : duedate <=1w and duedate > 1

Your filter for 2w should say : duedate <=2w and duedate > 1w

 

Thanks Marc - absolutely nailed it - spot on

Andy

Does this filter include due dates for sub-tasks? 

Hi all, i have tried it this way 

status="In Progress" AND status != Closed and due <=1w and due >1

however the system filters some random issues and overdue as well from 2018.

Is this the right way, please?

I am curious how to query if the DUE date is not filled in, we don't do this until we're ready to commit to the work but need to see the work presently in the backlog.   

duedate is EMPTY or due is EMPTY should do the trick!

Thank you William. That was just what I needed.   Bob.

How would you query filters for issues without a due date for more than a day in jira. 

 

To translate, "A jira issue created and due date field is EMPTY for more than 1 day"

We are looking to pull up issues which are created and after a day, the report will show if the due date has been left empty or not added after 1 day.

 

Thanks

Suggest an answer

Log in or Sign up to answer
Community showcase
Posted in Jira Core

How to manage many similar workflows?

I have multiple projects that use variations of the same base workflow. The variations depend on the requirements of the project or issue type. The variations mostly come in the form of new statuses ...

1,313 views 8 2
Join discussion

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you