ReleaseUpdateDB60_Basic.updateExpression 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	updateExpression
Description	Moves metadata and data stored in the ExpressionDefinition and Projection fields into new tables. Validates each condition and then copies all invalid conditions into the ExpressionStaging table.

Affected Modules and Tables

Affected Modules
Basic

Affected Tables
ExpressionTable

Remarks

Expressions in Microsoft Dynamics AX 2012 have undergone data model changes in which the actual expression represented as XML strings in the ExpressionDefinition and Projection fields has been normalized into various tables. Information that was represented in the Projection column is now in the ExpressionProjectionDatasource and ExpressionProjectionField tables. Information represented in the ExpressionDefinition column is now in the ExpressionElement and ExpressionPredicate tables. The Projection and ExpressionDefinition columns have been deleted from the ExpressionTable table. A new table named the ExpressionStagingTable table has been introduced that will hold all invalid expressions after the upgrade is complete. Expressions that were created in Microsoft Dynamics AX 2009 may be invalid because metadata that was represented in the expressions may have changed. That is, fields have been renamed or moved, extended data types have changed, and so on.

Data Migration Section

From Table: ExpressionTable	To Table: ExpressionProjectionDatasource
Projection	ParentDatasource
Projection	Name
Projection	Type
Projection	DisplayName
Projection	TableName

From Table: ExpressionTable	To Table: ExpressionProjectionField
Projection	Name
Projection	Category
Projection	Type
Projection	ExtendedDataType
Projection	DisplayName

From Table: ExpressionTable	To Table: ExpressonElement
ExpressionDefinition	ParentElement
ExpressionDefinition	Type

From Table: ExpressionTable	To Table: ExpressionPredicate
ExpressionDefinition	ExpressionFieldLHS
ExpressionDefinition	ExpressionFieldRHS
ExpressionDefinition	RefRecIDValue
ExpressionDefinition	RefTableIDValue
ExpressionDefinition	StringValue
ExpressionDefinition	RealValue
ExpressionDefinition	LongValue
ExpressionDefinition	EnumValue
ExpressionDefinition	AbsoluteDateValue
ExpressionDefinition	StartDayType
ExpressionDefinition	OffsetDays
ExpressionDefinition	DateOperatorType
ExpressionDefinition	ComparisonType
ExpressionDefinition	DateType
ExpressionDefinition	Sequence

New Tables or Fields

Table	Field	Extended Data Type -or- Base Enum
ExpressionProjectionDatasource
ExpressionProjectionField
ExpressionElement
ExpressionPredicate
ExpressionStagingTable

Deleted Tables or Fields

Table	Field
ExpressionTable	Projection
ExpressionTable	ExpressionDefinition