Changing an existing Custom Field (List) to Cascading list

[Chacha20]

Current setup: A custom field setup as Select List (multiple choices)

Proposed setup: Ideally change the field to a Select List (cascading) and then be able to add child options based on the value selected in the parent field.

Is this possible? Thank you

[Chacha20]

Edit: Removing post as not answer!

[Sreenivasaraju P]

Hi @Chacha20 ,

As per my knowledge, out of the box you can't modify the custom field type in the cloud version. On cloud version, you don't have database also.  

Suggestion is already raised with Atlassian @

https://jira.atlassian.com/browse/JRACLOUD-68930 

[Chacha20]

Thank you for your prompt reply. 

What would be the simplest way of moving data across between the old field and new field in this instance?

[Matt Parks]

@Chacha20 Do you have Scriptrunner? If so, you could write a script that would copy the values from the multi-select list to the first option in the cascading select list.

[Chacha20]

Thanks @Matt Parks but do not have it or able to get it 

---

Any other option here to copy values between the custom fields?

[Matt Parks]

You could do the following:

1. Create a new query and have the multi-select field along with the issue key in the list of fields. Export that to a csv.

2. Import the csv, but map the column with the data from the multi-select field into the new cascading select field. If you also map the issue key, it will update the new field.

A few caveats:

1. I would assume that the options between the multi-select and the first value in the cascading select are the same in your configuration

2. I'm assuming that just selecting one column for the cascading select in your import will automatically update the field appropriately, but I've never tried it.

3.  Because of the first two caveats, I'd recommend doing this in a test environment first.

[Matt Parks]

Unfortunately, you can't just change the type of a custom field once it's been created.

I thought that, if you had Scriptrunner, you could use the built-in script to copy values from a multi-select to a cascading select (after creating a new field), but it appears that it isn't supported between those field types.