How can i get the tickets in JIRA that are first time moved to any specific status?
Example, status "Awaiting Support" can be moved any number of times from different statuses in JIRA as needed. But i wanted to extract the number of tickets that moved to "Awaiting Support" for the first time.
Hi @Vikram Rao
Jira does not count the number of times an issues reaches a status. So, if you want the exact number, you could add a costum field of type number and every time an issue reaches "Awaiting Support" again count one up.
You can get an approximate value if you query like this:
status = "Awaiting Support" and status was not "Awaiting Support" before startOfDay()
status = "Awaiting Support" and status was not "Awaiting Support" before "-2h"
These are the issues in the status "Awaiting Support" which were never before in this status before today or before 2 hours. Maybe this is exact enough for you.
I see, maybe this is it:
status changed to "Awaiting Support" during ("-30d", now()) and !(status changed to "Awaiting Support" before "-30d")
Result should be all the issues which were moved to awaiting support in the last 30 days and which were never in this status before.
We’re excited to introduce external collaboration for Confluence, now available in early access. It is available to preview for Confluence Cloud Premium and Enterprise customers. (If you're not on ...
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