how many times in each transition

hello, I need to count, how many times the workflow is in one status. Example:

teh workflow is: Status: A, B, C. from A go to B, from B to C o to A. So I need to know how many times the workflow goes from B to A.

thanks!

2 answers

0 vote

You will have to do some custom development to report on this. Data is there in the DB and it is only a matter of extracting it and showing it to the user which is where the various plugin modules can help. A report or gadget might be enough but it depends on your requirement.

Another option is to increment a custom field value in the workflow post function but if you want to track all workflow changes, there are just too many combinations and will need lot of custom fields.

hi Jobin, thanks for your response.

Do you know any plugin to help me?

In yhe another option, how can I increment a custom field? Can I use a function?

thanks again.

0 vote

Hi Virginia,

If you'd like to go the DB approach, you may want to take a look at the changeitem, changegroup and jiraissue tables.

This should get you a list of the issues that have moved from status B to A in JIRA 6 and newer

select P.pkey,I.issuenum from jiraissue I
join project P on I.project=P.id
join changegroup CG on CG.issueid=I.id
join changeitem CI on CI.groupid=CG.id
where CI.field = 'status'
and CI.oldstring = 'B'
and CI.newstring = 'A'

Older versions should be like this

select I.pkey from jiraissue I
join changegroup CG on CG.issueid=I.id
join changeitem CI on CI.groupid=CG.id
where CI.field = 'status'
and CI.oldstring = 'B'
and CI.newstring = 'A'

Hope this helps

Silly question... this is the sort of thing I need to do. How do I go about running this query against our own Jira system? We don't use ondemand, we have our own server.

Suggest an answer

Log in or Sign up to answer
Atlassian Community Anniversary

Happy Anniversary, Atlassian Community!

This community is celebrating its one-year anniversary and Atlassian co-founder Mike Cannon-Brookes has all the feels.

Read more
Community showcase
Posted 12 hours ago in Jira

We want to know what Jira Service Desk apps you're using!

Hi Community! My name is Amir and I’m on the Jira Service Desk product marketing team at Atlassian. Our team would love to understand how you’re leveraging our ecosystem for Jira Service Desk. Wha...

35 views 0 5
Join discussion

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you