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

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

 

Untitled.png

2 answers

1 accepted

Accepted Answer
0 votes

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.

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

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

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.

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

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.

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

Suggest an answer

Log in or Sign up to answer
Community showcase
Published yesterday in Jira Ops

Jira Ops Early Access Program Update #1: Announcing our next feature and a new integration

Thanks for signing up for Jira Ops! I’m Matt Ryall, leader for the Jira Ops product team at Atlassian. Since this is a brand new product, we’ll be delivering improvements quickly and sharing updates...

300 views 0 6
Read article

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