I am struggling to find the right JQL to write for a filter. I need a filter that gives me anything open, no matter when it was created, and anything that was closed last week or this week. * If I run the report today (Wed Jan 25) I want to see issues created Jan 15th through today 25. * If I run the report tomorrow it will be Jan 15 through the 26th * If I run the report on the 30th it will be Jan 22 through the 30th * If I run the report on Feb 3rd it will be Jann 22 through the 3rd. I only want one query that I will never update. Any suggestions? This is what I have and it appears to work but just not sure so wanted to verify.: project = xxxx AND issuetype in standardIssueTypes() AND status in (xxxx) AND created >= startOfWeek(-1w) ORDER BY created ASC, status DESC

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; } } }

JQL filter search previous week and current week (Jira Cloud)

Raoul Kaiser

I am struggling to find the right JQL to write for a filter. I need a filter that gives me anything open, no matter when it was created, and anything that was closed last week or this week.

If I run the report today (Wed Jan 25) I want to see issues created Jan 15th through today 25.
If I run the report tomorrow it will be Jan 15 through the 26th
If I run the report on the 30th it will be Jan 22 through the 30th
If I run the report on Feb 3rd it will be Jann 22 through the 3rd.

I only want one query that I will never update. Any suggestions?

This is what I have and it appears to work but just not sure so wanted to verify.:

project = xxxx AND issuetype in standardIssueTypes() AND status in (xxxx) AND created >= startOfWeek(-1w) ORDER BY created ASC, status DESC

Accepted answers

Mikael Sandberg

The query that you have is correct, it will give you all issues in the specified project, that are in the specified statuses and was created on or after start of last week. You can actually remove the w since that is implied by the function. Note that start of week is Sunday, and end of week is Saturday.

All comments

Mikael Sandberg

Raoul Kaiser

Sorry, I was told I understood the query wrong so I updated the question. I need anything open, no matter when it was created, and anything that was closed last week or this week.

Mikael Sandberg

Okay in that case you would have to use OR in you query, something like this:

project = xxx AND (status = open OR (status = closed AND resolutiondate >= startOfWeek(-1)))

This query will search project xxx for all issues that are open OR issues that are in the closed status and had the resolution set since last week until today.

You could remove status = closed if you have more than one terminal status that sets the resolution.

Raoul Kaiser

Thank you for your help. I believe this will get me where I need to go.

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-software

jira-software-cloud