nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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!

Accepted answers

John Funk

Hi Chaitanya - Welcome to the Atlassian Community!

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

All comments

John Funk

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.

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira

cloud

jira-cloud

quick-filter