for process verification purposes, I need to extract information on existing JIRA issues from our JIRA installation... In particular, I need to know who executed which transaction hsa been executed when by whom for a particular issue (ideally: for a particular set of issues). I need not only "Status A -> Status B" as shown by Jira Suite in the "Transitions" tab, but more like which button was klicked by which user and when; also - if a transition has bene executed several times, then JSU does not show all of the executions but only the last one...
Many thanks in advance
It's in the issue history tab - you need to look for each change of status (The jira suite utilities is just summarising information it's pulling from there)
There's no way of knowing what "button was clicked" though - there are many ways of triggering a transition and how they are triggered is completely irrelevant, it's the fact that the person logged as doing it was granted permission to do so by your security settings that matters.
is there any way to query the contents of the history tab via SQL? We need it for quite a bunch of issues, and navigating to each individual issue seems a bit cumbersome...
Regarding "Button pressed": the "button pressed" is actually the transition's name. Is there anyway to find out that particular name?
There might be several transitions from one step to another, therefore knowing the start and end of a transition is typically not sufficient...
Absolutely, although it's better presented in the history tab.
I'm not sure what the best angle for your needs are, so I'll explain how I'd do it for a single issue, just to explain the relationship.
You need to look at three tables. Jiraissue contains the issue, most importantly, the unique and immutable issue-id. You can read changegroup, which is the list of changes made to an issue by the time they were made. You'll find each line has a unique ID, then the issued-id, and then you'll be interested in the date, time and author of the change. Finally, you take the changegroup.id and use that to select the groupid from changeitem. Changeitem lists each separate change that was made to the issue during that edit or transition. So you'll find reading changeitem for "status changed from xxx to yyy" is the eventual answer.
The "button pressed" is harder and easier. What I was getting at was that it's not always a button - it could be a drag and drop on an Agile board, an update by a listener, a REST call from the outside, etc. But it will always be a transistion. Problem is the transition is not recorded, just the change of status - this is because workflows can change, and actually, the transition is still not important. It's the "to status, from status, who and when" you really want. If you've got several transitions doing the same change, I'm afraid you're stuck - that's simply not recorded (and you can't because if I edit a workflow, I could easily remove or change a transition)
basically you are right and what I need is the transition name.
And this is why I need it (and not only who/when/from where to where):
In our workflow, we have a status called... Let's say "Waiting for approval". Now there are two different transitions going from this state to the "approved" state: one is the normal "Approve" and the other one is "Emergency approve" - both of them have different conditions (i.e., "Emergency approve" can be pulled off by a wider group of people) and both have different post-functions ("Emergency" sets some flags, which trigger an "Emergency review" in the later process).
With this being said, for audit purposes, I need to be able to tell "Emergency approve" from "Approve"...
Does this make sense to you?
Many thanks in advance
In the past, Portfolio for Jira required a high degree of detail–foresight that was unrealistic for many businesses to have–in order to produce a reliable long-term roadmap. We're tur...
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
You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs