Table 467 Workflow Webhook Entry
src/Layers/W1/BaseApp/System/Workflow/WorkflowWebhookEntry.Table.al160 lines, Copyright (c) Microsoft Corporation. MIT
namespace System.Automation;using Microsoft.Utilities;using System.Security.User;table 467 "Workflow Webhook Entry"{ Caption = 'Workflow Webhook Entry'; DataClassification = CustomerContent; fields { field(1; "Entry No."; Integer) { AutoIncrement = true; Caption = 'Entry No.'; } field(3; "Workflow Step Instance ID"; Guid) { Caption = 'Workflow Step Instance ID'; } field(5; "Initiated By User ID"; Code[50]) { Caption = 'Initiated By User ID'; DataClassification = EndUserIdentifiableInformation; } field(7; Response; Option) { Caption = 'Response'; OptionCaption = 'NotExpected,Pending,Cancel,Continue,Reject'; OptionMembers = NotExpected,Pending,Cancel,Continue,Reject; } field(8; "Response Argument"; Guid) { Caption = 'Response Argument'; } field(9; "Date-Time Initiated"; DateTime) { Caption = 'Date-Time Initiated'; } field(11; "Last Date-Time Modified"; DateTime) { Caption = 'Last Date-Time Modified'; } field(13; "Last Modified By User ID"; Code[50]) { Caption = 'Last Modified By User ID'; DataClassification = EndUserIdentifiableInformation; } field(15; "Data ID"; Guid) { Caption = 'Data ID'; } field(17; "Record ID"; RecordID) { Caption = 'Record ID'; DataClassification = CustomerContent; } } keys { key(Key1; "Entry No.") { Clustered = true; } key(Key2; "Workflow Step Instance ID") { } key(Key3; "Data ID") { } key(Key4; Response, "Record ID") { } key(Key5; "Record ID") { } } fieldgroups { } trigger OnModify() begin "Last Date-Time Modified" := CreateDateTime(Today, Time); "Last Modified By User ID" := UserId; end; var PageManagement: Codeunit "Page Management"; procedure SetDefaultFilter(var WorkflowWebhookEntry: Record "Workflow Webhook Entry") var UserSetup: Record "User Setup"; IsApprovalAdmin: Boolean; ResponseUserID: Code[50]; begin IsApprovalAdmin := false; if UserSetup.Get(UserId) then if UserSetup."Approval Administrator" then IsApprovalAdmin := true; Clear(WorkflowWebhookEntry); WorkflowWebhookEntry.Init(); WorkflowWebhookEntry.SetRange(Response, WorkflowWebhookEntry.Response::Pending); if not IsApprovalAdmin then begin if WorkflowWebhookEntry.FindSet() then repeat if WorkflowWebhookEntry."Initiated By User ID" = UserId then WorkflowWebhookEntry.Mark(true) else // Look to see if the entry is awaiting a response from the active user if GetResponseUserIdFromArgument(WorkflowWebhookEntry."Response Argument", ResponseUserID) then if ResponseUserID = UserId then WorkflowWebhookEntry.Mark(true); until WorkflowWebhookEntry.Next() = 0; WorkflowWebhookEntry.MarkedOnly(true); end; end; local procedure GetResponseUserIdFromArgument(Argument: Guid; var ResponseUserID: Code[50]): Boolean var WorkflowStepArgument: Record "Workflow Step Argument"; begin Clear(ResponseUserID); if not IsNullGuid(Argument) then begin WorkflowStepArgument.Init(); if WorkflowStepArgument.Get(Argument) then case WorkflowStepArgument."Response Type" of WorkflowStepArgument."Response Type"::"User ID": begin ResponseUserID := WorkflowStepArgument."Response User ID"; exit(true); end; end; end; exit(false); end; procedure ShowRecord() var RecRef: RecordRef; begin // When called on a Workflow Webhook Entry row, finds the associated parent record and navigates to // the appropriate page to show that record. // Used by the Flow Entries page. Based on code from the Approval Entries page/Approval Entry table. if not RecRef.Get("Record ID") then exit; RecRef.SetRecFilter(); PageManagement.PageRun(RecRef); end;}