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)
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:
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
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.
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
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.
@Bill Sheboy Hi! Thank you for answer! It's worked!
@Marc -Devoteam- hi! Thank you!
@Doreen Undiri Hi! Thank you !
It looks like you're new here. Sign in or register to get started.
