Share via


ReleaseUpdateDB60_Basic.updateWorkflowFieldNameMapping Upgrade Script

Applies To: Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2, Microsoft Dynamics AX 2012 Feature Pack, Microsoft Dynamics AX 2012

Class

ReleaseUpdateDB60_Basic

Method

updateWorkflowFieldNameMapping

Description

Creates a mapping from the dataAreaID field to the DataArea field in the WorkflowConfigurationTable table. Creates a mapping from the dataAreaID field to the del_DataAreaID field for rest of the affected tables.

Affected Modules and Tables

Affected Modules

Basic

Affected Tables

WorkflowConfigurationTable

WorkflowElementTable

WorkflowStepTable

WorkflowSubWorkflowTable

WorkflowMessageText

WorkflowVersionTableNotes

ExpressionTable

Remarks

We cannot use the dataareaId field because this is the intrinsic kernel field to use to store the data area for company bound tables, such as the SaveDataPerCompany field equal to the Yes value. We cannot use this field because our tables now have the SaveDataPerCompany field equal to the No value, which means that the dataareaId field does not exist in our tables, and we cannot add it. Therefore, this is a mapping of the old dataareaId field to a new DataArea field for the WorkflowConfigurationTable table and to the del_DataAreaID field for the rest of the tables that are mentioned in the list above.

Data Migration Section

From Table: WokflowConfigurationTable

To Table: WorkflowConfigurationTable

DataAreaID

DataArea

From Table: WorkflowElementTable

To Table: WorkflowElementTable

dataAreaID

del_dataAreaID

From Table: WorkflowStepTable

To Table: WorkflowStepTable

dataAreaID

del_dataAreaID

From Table: WorkflowSubWorkflowTable

To Table: WorkflowSubWorkflowTable

dataAreaID

del_dataAreaID

From Table: WorkflowMessageText

To Table: WorkflowMessageText

dataAreaID

del_dataAreaID

From Table: WorkflowVersionTableNotes

To Table: WorkflowVersionTableNotes

dataAreaID

del_dataAreaID

From Table: ExpressionTable

To Table: ExpressionTable

dataAreaID

del_dataAreaID