JCMA should include workflow properties in migration

XMLWordPrintable

    • 24

      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
            Votes:
            18 Vote for this issue
            Watchers:
            18 Start watching this issue

              Created:
              Updated: