-
Type:
Suggestion
-
Resolution: Unresolved
-
Component/s: Jira - Migration Assistant - Export
-
None
-
24
As a customer, I would like to be able to include configured workflow properties in the workflow migration with JCMA.
Workaround
Add the workflow properties manually after migration.
For Postgres, you can use this query to identify the properties:
select j.id as workflowid , j.workflowname, workflow_properties.id, workflow_properties.name, workflow_properties.type, workflow_properties.property , workflow_properties.value from jiraworkflows j, XMLTABLE('//workflow/*/*/meta' passing xmlparse(document descriptor) columns id int path '../@id', name text path '../@name', type text path 'name(../../*)', property text path '@name', value text path 'text()' ) as workflow_properties ORDER BY workflowid, type, id;