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.
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.
@Henry Bada - for the record (and I'm sure you figured it out by now!), the JQL to show Jira issues created more than a day ago, and where the Due Date field is empty is:
created <= -1d and duedate is EMPTY order by created DESC
Hope that helps others who have the same question!
For JSM June Challenge #2, share how your non-technical teams like HR, legal, marketing, finance, and beyond started using Jira Service Management! Tell us: Did they ask to start using it or...
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