ReleaseUpdateDB60_Basic.updateExpression Upgrade Script [AX 2012]
Updated: March 24, 2011
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. |
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.
|
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 |
Announcements: To see known issues and recent fixes, use Issue search in Microsoft Dynamics Lifecycle Services (LCS).