I'm trying to create a filter for viewing the issues (all issue types) which are due last week.

Chaitanya Ivaturi April 15, 2024

I'm trying to create filer to view all the issues which are due last week on the project board. Tried multiple queries that I've found online in this community as well. I'm getting few results while using this. 
------

project = "--" and (status = "In Progress" OR (status = closed AND DueDate > startOfWeek(-1)))
------
In the above query, If i try to add more statuses i see no issues (blank board)
Here my requirement is that I want to see all the issues which has due dates that are due in previous week irrespective on the status excluding resolved or done tickets.
Thanks in advance! 

1 answer

1 accepted

1 vote
Answer accepted
John Funk
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
April 15, 2024

Hi Chaitanya - Welcome to the Atlassian Community!

Project = ABC AND DueDate > startOfWeek(-1) AND DueDate < startOfWeek()

Chaitanya Ivaturi April 15, 2024

Hey John, Thank you for the response. 
I've tried what you have suggested, But the board is showing empty. 


Is there any prerequisites fields that needs to be filled in order the results to show up. Currently I'm using just due date field in the custom fields section.

Any other fields to be filled for this to work ?

John Funk
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
April 15, 2024

Yes, the due date needs a value. Run this query in the Search/Filter area to see if there are results there.

 

Chaitanya Ivaturi April 16, 2024

Hey John, Thanks a lot!
The query is working. The issue I was facing is a redundant field of "Due Date" which was created and wasn't a system field (Due date) which wasn't being used. Changed that and it's working now. 

Like John Funk likes this
John Funk
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
April 16, 2024

Great! Glad you found that. 

Suggest an answer

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

Atlassian Community Events