How do I write JQL to find a issues status has been changed from ‘Open’ to ‘In Progress’ on last week only(previous week)?
My JIRA version is 5.0.2
Please help on this!
You can use the Updated Date field or you can specify which field you want to see that updated:
project = "Project Name" AND status changed FROM "Status 1" TO "Status 2" DURING ('yyyy/MM/dd', 'yyyy/MM/dd') BY "username"
This way you can search between certain dates, by user and by field.
I don't think that you can specify if any field was updated.
I hope this helps somewhat
Hi @Liam Maeder , I tried what you provided and it worked. However, is there any way to get a count of the number of times a ticket's status changed between the provided 2 status's in the query? Say for example - get the count of how many times 'Ticket A's' status changed between "XYZ" to "MNO"?
If status changed From "In Progress" To "Done" on single days by 2 users, then it;s showing for 2 users or 1 user.
Eg:- Case Id 1234, Riyaz has changed status as "In Progress" To "Done" at 8 AM.
then similarly Mayank has changed status as "In Progress" To "Done" at 5 PM.
So Case Id's showing 2 times while applying this query?
project = *** AND Status changed from ("In Progress") to (Done) during ("2020/04/05 7:30", "2020/04/06 7:30")?
i need to know the jql for issue which remains in particulara status lets say "In Progress" for two weeks, how can i achieve this,
Appreciate your help.
Thanks and regards,
I haven't tried it but maybe something like this?
1. Create a filter to find all issues where status changed in the last 2 weeks
status changed after -2w
2. Write a query to find all issues which are in status "In progress" but not in the filter created in step 1.
status = "In Progress" and filter != "Filter in Step1"
Thanks for your valuable support,the first one which you have suggested as,
status="In Progress" AND not status changed after -2w
solved my problem,
Thanks and regards,
This question seems to be duplicate of your own question https://answers.atlassian.com/questions/53861/how-do-i-write-jql-to-find-all-the-issues-has-been-changed-status-from-open-to-in-progress-on-last-week
Good stuff here!
For my filter I wanted to know what our backlog of bugs last month was
issuetype in (Bug) AND
resolution is EMPTY AND createdDate < startOfMonth() OR
resolutiondate >= startOfMonth(-1) AND resolutiondate <= endOfMonth(-1)
status changed before startOfMonth()
Get bugs that were open last month
Bugs closed last month
Don't get bugs closed this month
Hi all - I would like to have a query for bugs "In Review" for more than 1 day (project in ("Operations Manager") AND issuetype in (Bug) AND status = "In Review" AND NOT status changed after -1d ORDER BY priority DESC, created ASC, status DESC) but adding to this I also would like to see '' last status transaction date'' How do I get that ? Ia m not looking for date range I am looking for specific dates when the status got moved to IN-REVIEW from the list of bugs.
Connect with like-minded Atlassian users at free events near you!Find an event
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no Community Events near you at the moment.Host an event
You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events