Table 3902 Retention Policy Setup Line

System Application, System.DataAdministration

src/System Application/App/Retention Policy/src/Retention Policy Setup/RetentionPolicySetupLine.Table.al162 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.DataAdministration;using System.Reflection;/// <summary>/// This table stores the filter used to apply retention policies to subsets of records in a table./// </summary>table 3902 "Retention Policy Setup Line"{    fields    {        field(1; "Table ID"; Integer)        {            DataClassification = SystemMetadata;            Editable = false;        }        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;        }        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; "Line No."; Integer)        {            DataClassification = SystemMetadata;            Editable = false;        }        field(5; Enabled; Boolean)        {            DataClassification = SystemMetadata;            trigger OnValidate()            begin                if Rec.Enabled then                    Rec.TestField("Retention Period")            end;        }        field(6; "Retention Period"; Code[20])        {            DataClassification = SystemMetadata;            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(7; "Date Field No."; Integer)        {            DataClassification = SystemMetadata;            TableRelation = Field."No." where(TableNo = field("Table ID"), "Type" = filter(Date | DateTime));            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; "Table Filter"; Blob)        {            DataClassification = CustomerContent;            Access = Internal;        }        field(11; "Table Filter Text"; Text[2048])        {            DataClassification = CustomerContent;            Access = Internal;        }        field(12; Locked; Boolean)        {            Access = Internal;            DataClassification = SystemMetadata;            Editable = false;            trigger OnValidate()            begin                if Locked then                    Validate(Enabled, true);            end;        }    }    keys    {        key(PrimaryKey; "Table ID", "Line No.")        {            Clustered = true;        }    }    /// <summary>    /// Use this procedure to open a Filter Page Builder page and store the resulting filter in view format on the current record.    /// </summary>    procedure SetTableFilter()    var        RetentionPolicySetup: Codeunit "Retention Policy Setup";    begin        Rec."Table Filter Text" := RetentionPolicySetup.SetTableFilterView(Rec);    end;    /// <summary>    /// Use this procedure to get the filter in view format stored in the current record.    /// </summary>    /// <returns>The filter in the view format. </returns>    procedure GetTableFilterView(): Text    var        RetentionPolicySetup: Codeunit "Retention Policy Setup";    begin        exit(RetentionPolicySetup.GetTableFilterView(Rec));    end;    /// <summary>    /// Use this procedure to get the filter in text format stored in the current record.    /// </summary>    /// <returns>The Filter in text format.</returns>    procedure GetTableFilterText(): Text[2048]    var        RetentionPolicySetup: Codeunit "Retention Policy Setup";    begin        exit(RetentionPolicySetup.GetTableFilterText(Rec));    end;    /// <summary>    /// Use this procedure to verify whether the retention policy setup line is locked.    /// </summary>    /// <returns>True if the line is locked.</returns>    procedure IsLocked(): Boolean    begin        exit(Rec.Locked)    end;}