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

How to filter a query between a date range

Kevin Berrio

I have this query:

project = SD AND issuetype in standardIssueTypes() 
AND status in (Closed, "SD: Resolved") AND assignee 
in (currentUser()) order by created DESC

How can I add some JQL so that it will tell me how many tickets are done in a week?

Thanks again

Accepted answers

Ben Poulson

Is this for a specific week (like February 1-8), or for a week relative to when the query is being run (like 2 weeks ago)?

All comments

Ben Poulson

Is this for a specific week (like February 1-8), or for a week relative to when the query is being run (like 2 weeks ago)?

Kevin Berrio

Relative week. I essentially want to be able to run this any week to get info on my previous week in a calendar year.

Ben Poulson

Add this to your query:

resolutiondate >= startOfWeek(-1) and resolutiondate <= endOfWeek(-1)

This will pull tickets that were resolved last week (if you want to see tickets created last week, just replace resolutiondate with createdDate). Note that jira defines a week as Sunday-Sunday, so if you run it today, it will pull anything resolved between 12:01 AM on Sunday the 3rd and 11:59 PM on Sunday the 9th. If you want it to be relative to the day of the week the query is run on, replace startofweek(-1) with startofday(-12) and endofweek(-1) with endofday(-6).

Kevin Berrio

Thank you so much for this info!

I'm still fairly new to the JQL scene, so, where would I add that to my query?

Welcome!

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

Quick Links

Find more posts tagged with

jira

filter