Codeunit 1531 Workflow Change Rec Mgt.

Base Application, System.Automation

src/Layers/W1/BaseApp/System/Workflow/WorkflowChangeRecMgt.Codeunit.al160 lines, Copyright (c) Microsoft Corporation. MIT

namespace System.Automation;codeunit 1531 "Workflow Change Rec Mgt."{    Permissions = TableData "Workflow - Record Change" = rimd;    trigger OnRun()    begin    end;    var        ValueMismatchMsg: Label 'The current value of the field is different from the value before the change.';        NoRecordChangesFoundMsg: Label 'No record changes exist to apply the saved values to using the current options.';    procedure RevertValueForField(var Variant: Variant; xVariant: Variant; WorkflowStepInstance: Record "Workflow Step Instance")    var        WorkflowStepArgument: Record "Workflow Step Argument";        WorkflowRecordChange: Record "Workflow - Record Change";        RecRef: RecordRef;        OldValue: Text;        NewValue: Text;    begin        RecRef.GetTable(Variant);        WorkflowStepArgument.Get(WorkflowStepInstance.Argument);        OldValue := GetValueFromField(xVariant, WorkflowStepArgument."Field No.");        NewValue := GetValueFromField(Variant, WorkflowStepArgument."Field No.");        if OldValue = NewValue then            exit;        CreateChangeRecord(RecRef, OldValue, NewValue, WorkflowStepArgument."Field No.", WorkflowStepInstance, WorkflowRecordChange);        SetValueForField(RecRef, WorkflowStepArgument."Field No.", OldValue);        RecRef.Modify(true);        RecRef.SetTable(Variant);    end;    procedure ApplyNewValues(Variant: Variant; WorkflowStepInstance: Record "Workflow Step Instance")    var        ApprovalEntry: Record "Approval Entry";        WorkflowRecordChange: Record "Workflow - Record Change";        WorkflowStepArgument: Record "Workflow Step Argument";        RecRef: RecordRef;    begin        RecRef.GetTable(Variant);        case RecRef.Number of            DATABASE::"Approval Entry":                begin                    ApprovalEntry.Get(RecRef.RecordId);                    WorkflowRecordChange.SetRange("Workflow Step Instance ID", WorkflowStepInstance.ID);                    WorkflowRecordChange.SetRange("Record ID", ApprovalEntry."Record ID to Approve");                    WorkflowRecordChange.SetRange(Inactive, false);                end;            DATABASE::"Workflow - Record Change":                begin                    WorkflowRecordChange.Get(RecRef.RecordId);                    WorkflowRecordChange.SetRange("Workflow Step Instance ID", WorkflowStepInstance.ID);                    WorkflowRecordChange.SetRange("Record ID", WorkflowRecordChange."Record ID");                    WorkflowRecordChange.SetRange(Inactive, false);                end;            else begin                    WorkflowRecordChange.SetRange("Workflow Step Instance ID", WorkflowStepInstance.ID);                    WorkflowRecordChange.SetRange("Record ID", RecRef.RecordId);                    WorkflowRecordChange.SetRange(Inactive, false);                end        end;        if WorkflowStepArgument.Get(WorkflowStepInstance.Argument) then            if WorkflowStepArgument."Field No." <> 0 then begin                WorkflowRecordChange.SetRange("Table No.", WorkflowStepArgument."Table No.");                WorkflowRecordChange.SetRange("Field No.", WorkflowStepArgument."Field No.");            end;        if WorkflowRecordChange.FindSet() then            repeat                ApplyNewValueFromChangeRecord(WorkflowRecordChange);            until WorkflowRecordChange.Next() = 0        else            Message(NoRecordChangesFoundMsg);    end;    procedure DiscardNewValues(Variant: Variant; WorkflowStepInstance: Record "Workflow Step Instance")    var        ApprovalEntry: Record "Approval Entry";        WorkflowRecordChange: Record "Workflow - Record Change";        RecRef: RecordRef;    begin        RecRef.GetTable(Variant);        case RecRef.Number of            DATABASE::"Approval Entry":                begin                    ApprovalEntry.Get(RecRef.RecordId);                    RecRef.Get(ApprovalEntry."Record ID to Approve");                end;            DATABASE::"Workflow - Record Change":                begin                    WorkflowRecordChange.Get(RecRef.RecordId);                    RecRef.Get(WorkflowRecordChange."Record ID");                end;        end;        WorkflowRecordChange.SetRange("Table No.", RecRef.Number);        WorkflowRecordChange.SetRange("Record ID", RecRef.RecordId);        WorkflowRecordChange.SetRange("Workflow Step Instance ID", WorkflowStepInstance.ID);        WorkflowRecordChange.ModifyAll(Inactive, true, true);    end;    local procedure CreateChangeRecord(RecRef: RecordRef; OldValue: Text; NewValue: Text; FieldNo: Integer; WorkflowStepInstance: Record "Workflow Step Instance"; var WorkflowRecordChange: Record "Workflow - Record Change")    begin        Clear(WorkflowRecordChange);        WorkflowRecordChange."Table No." := RecRef.Number;        WorkflowRecordChange."Field No." := FieldNo;        WorkflowRecordChange."Old Value" := CopyStr(OldValue, 1, 250);        WorkflowRecordChange."New Value" := CopyStr(NewValue, 1, 250);        WorkflowRecordChange."Record ID" := RecRef.RecordId;        WorkflowRecordChange."Workflow Step Instance ID" := WorkflowStepInstance.ID;        WorkflowRecordChange.Insert(true);    end;    local procedure ApplyNewValueFromChangeRecord(WorkflowRecordChange: Record "Workflow - Record Change")    var        RecRef: RecordRef;    begin        RecRef.Get(WorkflowRecordChange."Record ID");        if WorkflowRecordChange."Old Value" = GetValueFromField(RecRef, WorkflowRecordChange."Field No.") then begin            SetValueForField(RecRef, WorkflowRecordChange."Field No.", WorkflowRecordChange."New Value");            RecRef.Modify(true);            WorkflowRecordChange.Inactive := true;            WorkflowRecordChange.Modify(true);        end else            Message(ValueMismatchMsg);    end;    local procedure GetValueFromField(Variant: Variant; FieldId: Integer): Text    var        RecRef: RecordRef;        FieldRef: FieldRef;    begin        RecRef.GetTable(Variant);        FieldRef := RecRef.Field(FieldId);        exit(Format(FieldRef.Value, 0, 9));    end;    local procedure SetValueForField(var RecRef: RecordRef; FieldId: Integer; NewValue: Text)    var        FieldRef: FieldRef;    begin        FieldRef := RecRef.Field(FieldId);        Evaluate(FieldRef, NewValue, 9);    end;}