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
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
@Andrew Nicholson @Ramiro Pointis hy ramiro ,can u plz help me out in cascading select list in jira from excel sheet
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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:
and
Kindly suggest any solutions
Thanks and Regards,
Swapnil Srivastav
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You can use the Database values plugin https://marketplace.atlassian.com/plugins/org.deblauwe.jira.plugin.database-values-plugin
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You can use Script Runner to import values for custom fields.
Henning
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello,
How can I import values from csv to a jira single selection custom field fields using scriptrunner? Can you please write the steps?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.