Exporting values to excel from work log drop-down list


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,


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 Join to answer
Community showcase
Maarten Cautreels
Posted Thursday in Off-topic

Friday Fun: What's your favourite beer/drink

As a Belgian, beer-lover and home brewer, beer is one of my great passions. I love the fact that with just a few ingredients (usually just water, hop and malt) you can create so many different tastes...

288 views 38 9
Join discussion

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
Atlassian Team Tour

Join us on the Team Tour

We're bringing product updates and pro tips on teamwork to ten cities around the world.

Save your spot