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; } } }

I can't change custom field type

Pierre Cattin

Hi, I am using Jira 3.5, and I need to change some custom fields' type.

Here's what I did to test the procedure:

1. Create a new radio buttons custom field

2. Stop Jira

3. Execute:

UPDATE CUSTOMFIELD
    SET CUSTOMFIELDTYPEKEY='com.atlassian.jira.plugin.system.customfieldtypes:multiselect',
    CUSTOMFIELDSEARCHERKEY='com.atlassian.jira.plugin.system.customfieldtypes:multiselectsearcher'
WHERE ID=10570

4. Start Jira

5. Re-index

But in Jira, the type of the custom field is still radio buttons. Moreover, after doing that, it's impossible to delete the custom field (the webpage never finishes to load).

Please could anybody tell me what did I do wrong?

Accepted answers

Pierre Cattin

Ok I got it, it's because I didn't commit after the database update

All comments

Bharadwaj Jannu

you can see the answer by Maxim Abramovich

in https://answers.atlassian.com/questions/102209/how-do-i-change-the-type-of-a-custom-field

Pierre Cattin

thanks, but I used the same procedure and it doesn't work...

Bharadwaj Jannu

UPDATE CUSTOMFIELD

SET CUSTOMFIELDTYPEKEY='com.atlassian.jira.plugin.system.customfieldtypes:multiselect',

CUSTOMFIELDSEARCHERKEY='com.atlassian.jira.plugin.system.customfieldtypes:multiselectsearcher'

WHERE ID=10570

is that you tried select also in place of multiselect?

UPDATE customfield SET CUSTOMFIELDTYPEKEY = 'com.atlassian.jira.plugin.system.customfieldtypes:select',

Bharadwaj Jannu

UPDATE CUSTOMFIELD

SET CUSTOMFIELDTYPEKEY='com.atlassian.jira.plugin.system.customfieldtypes:multiselect',

CUSTOMFIELDSEARCHERKEY='com.atlassian.jira.plugin.system.customfieldtypes:multiselectsearcher'

WHERE ID=10570

is that you tried select also in place of multiselect?

UPDATE customfield SET CUSTOMFIELDTYPEKEY = 'com.atlassian.jira.plugin.system.customfieldtypes:select',

The above comment is appearing with improper readability.so I again posted

Pierre Cattin

Ok I got it, it's because I didn't commit after the database update

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

custom-field

jira