Table 9805 Table Filter
src/Layers/W1/BaseApp/System/TableFilter.Table.al91 lines, Copyright (c) Microsoft Corporation. MIT
namespace System.Text;using System.Reflection;table 9805 "Table Filter"{ Caption = 'Table Filter'; DataClassification = CustomerContent; fields { field(1; "Table Number"; Integer) { Caption = 'Table Number'; } field(2; "Line No."; Integer) { Caption = 'Line No.'; } field(4; "Table Name"; Text[30]) { Caption = 'Table Name'; } field(5; "Field Number"; Integer) { Caption = 'Field Number'; TableRelation = Field."No." where(TableNo = field("Table Number")); trigger OnValidate() var "Field": Record "Field"; TypeHelper: Codeunit "Type Helper"; begin if xRec."Field Number" = "Field Number" then exit; Field.Get("Table Number", "Field Number"); TypeHelper.TestFieldIsNotObsolete(Field); CheckDuplicateField(Field); "Field Caption" := Field."Field Caption"; "Field Filter" := ''; end; } field(6; "Field Name"; Text[30]) { Caption = 'Field Name'; } field(7; "Field Caption"; Text[80]) { Caption = 'Field Caption'; } field(8; "Field Filter"; Text[250]) { Caption = 'Field Filter'; } } keys { key(Key1; "Table Number", "Line No.") { Clustered = true; } } fieldgroups { } var#pragma warning disable AA0470 DuplicateFilterErr: Label 'The filter for the field %1 %2 already exists.', Comment = 'The filter for the field <Field Number> <Field Name> already exists. Example: The filter for the field 15 Base Unit of Measure already exists.';#pragma warning restore AA0470 procedure CheckDuplicateField("Field": Record "Field") var TableFilter: Record "Table Filter"; begin TableFilter.Copy(Rec); Reset(); SetRange("Table Number", Field.TableNo); SetRange("Field Number", Field."No."); SetFilter("Line No.", '<>%1', "Line No."); if not IsEmpty() then Error(DuplicateFilterErr, Field."No.", Field."Field Caption"); Copy(TableFilter); end;}