/// <summary> /// The <c>ReleaseUpdateDB63_WHSMinorUpdateVKRetail</c> class contains upgrade scripts for the WHS area data /// </summary> class ReleaseUpdateDB63_WHSMinorUpdateVKRetail extends ReleaseUpdateDB { #define.version(sysReleasedVersion::v63) #define.className(ReleaseUpdateDB63_WHSMinorUpdateVKRetail) } public void initPostSyncUpdateJobs() { #initSyncJobsPrefix } /// <summary> /// Gets the module name of an upgrade class. /// </summary> /// <returns> /// The module name. /// </returns> /// <remarks> /// This method must be implemented by sub classes.The module name is displayed on the cockpit form for /// every script. /// </remarks> public ReleaseUpdateModule moduleName() { return classId2Name(classIdGet(this)); } /// <summary> /// Updates WHSRFMenuItemTable with new WHSWorkActivity base enum values /// </summary> [ UpgradeScriptDescriptionAttribute('Updates VK Retail base enums values'), UpgradeScriptConfigKeyAttribute(configurationKeyStr(WHSAndTMS)), UpgradeScriptStageAttribute(ReleaseUpdateScriptStage::PostSyncUpdate), UpgradeScriptTypeAttribute(ReleaseUpdateScriptType::StandardScript), // Tables which data is updated // str _tableName, boolean _create, boolean _read, boolean _update, boolean _delete, boolean _exclude = false UpgradeScriptTableAttribute(tableStr(WHSRFMenuItemTable), false, true, true, false), UpgradeScriptTableAttribute(tableStr(RetailChannelProfile), false, true, true, false), UpgradeScriptTableAttribute(tableStr(WHSWorkUserSession), false, true, true, false) ] public void updateEnumValues() { RetailChannelProfile retailChannelProfile; WHSRFMenuItemTable wHSRFMenuItemTable; WHSWorkUserSession wHSWorkUserSession; ttsBegin; // data update goes here update_recordSet retailChannelProfile setting ChannelProfileType = RetailChannelProfileType::VKCallCenter where RetailChannelProfile.ChannelProfileType == 7; ttsCommit; }Additional method to existing class:
/// <summary> /// Updates WHSRFMenuItemTable with new WHSWorkActivity base enum values /// </summary> [ UpgradeScriptDescriptionAttribute('Updates VK Retail base enums values'), UpgradeScriptConfigKeyAttribute(configurationKeyStr(WHSAndTMS)), UpgradeScriptStageAttribute(ReleaseUpdateScriptStage::PostSync), UpgradeScriptTypeAttribute(ReleaseUpdateScriptType::StandardScript), // Tables which data is updated // str _tableName, boolean _create, boolean _read, boolean _update, boolean _delete, boolean _exclude = false UpgradeScriptTableAttribute(tableStr(WHSRFMenuItemTable), false, true, true, false), UpgradeScriptTableAttribute(tableStr(RetailChannelProfile), false, true, true, false), UpgradeScriptTableAttribute(tableStr(WHSWorkUserSession), false, true, true, false) ] public void updateVKWHSWorkEnum() { ClassName className = classStr(ReleaseUpdateDB63_WHSMinorUpdateVKRetail); MethodName methodName = methodStr(ReleaseUpdateDB63_WHSMinorUpdateVKRetail, updateEnumValues); ReleaseUpdateDB::MarkAMinorVersionScriptAsFinished(className, methodName); }Data upgrade script should appear in:
DaxOnline.org is free platform that allows you to quickly store and reuse snippets, notes, articles related to Dynamics AX.
Authors are allowed to set their own AdSense units.
Join us.