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