nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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

Vikram Rao

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.

Accepted answers

Thomas Schlegel

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.

All comments

Thomas Schlegel

Hi @Vikram Rao

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.

Vikram Rao

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

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.

Tuncay Senturk _Snapbytes_

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.

Vikram Rao

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

Thanks Thomas, appreciate your help.

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira-core