Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
Deleted user
0 / 0 points
badges earned

Your Points Tracker
  • Global
  • Feed

Badge for your thoughts?

You're enrolled in our new beta rewards program. Join our group to get the inside scoop and share your feedback.

Join group
Give the gift of kudos
You have 0 kudos available to give
Who do you want to recognize?
Why do you want to recognize them?
Great job appreciating your peers!
Check back soon to give more kudos.

Past Kudos Given
No kudos given
You haven't given any kudos yet. Share the love above and you'll see it here.

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

way to automatically populate select list options


I have a custom field which is a select list -- with a very long list of options that I would like to have. Is there any way to systematically populate the options for a select list? Like, from an excel sheet or external database connection?

I am running downloadable JIRA 5.2 as as standalone application.



4 answers

1 accepted

2 votes
Answer accepted

Hi Andrew, I actually did that in the database. It's never recommended to do that, but in my case I had like five select list custom fields to populate with more than a thousand options so it was that or nothing for me.

Here's another question about that:

Not finding the one I did about this...

As much as I try I don't remember the name of the table, but you can insert directly there the options with a script. One table is to define the customfields and another to populate it's values. Obviously you have to stop Jira service to do changes on the database.

Excellent -- lots of options -- thanks!

@Andrew Nicholson  @Ramiro Pointis hy ramiro ,can u plz help me out in cascading select list in jira from excel sheet

You can use Script Runner to import values for custom fields.



How can I import values from csv to a jira single selection custom field  fields using scriptrunner? Can you please write the steps?

Hello @Ramiro Pointis , @Andrew Nicholson , @Mizan and @Henning Tietgens  

Could you please let me know how did you achieve this requirement?

I want to do something similar

Thanks and Regards,

Swapnil Srivastav.

It was not a requirement I implemented but an answer to the original question. 

Did you try to explore the answers especially the accepted one.

Asking a new question might be better.

Hello @Mizan ,

Thank you for the response. 

I have not tried Database values plugin, reason being : I need values from Jira only, I was not sure whether that would work or not. I am trying it now. 

Here's my original request:


Kindly suggest any solutions

Thanks and Regards,

Swapnil Srivastav

Suggest an answer

Log in or Sign up to answer

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you