JCMA should include workflow properties in migration

XMLWordPrintable

    • 27

      As a customer, I would like to be able to include configured workflow properties in the workflow migration with JCMA.

      Workaround

      https://confluence.atlassian.com/jirakb/how-to-get-a-list-of-the-workflow-triggers-and-properties-in-jira-to-migrate-to-cloud-jcma-1141486611.html 

      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;  

       

       

              Assignee:
              Unassigned
              Reporter:
              Carl Adolfson (Inactive)
              Votes:
              19 Vote for this issue
              Watchers:
              20 Start watching this issue

                Created:
                Updated: