Exporting values to excel from work log drop-down list

Hi,

I have created custom worklog attributes including a dynamic drop-down using /rest/tempo-rest/1.0/accounts/json/getDynamicDropdown/|1|2|3|4|5|.... When I export my Temop report/list to Excel it exports the INDEX of the drop-down values but not the values, which is not useful to me. Is this a bug? How can I export the values from the drop-down list to excel?

Thank you

2 answers

1 accepted

Hi Lusine,

Tempo returns the index, but this does not need to ba a number. You can use the same values as the index indicates. So f.x. instead of using

...getDynamicDropdown/|1|2|3|4/Please Select|Red|Yellow|Green|Blue

you can use

...getDynamicDropdown/|Red|Yellow|Green|Blue/Please Select|Red|Yellow|Green|Blue

Kind regards,

Susanne

It worked! Thank you Susanne!

1 vote

I'd say it's a bug in Tempo. Jira moved from storing the text of options to storing a pointer to option (a much better way to do it) quite a while ago, and I suspect that Tempo hasn't kept up with that

However that would surprise me. I'd have expected Tempo to fix that pretty quickly, certainly by now given how long ago it changed.

What version of Tempo and Jira are you on?

I am on JIRA v6.1.2 and Tempo Timesheets - 7.8.2 ... both of them are pretty new I think.

Mmm, yes, I'd raise this with Tempo. It should be able to handle the new select lists by now (I say "new", I'm looking at Jira 4.4 I think!)

Thank you for your help Nic, do you know how I can report a bug to Tempo? Or should I just send an email to Tempo support?

Never mind, I am all set. Was able to report the bug. Thanks for your support.

Suggest an answer

Log in or Sign up to answer
How to earn badges on the Atlassian Community

How to earn badges on the Atlassian Community

Badges are a great way to show off community activity, whether you’re a newbie or a Champion.

Learn more
Community showcase
Published Monday in Jira Software

How large do you think Jira Software can grow?

Hi Atlassian Community! My name is Shana, and I’m on the Jira Software team. One of the many reasons this Community exists is to connect you to others on similar product journeys or with comparabl...

397 views 5 10
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