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

[Chaitanya Ivaturi]

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! 

[John Funk · Accepted solution]

Hi Chaitanya - Welcome to the Atlassian Community!

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

[Chaitanya Ivaturi]

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]

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

[Chaitanya Ivaturi]

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. 

[John Funk]

Great! Glad you found that.