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 do I find issues that had a status of Open or In Progress in Past Weeks

unknown

How do I find issues that had a status of Open or In Progress in the week of 3/20 to 3/24 when I am running this on 4/4/2023?

I am new to JQL but I was able to get those working for the past week for closed tickets (resolved >=-8d and resolved<=-1d)

Any help would be appreciated.

Thank you,

Gloria

Accepted answers

Trudy P Claspill

Hello @[deleted]

Welcome to the Atlassian Community!

You can use the WAS IN operator with the DURING predicate.

https://support.atlassian.com/jira-software-cloud/docs/advanced-search-reference-jql-operators/#Advancedsearchingoperatorsreference-WAS

status WAS IN ("Open","In Progress") DURING ("2023/03/20", "2023/03/24")

All comments

Trudy P Claspill

Hello @[deleted]

Welcome to the Atlassian Community!

You can use the WAS IN operator with the DURING predicate.

https://support.atlassian.com/jira-software-cloud/docs/advanced-search-reference-jql-operators/#Advancedsearchingoperatorsreference-WAS

status WAS IN ("Open","In Progress") DURING ("2023/03/20", "2023/03/24")

unknown

Hi Trudy,

Thank you for your answer but I am trying to use relative dates.

Could I do DURING (-2w, -1w) I know is silly but I just don't have a clue. I tried a few things like and status CHANGED TO "Closed" AFTER startOfWeek(-14d) and status CHANGED TO "Closed" BEFORE startOfWeek(-7d) I am still testing this.

Trudy P Claspill

Hello @[deleted]

Yes, you can use relative date operators with DURING.

Is this a filter you will need to run many times?

Would you run it on a consistent schedule so that your data range would be consistently relative?

What do you want to do with the output?

unknown

I am actually using Python JQL package and yes it will be run every Monday for the week before, the week before that and so on for 4 weeks period. This is to update some graphs in PowerPoint

unknown

I was able to extract issues resolved on a certain week for current week - 1, -2, -3, etc.

AND resolved >= startOfWeek(-3w) AND resolved <= endOfWeek(-3w)

also using DURING as you suggested

WAS IN("Open","In Progress") DURING (startOfWeek(-1w), endOfWeek(-1w))

they worked.

Thank you very much Trudy.

Welcome!

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

Quick Links

Find more posts tagged with

jira

jql