Table 8616 Config. Package Field

Base Application, System.IO

src/Layers/W1/BaseApp/System/RapidStart/ConfigPackageField.Table.al376 lines, Copyright (c) Microsoft Corporation. MIT

namespace System.IO;using System.Reflection;table 8616 "Config. Package Field"{    Caption = 'Config. Package Field';    ReplicateData = false;    DataClassification = CustomerContent;    fields    {        field(1; "Package Code"; Code[20])        {            Caption = 'Package Code';            NotBlank = true;            TableRelation = "Config. Package";        }        field(2; "Table ID"; Integer)        {            Caption = 'Table ID';            NotBlank = true;            TableRelation = AllObjWithCaption."Object ID" where("Object Type" = const(Table));        }        field(3; "Field ID"; Integer)        {            Caption = 'Field ID';            NotBlank = true;            TableRelation = Field."No." where(TableNo = field("Table ID"));            ValidateTableRelation = false;            trigger OnValidate()            begin                ValidateFieldIDTableRelation();            end;        }        field(4; "Field Name"; Text[30])        {            Caption = 'Field Name';            trigger OnValidate()            begin                "XML Field Name" := GetUniqueElementName("Field Name");            end;        }        field(5; "Field Caption"; Text[250])        {            Caption = 'Field Caption';        }        field(6; "Validate Field"; Boolean)        {            Caption = 'Validate Field';            trigger OnValidate()            var                ShouldRunCheck: Boolean;                IsHandled: Boolean;            begin                IsHandled := false;                OnBeforeValidateValidateField(Rec, IsHandled);                if IsHandled then                    exit;                ShouldRunCheck := not Dimension;                OnValidateFieldOnValidateOnAfterCalcShouldRunCheck(Rec, ShouldRunCheck);                if ShouldRunCheck then begin                    if "Validate Field" then                        ThrowErrorIfFieldRemoved();                    UpdateFieldErrors();                end;            end;        }        field(7; "Include Field"; Boolean)        {            Caption = 'Include Field';            trigger OnValidate()            var                ShouldRunCheck: Boolean;                IsHandled: Boolean;            begin                IsHandled := false;                OnBeforeValidateIncludeField(Rec, IsHandled);                if IsHandled then                    exit;                ShouldRunCheck := not Dimension;                OnIncludeFieldOnValidateOnAfterCalcShouldRunCheck(Rec, ShouldRunCheck);                if ShouldRunCheck then begin                    if xRec."Include Field" and not "Include Field" and "Primary Key" then                        Error(PrimaryKeyRequiredErr, "Field Caption");                    if "Include Field" then                        ThrowErrorIfFieldRemoved();                    "Validate Field" := "Include Field";                    UpdateFieldErrors();                end;            end;        }        field(8; "Localize Field"; Boolean)        {            Caption = 'Localize Field';        }        field(9; "Relation Table ID"; Integer)        {            Caption = 'Relation Table ID';            Editable = false;            TableRelation = AllObjWithCaption."Object ID" where("Object Type" = const(Table));        }        field(10; "Relation Table Caption"; Text[250])        {            CalcFormula = lookup(AllObjWithCaption."Object Name" where("Object Type" = const(Table),                                                                        "Object ID" = field("Relation Table ID")));            Caption = 'Relation Table Caption';            Editable = false;            FieldClass = FlowField;        }        field(11; Dimension; Boolean)        {            Caption = 'Dimension';            Editable = false;        }        field(12; "Primary Key"; Boolean)        {            Caption = 'Primary Key';            Editable = false;        }        field(13; "Processing Order"; Integer)        {            Caption = 'Processing Order';        }        field(14; "Create Missing Codes"; Boolean)        {            Caption = 'Create Missing Codes';            trigger OnValidate()            begin                if "Create Missing Codes" then                    TestField("Relation Table ID");            end;        }        field(15; "Mapping Exists"; Boolean)        {            CalcFormula = exist("Config. Field Map" where("Package Code" = field("Package Code"),                                                               "Table ID" = field("Table ID"),                                                               "Field ID" = field("Field ID")));            Caption = 'Mapping Exists';            Editable = false;            FieldClass = FlowField;        }        field(16; AutoIncrement; Boolean)        {            Caption = 'AutoIncrement';            DataClassification = SystemMetadata;            trigger OnValidate()            begin                TestField("Primary Key", false);                TestFieldIsInteger();            end;        }        field(20; "XML Field Name"; Text[30])        {            Caption = 'XML Field Name';            DataClassification = SystemMetadata;        }    }    keys    {        key(Key1; "Package Code", "Table ID", "Field ID")        {            Clustered = true;        }        key(Key2; "Package Code", "Table ID", "Include Field")        {        }        key(Key3; "Package Code", "Table ID", "Validate Field")        {        }        key(Key4; "Package Code", "Table ID", "Processing Order")        {        }    }    fieldgroups    {    }    trigger OnDelete()    begin        DeleteConfigFieldMap();    end;    var#pragma warning disable AA0470        PrimaryKeyRequiredErr: Label '%1 is part of the primary key and must be included.';        FieldValueNotExistErr: Label '%1 value ''%2'' does not exist.';#pragma warning restore AA0470        UpdateValErrsTxt: Label 'Updating validation errors';        MustBeIntegersErr: Label 'must be Integer or BigInteger';    local procedure UpdateFieldErrors()    var        ConfigPackageData: Record "Config. Package Data";        ConfigPackageField: Record "Config. Package Field";        TempConfigPackageTable: Record "Config. Package Table" temporary;        ConfigPackageRecord: Record "Config. Package Record";        ConfigPackageMgt: Codeunit "Config. Package Management";        ConfigValidateMgt: Codeunit "Config. Validate Management";        ConfigProgressBar: Codeunit "Config. Progress Bar";        RecRef: RecordRef;        FieldRef: FieldRef;        ErrorText: Text[250];        ShouldRunCheck: Boolean;    begin        ShouldRunCheck := not Dimension;        OnUpdateFieldErrorsOnAfterCalcShouldRunCheck(Rec, ShouldRunCheck);        if ShouldRunCheck then begin            if "Include Field" then begin                RecRef.Open("Table ID", true);                FieldRef := RecRef.Field("Field ID");            end;            ConfigPackageData.SetRange("Package Code", "Package Code");            ConfigPackageData.SetRange("Table ID", "Table ID");            ConfigPackageData.SetRange("Field ID", "Field ID");            if ConfigPackageData.FindSet() then begin                ConfigProgressBar.Init(ConfigPackageData.Count, 1, UpdateValErrsTxt);                repeat                    ConfigProgressBar.Update(ConfigPackageData.Value);                    ConfigPackageRecord.Get(                      ConfigPackageData."Package Code", ConfigPackageData."Table ID", ConfigPackageData."No.");                    ConfigPackageMgt.CleanFieldError(ConfigPackageData);                    if "Include Field" then begin                        ErrorText := CopyStr(ConfigValidateMgt.EvaluateValue(FieldRef, ConfigPackageData.Value, false), 1, MaxStrLen(ErrorText));                        ConfigPackageMgt.FieldError(ConfigPackageData, ErrorText, 0);                        if "Validate Field" then begin                            Clear(TempConfigPackageTable);                            ConfigPackageField.Init();                            ConfigPackageField.Reset();                            ConfigPackageField.SetRange("Package Code", "Package Code");                            ConfigPackageField.SetRange("Table ID", "Table ID");                            ConfigPackageField.SetRange("Field ID", "Field ID");                            if not ConfigPackageMgt.ValidateFieldRelationInRecord(                                 ConfigPackageField, TempConfigPackageTable, ConfigPackageRecord, RecRef)                            then                                ConfigPackageMgt.FieldError(ConfigPackageData, StrSubstNo(FieldValueNotExistErr, FieldRef.Caption, ConfigPackageData.Value), 0);                        end;                    end;                until ConfigPackageData.Next() = 0;                ConfigProgressBar.Close();            end;        end;    end;    local procedure DeleteConfigFieldMap()    var        ConfigFieldMap: Record "Config. Field Map";    begin        ConfigFieldMap.SetRange("Package Code", "Package Code");        ConfigFieldMap.SetRange("Table ID", "Table ID");        ConfigFieldMap.SetRange("Field ID", "Field ID");        ConfigFieldMap.DeleteAll();    end;    procedure GetRelationTablesID() Result: Text    var        TableRelationsMetadata: Record "Table Relations Metadata";    begin        TableRelationsMetadata.SetRange("Table ID", "Table ID");        TableRelationsMetadata.SetRange("Field No.", "Field ID");        if TableRelationsMetadata.FindSet() then            repeat                Result += Format(TableRelationsMetadata."Related Table ID") + '|';            until TableRelationsMetadata.Next() = 0;        exit(DelChr(Result, '>', '|'));    end;    local procedure TestFieldIsInteger()    var        "Field": Record "Field";    begin        if Field.Get("Table ID", "Field ID") then            if not (Field.Type in [Field.Type::BigInteger, Field.Type::Integer]) then                Field.FieldError(Type, MustBeIntegersErr);    end;    local procedure ThrowErrorIfFieldRemoved()    var        "Field": Record "Field";        TypeHelper: Codeunit "Type Helper";    begin        Field.Get("Table ID", "Field ID");        TypeHelper.TestFieldIsNotObsolete(Field);    end;    procedure GetElementName(): Text[250]    var        ConfigXMLExchange: Codeunit "Config. XML Exchange";    begin        if "XML Field Name" <> '' then            exit("XML Field Name");        exit(ConfigXMLExchange.GetElementName("Field Name"));    end;    procedure GetValidatedElementName(): Text    var        ConfigValidateMgt: Codeunit "Config. Validate Management";    begin        exit(ConfigValidateMgt.CheckName(GetElementName()));    end;    local procedure GetUniqueElementName(FieldName: Text[30]): Text[30]    var        ConfigPackageField: Record "Config. Package Field";        ConfigXMLExchange: Codeunit "Config. XML Exchange";        ElementName: Text[30];        NewFieldName: Text;    begin        ElementName := CopyStr(ConfigXMLExchange.GetElementName(FieldName), 1, MaxStrLen(ElementName));        ConfigPackageField.SetRange("Package Code", "Package Code");        ConfigPackageField.SetRange("Table ID", "Table ID");        ConfigPackageField.SetFilter("Field ID", '<>%1', "Field ID");        ConfigPackageField.SetRange("XML Field Name", ElementName);        if not ConfigPackageField.IsEmpty() then begin            NewFieldName := IncStr(FieldName);            if NewFieldName = '' then                NewFieldName := FieldName + '1';            exit(GetUniqueElementName(CopyStr(NewFieldName, 1, MaxStrLen(FieldName))));        end;        exit(ElementName);    end;    local procedure ValidateFieldIDTableRelation()    var        FieldRec: Record Field;        ShouldValidate: Boolean;    begin        ShouldValidate := not Dimension;        OnBeforeValidateFieldIDTableRelation(Rec, ShouldValidate);        if ShouldValidate then            FieldRec.Get("Table ID", "Field ID");    end;    [IntegrationEvent(false, false)]    local procedure OnIncludeFieldOnValidateOnAfterCalcShouldRunCheck(var ConfigPackageField: Record "Config. Package Field"; var ShouldRunCheck: Boolean)    begin    end;    [IntegrationEvent(false, false)]    local procedure OnBeforeValidateIncludeField(var ConfigPackageField: Record "Config. Package Field"; var IsHandled: Boolean)    begin    end;    [IntegrationEvent(false, false)]    local procedure OnBeforeValidateValidateField(var ConfigPackageField: Record "Config. Package Field"; var IsHandled: Boolean)    begin    end;    [IntegrationEvent(false, false)]    local procedure OnBeforeValidateFieldIDTableRelation(var ConfigPackageField: Record "Config. Package Field"; var ShouldValidate: Boolean)    begin    end;    [IntegrationEvent(false, false)]    local procedure OnValidateFieldOnValidateOnAfterCalcShouldRunCheck(var ConfigPackageField: Record "Config. Package Field"; var ShouldRunCheck: Boolean)    begin    end;    [IntegrationEvent(false, false)]    local procedure OnUpdateFieldErrorsOnAfterCalcShouldRunCheck(var ConfigPackageField: Record "Config. Package Field"; var ShouldRunCheck: Boolean)    begin    end;}