nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

way to automatically populate select list options

Andrew Nicholson

Hello,

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.

Thanks

Andrew

Accepted answers

Ramiro P

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:

https://answers.atlassian.com/questions/53463/populate-custom-field-based-on-data-from-another-ms-sql-database

Not finding the one I did about this...

All comments

Ramiro P

Here's another question about that:

https://answers.atlassian.com/questions/53463/populate-custom-field-based-on-data-from-another-ms-sql-database

Not finding the one I did about this...

Ramiro P

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.

Ramiro P

Andrew, here's another solution:

https://answers.atlassian.com/questions/92385/importing-project-from-another-jira-instance-how-do-we-mass-import-custom-field-multi-select-options?page=1#92622

Henning Tietgens

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

Henning

Mizan

You can use the Database values plugin https://marketplace.atlassian.com/plugins/org.deblauwe.jira.plugin.database-values-plugin

Andrew Nicholson

Excellent -- lots of options -- thanks!

SWAPNIL SRIVASTAV

Hello @Ramiro P , @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.

Mizan

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.

SWAPNIL SRIVASTAV

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:

https://community.atlassian.com/t5/Jira-questions/Is-it-possible-to-have-a-scripted-select-list-which-contain/qaq-p/1211810#U1218384

and

https://community.atlassian.com/t5/Jira-questions/How-to-add-dynamic-options-to-a-single-select-list-field/qaq-p/1218396?utm_campaign=#U1218444

Kindly suggest any solutions

Thanks and Regards,

Swapnil Srivastav

Maro Hamamjyan

Hello,

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