How to convert an existing custom field type from select to Multi Select type?

srinivasp
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
October 29, 2013

Though the configuration is showing as Multi Select Type, it is still showing as Select type on the create issue page. Is there any work around to convert Select Custom Field to Multi Select Type?

2 answers

1 accepted

0 votes
Answer accepted
Nic Brough -Adaptavist-
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
October 29, 2013

It's not possible to do this conversion in the UI, so you must have been hacking the database.

You need to explain what you're done to do this conversion.

0 votes
Jobin Kuruvilla [Adaptavist]
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
October 29, 2013

Though the configuration is showing as Multi Select Type, it is still showing as Select type on the create issue page

Not sure how that is possible! Are there different custom fields with the same name by any chance?

Can you also check the type in the database to be sure?

srinivasp
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
October 29, 2013

The actual Custom Field is showing as "Select List" but when I edit, the search template is showing as Multi Select Searcher.

I checked the database but I found only one custom field with name 'Browser'.

10053, com.atlassian.jira.plugin.system.customfieldtypes:select, com.atlassian.jira.plugin.system.customfieldtypes:multiselectsearcher, Browser

Jobin Kuruvilla [Adaptavist]
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
October 29, 2013

Boh select list and multi select fields use the same searcher. That doesn't mean the field is multi select. The workaround is to modify the type from com.atlassian.jira.plugin.system.customfieldtypes:select to com.atlassian.jira.plugin.system.customfieldtypes:multiselect.

Make sure JIRA is down when you do this and then re-index after it is back up.

Nic Brough -Adaptavist-
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
October 29, 2013

And don't forget to take a full backup BEFORE running any SQL.

This isn't so much of a workaround as a bit of an unusual hack. It does work though, just bear in mind you can't go back when you've done it.

Jobin Kuruvilla [Adaptavist]
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
October 29, 2013

Agree with Nic. It is a hack. And you won't be able to do the same with other conversions like from text field to number field.

srinivasp
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
October 29, 2013

Hi Jobin/Nic, Thanks for the pointers.

Suggest an answer

Log in or Sign up to answer