Converting two Select List fields into one Cascading field

We originally set up two separate fields as Select Lists but the right way of setting up what was wanted was just one Cascading field. We could add the cascading field to the screen along with the original fields and manually migrate the values from the old fields to that new cascading field but there are 1500 issues now so that would be tedious at best. And seems like we could do the first half of the cascading field with the Bulk change feature but not sure how that would work for the second half of the cascading field. Do you having any suggests or pointers that could help out in this situation?

3 answers

Hello Gregory,

maybe the Function "Copy custom field values from one field to another" of the Script Runner-plugin may help you: https://marketplace.atlassian.com/plugins/com.onresolve.jira.groovy.groovyrunner

That sounds way easier! I'll have to take a look at this as well.

I'm currently rebuilding a lot of projects with new standards that require changing a lot of field types. To handle this we are importing the issues to the new projects with the new field configurations. We are just mapping out the value ids of the old fields to the correct value ids of the new fields. Could you do something similiar by just exporting the 1500 tickets then reimporting them? If you have linked tickets this will be more difficult since ticket numbers will change. You also have to go back and delete the original 1500 tickets or you would have duplicates.

I can think a few manual ways to do this as well. The best would be finding out what all the possible combinations are for the two field values, finding which tickets have which combiniations and then mass edit each combination from a filtered result. Very manual, but will save you time over a ticket by ticket if you don't have many values in each field.

Thanks Lathrop and Sebastian! I'll check with my customer and see if they want to try one of these options.

Suggest an answer

Log in or Sign up to answer
How to earn badges on the Atlassian Community

How to earn badges on the Atlassian Community

Badges are a great way to show off community activity, whether you’re a newbie or a Champion.

Learn more
Community showcase
Published Monday in Jira Software

How large do you think Jira Software can grow?

Hi Atlassian Community! My name is Shana, and I’m on the Jira Software team. One of the many reasons this Community exists is to connect you to others on similar product journeys or with comparabl...

620 views 6 12
Read article

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you