How find issue from jql witch in status = 7 day ?

[Alex]

Hi, atlassian community!

Please i need your help !)

How  i can  find issue from jql , witch in status = 7 day ?

(no more and no less)

[Bill Sheboy · Accepted solution]

Hi @Alex 

With the built-in features of JQL, this condition can only be detected relative to "now", and cannot find the information for other days in the past.  If you want to search issues meeting this criteria in the past, please investigate marketplace addons to enhance JQL or reporting.

Assuming you want this relative to "now", there are several parts to detect what you asked:

• an issue is in status X
• the issue transitioned to status X exactly 7 days ago
• the issue has not transitioned to any other status during the last 7 days

If the status was "In Progress", this may work for you:

project = yourProjectName
 AND status = "In Progress"
 AND status CHANGED TO "In Progress" ON -7d
 AND NOT status CHANGED AFTER -7d
 ORDER BY Key ASC

Please review this documentation to learn more about creating queries with the status changing operators: https://confluence.atlassian.com/jirasoftwareserver100/advanced-searching-operators-reference-1442844125.html

Kind regards,
Bill

[Marc - Devoteam]

I learned something, mine didn't work as expected.

It also gets issues set in a status ago, but if you change the status and then put it back in the previous status it pops up in the filter based on historical change being within the timeframe.

[Alex]

@Bill Sheboy Hi! Thank you for answer! It's worked! 

[Doreen Undiri]

Hi @Alex 

You can use 

status changed TO "Your Status Name" DURING (-7d, -7d)

whereas 

status changed TO "Your Status Name": This will Filters issues that transitioned to the specified status.( replace the your status name with the actual status of the issues)

and

DURING (-7d, -7d): Matches issues that changed to this status exactly 7 days ago

goodluck 

---

dd

[Alex]

@Doreen Undiri Hi! Thank you !

[Marc - Devoteam]

Hi @Alex 

You cold use the following JQL:

status = "Your Status" and status changed to "Your Status" during ("-7d","7d")

this will give you an issue set to a status 7 days ago and still is in that status.

[Alex]

@Marc - Devoteam hi! Thank you!