Table 1573 Workflow Approvers Buffer

Base Application, System.Automation

src/Layers/W1/BaseApp/System/Workflow/WorkflowApproversBuffer.Table.al190 lines, Copyright (c) Microsoft Corporation. MIT

// ------------------------------------------------------------------------------------------------// Copyright (c) Microsoft Corporation. All rights reserved.// Licensed under the MIT License. See License.txt in the project root for license information.// ------------------------------------------------------------------------------------------------namespace System.Automation;using Microsoft.Purchases.Document;using Microsoft.Sales.Document;using System.Security.AccessControl;table 1573 "Workflow Approvers Buffer"{    Caption = 'Workflow Approvers Buffer';    DataClassification = CustomerContent;    TableType = Temporary;    InherentEntitlements = RIMDX;    InherentPermissions = RIMDX;    fields    {        field(1; WorkflowCode; Code[20])        {            Caption = 'Workflow Code';            AllowInCustomizations = AsReadOnly;        }        field(2; WorkflowStepId; Integer)        {            Caption = 'Workflow Step Id';            AllowInCustomizations = AsReadOnly;        }        field(3; WorkflowType; Enum "Approval Workflow Type")        {            Caption = 'Workflow Type';            AllowInCustomizations = AsReadOnly;        }        field(4; ArgumentId; Guid)        {            Caption = 'Argument Id';            AllowInCustomizations = AsReadOnly;        }        field(5; UserName; Code[50])        {            Caption = 'User Name';            AllowInCustomizations = AsReadOnly;        }        field(6; Sequence; Integer)        {            Caption = 'Sequence';            AllowInCustomizations = AsReadOnly;        }        field(7; ApproverType; enum "Workflow Approver Type")        {            Caption = 'Approver Type';            AllowInCustomizations = AsReadOnly;        }        field(8; ApproverLimitType; enum "Workflow Approver Limit Type")        {            Caption = 'Approver Limit Type';            AllowInCustomizations = AsReadOnly;        }        field(9; WorkflowDescription; Text[100])        {            Caption = 'Workflow Description';            AllowInCustomizations = AsReadOnly;        }        field(10; Category; Code[20])        {            Caption = 'Category';            AllowInCustomizations = AsReadOnly;        }        field(11; Enabled; Boolean)        {            Caption = 'Enabled';            AllowInCustomizations = AsReadOnly;        }        field(12; UserGroupCode; Code[20])        {            Caption = 'User Group Code';            AllowInCustomizations = AsReadOnly;        }        field(13; UserGroupDescription; Text[100])        {            Caption = 'User Group Description';            CalcFormula = lookup("Workflow User Group".Description where(Code = field(UserGroupCode)));            FieldClass = FlowField;        }        field(14; UserId; Guid)        {            Caption = 'User Id';        }        field(15; UserFullName; Text[100])        {            Caption = 'User Full Name';            CalcFormula = lookup(User."Full Name" where("User Security ID" = field(UserId)));            FieldClass = FlowField;        }    }    keys    {        key(Key1; WorkflowCode, WorkflowStepId, ArgumentId, UserName, Sequence)        {            Clustered = true;        }    }    procedure FillBuffer()    var        Workflow: Record Workflow;        WorkflowStepArgument: Record "Workflow Step Argument";        WorkflowStep: Record "Workflow Step";        WorkflowUserGroupMember: Record "Workflow User Group Member";    begin        WorkflowStepArgument.SetRange(Type, WorkflowStepArgument.Type::Response);        WorkflowStepArgument.SetRange("Response Option Group", 'GROUP 5');        if WorkflowStepArgument.FindSet() then            repeat                WorkflowStep.SetLoadFields(ID, "Workflow Code");                WorkflowStep.SetRange(Argument, WorkflowStepArgument.ID);                if WorkflowStep.FindFirst() then                    if Workflow.Get(WorkflowStep."Workflow Code") and (not Workflow.Template) then begin                        Rec.Init();                        Rec.WorkflowCode := Workflow.Code;                        Rec.WorkflowDescription := Workflow.Description;                        Rec.WorkflowStepId := WorkflowStep.ID;                        Rec.ArgumentId := WorkflowStepArgument.ID;                        Rec.ApproverType := WorkflowStepArgument."Approver Type";                        Rec.ApproverLimitType := WorkflowStepArgument."Approver Limit Type";                        Rec.Category := Workflow.Category;                        Rec.Enabled := Workflow.Enabled;                        Rec.WorkflowType := GetWorkflowType(Workflow.Code);                        if WorkflowStepArgument."Approver Type" = WorkflowStepArgument."Approver Type"::"Workflow User Group" then begin                            WorkflowUserGroupMember.SetRange("Workflow User Group Code", WorkflowStepArgument."Workflow User Group Code");                            if WorkflowUserGroupMember.FindSet() then                                repeat                                    Rec.UserName := WorkflowUserGroupMember."User Name";                                    Rec.Sequence := WorkflowUserGroupMember."Sequence No.";                                    Rec.UserGroupCode := WorkflowUserGroupMember."Workflow User Group Code";                                    Rec.UserId := GetUserId(Rec.UserName);                                    Rec.Insert();                                until WorkflowUserGroupMember.Next() = 0;                        end else begin                            if WorkflowStepArgument."Approver Limit Type" = WorkflowStepArgument."Approver Limit Type"::"Specific Approver" then begin                                Rec.UserName := WorkflowStepArgument."Approver User ID";                                Rec.UserId := GetUserId(Rec.UserName);                            end;                            Rec.Insert();                        end;                        Clear(Rec);                    end;            until WorkflowStepArgument.Next() = 0;    end;    local procedure GetWorkflowType(Code: Code[20]): Enum "Approval Workflow Type"    var        WorkflowStep: Record "Workflow Step";        WorkflowEvent: Record "Workflow Event";    begin        WorkflowStep.SetLoadFields("Function Name");        WorkflowStep.SetRange("Workflow Code", Code);        WorkflowStep.SetRange("Entry Point", true);        if WorkflowStep.FindFirst() then begin            WorkflowEvent.SetLoadFields("Table ID");            if WorkflowEvent.Get(WorkflowStep."Function Name") then                case WorkflowEvent."Table ID" of                    Database::"Sales Header":                        exit(WorkflowType::Sales);                    Database::"Purchase Header":                        exit(WorkflowType::Purchase);                    else                        exit(WorkflowType::Request);                end;        end    end;    local procedure GetUserId(ApproverUserName: Code[50]): Guid    var        User: Record User;    begin        User.SetLoadFields("User Security ID");        User.SetRange("User Name", ApproverUserName);        if User.FindFirst() then            exit(User."User Security ID");    end;}