Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
Community Members
Community Events
Community Groups

Custom Field - Need to Mass Disable Multi Select Value

We imported ~1200 records into a custom field > Multi Select. We have an integration with JIRA where we map client records from our Help Desk to our JIRA system The format of these records are the following in the before side.

Recently there was a decision to update the client IDs to 7 digits. JIRA now needs updated to match so the integration works correctly.2019-08-29 11_43_09-Book1 - Excel.png

I have been successful in doing the import. Although it currently creates duplicates because of the ID. Currently, it would be ~2400 custom fields which makes navigating the list terrible with duplicates. We also need to maintain the history of the field so I cannot deletethe list and then import the new IDs.

I saw the answer in the above link and would it be able to be done through an import? From what I have seen and read, I do not believe so but wanted to ask. 

1 answer

You can disable custom field options from database. You just need to set "disabled" column on CUSTOMFIELDOPTION table. Try this on a backup system and do this change when jira is not running. 

HI Deniz

We currently have the cloud option and do not have access to the database at this time. 

Suggest an answer

Log in or Sign up to answer
Community showcase
Published in Confluence

An update on Confluence Cloud customer feedback – June 2022

Hi everyone, We’re always looking at how to improve Confluence and customer feedback plays an important role in making sure we're investing in the areas that will bring the most value to the most c...

123 views 1 3
Read article

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