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

How to add the options in database for Database Information type selection

Mark Cai Mar 02, 2016

I created a advanced custom field which type is 'DataBase Information' in jira. I want to add some options for this selection, but I didn't find any related datatables to set the options for it in JIRA database. Is there anyone know which table should I use to insert options? Any helps will be appreciated.

1 answer

1 vote
Nic Brough [Adaptavist] Community Leader Mar 02, 2016

None - you should not write to a JIRA database.  That's the short easy answer.

The longer one is that we need a bit more information.  You've said you've got a field that is of type "database information".   JIRA does not have that type of field in it, so it's been added by one of the database field add-ons, but we can't really answer your question until we know which one of the add-ons it is, and how the field has been configured - i.e. what database and table is it pointed at?

Mark Cai Nov 27, 2016

Hi Nic,

Sorry for not replying in time. As you have mentioned, finally I found the item in add-on section. There are some sqls tell me which table should I use to add the options. Thanks for your help.

Mark.

Suggest an answer

Log in or Sign up to answer
This widget could not be displayed.
This widget could not be displayed.
Community showcase
Posted in Jira Core

How to manage many similar workflows?

I have multiple projects that use variations of the same base workflow. The variations depend on the requirements of the project or issue type. The variations mostly come in the form of new statuses ...

742 views 7 0
Join discussion

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