How do I get Translation history between statuses in XLS export?

[Tony Montana]

How do I get Translation history between statuses in XLS export? need date and time for custom statuses. and resolved, etc

Untitled.png

[Nic Brough -Adaptavist- · Accepted solution]

Code - you'll need to find/write fields that can pull that data out of an issue history and then display it in the issue navigator.

[Tony Montana]

Hello. What are the names of these fields? Maybe there are extensions for the reports?

[Tony Montana]

How to create a report with the history (transition, status, time) of each issue?

[Nic Brough -Adaptavist-]

For a single issue, look at the history.

For many issues, you'll need to write code that can pull the data out of an issue history.   I suggested fields initially because they would come out on the issue navigator and hence be exposed to excel downloads, and you'd be able to search/sort on them. If you're now wanting to write a report, that's different, you have the option of reading the history for each issue in your report, so you wouldn't need fields.

The fields I suggested are fields you would have to write - there are no real "fields" in the history - it's a long list of changes that have been made, not a list of fields.

[Tony Montana]

The only solution at this point: The script runner, right?

[Nic Brough -Adaptavist-]

That's what I'd use, but you can do it with your own add-ons too (before Script Runner, I wrote a couple of fields that extracted the history and put them into the navigator, and I had a timeline of changes report for issues as well),

There could be other add-ons out there that might help too, but I'm rusty on them because I use SR so much now.

[Prakhar Srivastav]

Hi @Viktar Bachkouski

Please see the below link where I have written a complete solution to View and Download Status History.

http://thetechrecipes.com/index.php/2016/08/22/view-transition-history-download-xls-jira/

I have submitted it to Atlassian , if approved you can download the source code for free.

Regards

Prakhar