How to merge values of 2 custom fields into 1 cascading custom field

[Sandra Meessen]

Hello, I have 2 custom fields (fieldA of type "select list (single choice)" and fieldB of type "text" (single line)". I want them in 1 cascading field. My thought is to define fieldC being the cascading field and then I want to merge values of fieldA and fieldB together into fieldC, being fieldA first part of the cascade and fieldB the second part.

How do I do this merge? Thanks.

[Mohamed Benziane]

Hello ,

May be with the sql you can merge data or use a csv file to populate the parent option of the cascading file but not the child https://confluence.atlassian.com/jirakb/how-to-bulk-import-custom-field-values-for-certain-types-of-custom-field-827123935.html.

It is possible to populate the cascading field whith scriptrunner.

here the code:

ParentA
    ChildA1
    ChildA2
ParentB
    ChildB1