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 to find a status change during beginning date through 2 weeks

Jay Whitman

I'd like to have a JQL filter that looks for all items whose status changed within a 2 week time frame starting with a specific date. I know I can enter two specific dates, but, since I need to change this filter every two weeks, I'd like to just change the first date.

This is what I currently have:

status changed to Closed during (2024-11-07, 2024-11-20)

But what I'd like to do is something like:

status changed to Closed during (2024-11-07, +2w)

Hopefully that makes sense.

Any suggestions?

Accepted answers

All comments

Trudy P Claspill

Hello @Jay Whitman

What you have can be used if you remove the "+" character.

What are you doing with the output of the filter?

You could create a Saved Filter and Subscribe to the saved filter to automatically receive the output every two weeks on the day of the week that corresponds to the dates you are using in the first position. Then you could use a filter like this:

status changed to Closed after -2w

Jay Whitman

Hi @Trudy P Claspill

I thought the -2w represented a date 2 weeks prior to the current date? If so, that's not really what I'm looking for.

I'm looking to have a 2 week date rage based on the first date entered. So, if the first date entered is 2024-11-07, then I want the "during" time frame to be from 2024-11-07 to 2024-11-20.

I'm going to need to change this filter every two weeks but the date I change it might not always be the same day of the week. So I need the flexibility to be have a specific date range. And there may be other times when I need to choose a 2 week time frame further back in history.

Thus, being the lazy person I am, I'd like to be able to change just one date rather than figure out what the second date is (it'll always be 2 weeks after the first date) and change it as well.

Trudy P Claspill

I thought the -2w represented a date 2 weeks prior to the current date? If so, that's not really what I'm looking for.

Yes, it does. And if you wanted to get the output automatically every Monday, for example, for the prior two weeks, then using this with a saved filter to which you subscribe to receive the output every two weeks on Monday would satisfy the requirement. That is, only if you want the report on a repeating schedule.

If you want to manually change the starting date and then get the data for the two weeks following the specified date, and you need flexibility on that starting date, then you would use the "during" predicate with the date and then "2w" (without the plus sign) for the second parameter.

Jay Whitman

Thanks again Trudy.

Unfortunately using "2w" doesn't seem to do what I wanted.

I ran the following JQL and it returned 25 items.

status changed to Closed during (2023-11-07, 2023-11-20)

Then I ran this query just replacing the second date with "2w" and got 194 items.

status changed to Closed during (2023-11-07, 2w)

So the "2w" doesn't seem to represent a date 2 weeks after the first date. Bummer.

Definitely not a show stopper but doesn't quite fulfill the purpose for which I was trying to achieve.

Dan -minware-

Disclaimer: 3rd party marketplace partner

Hey @Jay Whitman - did you find a solution? If you are open to working with a 3rd party this is quick and easy with minware - set the date picker and use this expression (can be further customized depending on the level of detail you need):

We offer a free trial if you want to check it out!

Welcome!

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

Quick Links

Find more posts tagged with

jira

jql

during

unknown-hosting-type

jira-unknown-hosting-type