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