Table 3901 Retention Policy Setup, source in 24

// ------------------------------------------------------------------------------------------------
// Copyright (c) Microsoft Corporation. All rights reserved.
// Licensed under the MIT License. See License.txt in the project root for license information.
// ------------------------------------------------------------------------------------------------

namespace System.DataAdministration;

using System;
using System.Reflection;

/// <summary>
/// This table stores the retention policy setup records.
/// </summary>
table 3901 "Retention Policy Setup"
{
    DataCaptionFields = "Table Name", "Retention Period";

    fields
    {
        field(1; "Table Id"; Integer)
        {
            DataClassification = SystemMetadata;
            TableRelation = AllObjWithCaption."Object ID" where("Object Type" = const(Table));
            BlankZero = true;
            NotBlank = true;
            MinValue = 0;
            MaxValue = 1999999999;

            trigger OnValidate()
            var
                RetenPolAllowedTables: Codeunit "Reten. Pol. Allowed Tables";
            begin
                RetenPolAllowedTables.IsAllowedTable(Rec."Table Id");
                Rec.Validate("Date Field No.", RetenPolAllowedTables.GetDefaultDateFieldNo(Rec."Table Id"));
            end;

            trigger OnLookup()
            var
                RetentionPolicy: Codeunit "Retention Policy Setup";
            begin
                Rec.Validate("Table Id", RetentionPolicy.TableIdLookup(Rec."Table Id"));
            end;
        }
        field(2; "Table Name"; Text[30])
        {
            FieldClass = FlowField;
            CalcFormula = lookup(AllObjWithCaption."Object Name" where("Object Type" = const(Table), "Object ID" = field("Table Id")));
            Editable = false;

            trigger OnLookup()
            var
                RetentionPolicy: Codeunit "Retention Policy Setup";
            begin
                Rec.Validate("Table Id", RetentionPolicy.TableIdLookup(Rec."Table Id"));
            end;

        }
        field(3; "Table Caption"; Text[249])
        {
            FieldClass = FlowField;
            CalcFormula = lookup(AllObjWithCaption."Object Caption" where("Object Type" = const(Table), "Object ID" = field("Table Id")));
            Editable = false;
        }
        field(4; "Retention Period"; Code[20])
        {
            DataClassification = CustomerContent;
            TableRelation = "Retention Period".Code;

            trigger OnValidate()
            var
                RetentionPolicySetupImpl: Codeunit "Retention Policy Setup Impl.";
            begin
                RetentionPolicySetupImpl.ValidateRetentionPeriod(Rec);
                if Rec."Retention Period" <> '' then
                    Rec.Validate(Enabled, true);
            end;
        }
        field(5; Enabled; Boolean)
        {
            DataClassification = SystemMetadata;

            trigger OnValidate()
            var
                RetentionPolicySetupLine: Record "Retention Policy Setup Line";
            begin
                if Rec.Enabled then
                    if Rec."Apply to all records" then
                        Rec.TestField("Retention Period")
                    else begin
                        RetentionPolicySetupLine.SetRange(Enabled, true);
                        if RetentionPolicySetupLine.IsEmpty() then
                            Error(NoLinesEnabledErr)
                    end;
            end;
        }
        field(6; "Apply to all records"; Boolean)
        {
            DataClassification = SystemMetadata;
            InitValue = true;

            trigger OnValidate()
            var
                RetentionPolicySetupLine: Record "Retention Policy Setup Line";
                RetentionPolicyLog: Codeunit "Retention Policy Log";
            begin
                if Rec."Apply to all records" then begin
                    RetentionPolicySetupLine.SetRange("Table ID", Rec."Table Id");
                    RetentionPolicySetupLine.SetRange(Locked, true);
                    if not RetentionPolicySetupLine.IsEmpty() then begin
                        Rec.CalcFields("Table Caption");
                        RetentionPolicyLog.LogError(LogCategory(), StrSubstNo(CannotApplyToAllRecordsErr, Rec."Table Id", Rec."Table Caption"))
                    end;
                end;

                if not Rec."Apply to all records" then
                    Rec."Retention Period" := '';
                Rec.Enabled := false;
            end;
        }
        field(7; "Date Field No."; Integer)
        {
            DataClassification = SystemMetadata;
            TableRelation = Field."No." where(TableNo = field("Table ID"), "Type" = filter(Date | DateTime));

            trigger OnValidate()
            begin
                Rec.CalcFields("Date Field Name", "Date Field Caption");
            end;

            trigger OnLookup()
            var
                RetentionPolicy: Codeunit "Retention Policy Setup";
            begin
                Rec.Validate("Date Field No.", RetentionPolicy.DateFieldNoLookup(Rec."Table Id", Rec."Date Field No."));
            end;
        }
        field(8; "Date Field Name"; Text[30])
        {
            FieldClass = FlowField;
            CalcFormula = lookup(Field.FieldName where(TableNo = field("Table ID"), "No." = field("Date Field No.")));
            Editable = false;
        }
        field(9; "Date Field Caption"; Text[80])
        {
            FieldClass = FlowField;
            CalcFormula = lookup(Field."Field Caption" where(TableNo = field("Table ID"), "No." = field("Date Field No.")));
            Editable = false;
        }
        field(10; Manual; Boolean)
        {
            DataClassification = SystemMetadata;
        }
        field(100; "Number Of Records Deleted"; Integer)
        {
            DataClassification = SystemMetadata;
            Access = Internal;
            Editable = false;
        }
    }

    keys
    {
        key(PrimaryKey; "Table Id")
        {
            Clustered = true;
        }
    }

    var
        NoLinesEnabledErr: Label 'You must enable at least one line.';
        CannotApplyToAllRecordsErr: Label 'You cannot toggle "Apply to all records" because the retention policy for table %1, %2 contains mandatory filters.', Comment = '%1 = table number, %2 = table caption';

    trigger OnDelete()
    var
        RetentionPolicySetupImpl: Codeunit "Retention Policy Setup Impl.";
    begin
        RetentionPolicySetupImpl.DeleteRetentionPolicySetup(Rec);
    end;

    trigger OnInsert()
    var
        MyCustomerAuditLoggerALHelper: DotNet CustomerAuditLoggerALHelper;
        MyALSecurityOperationResult: DotNet ALSecurityOperationResult;
        MyALAuditCategory: DotNet ALAuditCategory;
        NewRetentionPolicyCreatedLbl: Label 'The new Retention Policy record with Table ID %1 is created by the UserSecurityId %2.', Locked = true;
    begin
        MyCustomerAuditLoggerALHelper.LogAuditMessage(StrSubstNo(NewRetentionPolicyCreatedLbl, Rec."Table ID", UserSecurityId()), MyALSecurityOperationResult::Success, MyALAuditCategory::ApplicationManagement, 3, 0);
    end;

    local procedure LogCategory() RetentionPolicyLogCategory: Enum "Retention Policy Log Category"
    begin
        exit(RetentionPolicyLogCategory::"Retention Policy - Setup")
    end;
}