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.
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.
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
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!
Unfortunately there are no AUG chapters near you at the moment.Start an AUG
We're bringing product updates and pro tips on teamwork to ten cities around the world.Save your spot