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

Get all issues which was open in the last 7 days

DEMARCHE Baptiste

Hello,

I want to create a filter to get all issue which was in a status in the last 7 days but every time I do something older issues appears. My jql query is :

project = CS AND type = Incident AND status was "Open" DURING (now(-7d), now())

I've made some research but every time it's about when it's created or resolved but not with the "was" condition.

Thanks

Accepted answers

John Funk

Hi @DEMARCHE Baptiste ,

Maybe try:

project = CS AND type = Incident AND status was "Open" after startOfDay(-7)

All comments

John Funk

Hi @DEMARCHE Baptiste ,

Maybe try:

project = CS AND type = Incident AND status was "Open" after startOfDay(-7)

Ste Wright

Hi @DEMARCHE Baptiste

Can I clarify the need here:

All issues in the CS project
Of type Incident
Where the status was "Open" at some point between 7 days ago and today

^ To be clear, this will provide any issue which has been in the specific status "Open" within the 7 day period, regardless of its age or current status. It will also provide issues which are still in "Open" now.

The JQL I would use is:

project = CS and issuetype = Incident and status was "Open" DURING (startOfDay(-7),endOfDay())

Ste

Nic Brough -Adaptavist-

Your query, in plain English, is not quite what I think you mean it to be.

You are asking for "all CS Incidents that have been in a status of Open in the last 7 days"

I think what you want to ask for is "all CS Incidents that were created in the last 7 days"

The difference between those two is quite significant - the first question will be returning issues that could have been created at any time, and had an open status at some point in the last week. The second only looks at issues created in the last week.

If "open" is not the status that new issues take when created, you may want to combine those two queries together as well.

The second query would be "project = CS AND type = Incident AND created > -7d"

DEMARCHE Baptiste

Yes thank you, it's better.

Soem errors appears but it's an intern problem

Really thank you

James Riley

Thanks, the "created > -7d" was all i needed to add

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

filter

date