Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
Deleted user
0 / 0 points
Next:
badges earned

Your Points Tracker
Challenges
Leaderboard
  • Global
  • Feed

Badge for your thoughts?

You're enrolled in our new beta rewards program. Join our group to get the inside scoop and share your feedback.

Join group
Recognition
Give the gift of kudos
You have 0 kudos available to give
Who do you want to recognize?
Why do you want to recognize them?
Kudos
Great job appreciating your peers!
Check back soon to give more kudos.

Past Kudos Given
No kudos given
You haven't given any kudos yet. Share the love above and you'll see it here.

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

How can i get the tickets in JIRA that are first time moved to any specific status?

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.

 

Appreciate support.

2 answers

1 accepted

1 vote
Answer accepted
Thomas Schlegel Community Leader Jul 17, 2019

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()

or

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. 

Thomas, thanks for the input, but this doesn't serve my purpose.

 

I wanted the tickets which are moved first time to that status in a specified duration, say in a month.

Thomas Schlegel Community Leader Jul 17, 2019

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.

Looks like this is very close to my requirement, i will check and revert back on this.

 

Thanks Thomas, appreciate your help.

Hello @Vikram Rao 

There is no bundled solution for that, you need to do some workaround.

Alternatively, you can use Enhancer Plugin . It has Status Counter custom field in which you can configure how many times the issue was moved to configured status.

Suggest an answer

Log in or Sign up to answer
TAGS
Community showcase
Published in Confluence

Introducing External Collaboration for Confluence

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 ...

218 views 0 8
Read article

Community Events

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

Events near you