Table 1541 Workflow User Group Member, source in 29
Source29
src/Layers/W1/BaseApp/System/Workflow/WorkflowUserGroupMember.Table.al65 lines, Copyright (c) Microsoft Corporation. MIT
namespace System.Automation;
using System.Security.User;
table 1541 "Workflow User Group Member"
{
Caption = 'Workflow User Group Member';
ReplicateData = true;
DataClassification = CustomerContent;
fields
{
field(1; "Workflow User Group Code"; Code[20])
{
Caption = 'Workflow User Group Code';
TableRelation = "Workflow User Group".Code;
}
field(2; "User Name"; Code[50])
{
Caption = 'User Name';
DataClassification = EndUserIdentifiableInformation;
TableRelation = "User Setup"."User ID";
trigger OnValidate()
var
UserSetup: Record "User Setup";
WorkflowUserGroupMember: Record "Workflow User Group Member";
SequenceNo: Integer;
begin
UserSetup.Get("User Name");
if "Sequence No." = 0 then begin
SequenceNo := 1;
WorkflowUserGroupMember.SetCurrentKey("Workflow User Group Code", "Sequence No.");
WorkflowUserGroupMember.SetRange("Workflow User Group Code", "Workflow User Group Code");
if WorkflowUserGroupMember.FindLast() then
SequenceNo := WorkflowUserGroupMember."Sequence No." + 1;
Validate("Sequence No.", SequenceNo);
end;
end;
}
field(3; "Sequence No."; Integer)
{
Caption = 'Sequence No.';
MinValue = 1;
}
}
keys
{
key(Key1; "Workflow User Group Code", "User Name")
{
Clustered = true;
}
key(Key2; "Workflow User Group Code", "Sequence No.", "User Name")
{
}
}
fieldgroups
{
}
}