Table 1511 Notification Entry

Base Application, System.Environment.Configuration

src/Layers/W1/BaseApp/System/Notifications/NotificationEntry.Table.al162 lines, Copyright (c) Microsoft Corporation. MIT

namespace System.Environment.Configuration;using System.Automation;using System.Reflection;using System.Security.AccessControl;using System.Security.User;table 1511 "Notification Entry"{    Caption = 'Notification Entry';    ReplicateData = false;    DataClassification = CustomerContent;    fields    {        field(1; ID; Integer)        {            AutoIncrement = true;            Caption = 'ID';        }        field(3; Type; Enum "Notification Entry Type")        {            Caption = 'Type';        }        field(4; "Recipient User ID"; Code[50])        {            Caption = 'Recipient User ID';            DataClassification = EndUserIdentifiableInformation;            TableRelation = "User Setup"."User ID";            ValidateTableRelation = false;        }        field(5; "Triggered By Record"; RecordID)        {            Caption = 'Triggered By Record';            DataClassification = CustomerContent;        }        field(6; "Link Target Page"; Integer)        {            Caption = 'Link Target Page';            TableRelation = "Page Metadata".ID;        }        field(7; "Custom Link"; Text[250])        {            Caption = 'Custom Link';            ExtendedDatatype = URL;        }        field(8; "Error Message"; Text[2048])        {            Caption = 'Error Message';            Editable = false;        }        field(9; "Created Date-Time"; DateTime)        {            Caption = 'Created Date-Time';            Editable = false;        }        field(10; "Created By"; Code[50])        {            Caption = 'Created By';            DataClassification = EndUserIdentifiableInformation;            Editable = false;            TableRelation = User."User Name";        }        field(18; "Sender User ID"; Code[50])        {            Caption = 'Sender User ID';            DataClassification = EndUserIdentifiableInformation;            TableRelation = "User Setup"."User ID";        }    }    keys    {        key(Key1; ID)        {            Clustered = true;        }        key(Key2; "Created Date-Time")        {        }        key(Key3; "Triggered By Record", Type)        {        }    }    fieldgroups    {    }    trigger OnInsert()    begin        "Created Date-Time" := RoundDateTime(CurrentDateTime, 60000);        "Created By" := UserId;    end;    var        DataTypeManagement: Codeunit "Data Type Management";        NotificationTelemetryCategoryTxt: Label 'Notifications', Locked = true;        NoRecipientTelemetryTxt: Label 'Recipient is not set, cannot create notification', Locked = true;        NoUserSetupTelemetryTxt: Label 'No User Setup, cannot create notification', Locked = true;        NoValidRecordTelemetryTxt: Label 'Not a valid record, cannot create notification', Locked = true;    procedure CreateNotificationEntry(NewType: Enum "Notification Entry Type"; RecipientUserID: Code[50]; NewRecord: Variant; NewLinkTargetPage: Integer; NewCustomLink: Text[250]; NewSenderUserID: Code[50])    var        NotificationSchedule: Record "Notification Schedule";        UserSetup: Record "User Setup";        NewRecRef: RecordRef;        TelemetryDimensions: Dictionary of [Text, Text];    begin        TelemetryDimensions := GetTelemetryDimensions(NewType);        if RecipientUserID = '' then begin            Session.LogMessage('0000F6C', NoRecipientTelemetryTxt, Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, TelemetryDimensions);            exit;        end;        if not UserSetup.Get(RecipientUserID) then begin            Session.LogMessage('0000F6D', NoUserSetupTelemetryTxt, Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, TelemetryDimensions);            exit;        end;        if not DataTypeManagement.GetRecordRef(NewRecord, NewRecRef) then begin            Session.LogMessage('0000F6E', NoValidRecordTelemetryTxt, Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, TelemetryDimensions);            exit;        end;        if InsertRec(NewType, RecipientUserID, NewRecRef.RecordId, NewLinkTargetPage, NewCustomLink, NewSenderUserID) then            NotificationSchedule.ScheduleNotification(Rec);    end;    procedure InsertRec(NewType: Enum "Notification Entry Type"; NewUserID: Code[50]; NewRecordID: RecordID; NewLinkTargetPage: Integer; NewCustomLink: Text[250]; NewSenderUserID: Code[50]): Boolean;    begin        if not DoesTableMatchType(NewType, NewRecordID.TableNo) then            exit(false);        Clear(Rec);        Type := NewType;        "Recipient User ID" := NewUserID;        "Triggered By Record" := NewRecordID;        "Link Target Page" := NewLinkTargetPage;        "Custom Link" := NewCustomLink;        "Sender User ID" := NewSenderUserID;        exit(Insert(true));    end;    local procedure DoesTableMatchType(NewType: Enum "Notification Entry Type"; TableNo: Integer): Boolean;    begin        case NewType of            "Notification Entry Type"::Approval:                exit(TableNo = Database::"Approval Entry");            "Notification Entry Type"::Overdue:                exit(TableNo = Database::"Overdue Approval Entry");        end;        exit(true);    end;    internal procedure GetTelemetryDimensions(NotificationEntryType: Enum "Notification Entry Type") Dimensions: Dictionary of [Text, Text]    begin        Dimensions.Add('Category', NotificationTelemetryCategoryTxt);        Dimensions.Add('NotificationEntryType', Format(NotificationEntryType.AsInteger()));    end;}