Table 5095 Duplicate Search String Setup

Base Application, Microsoft.CRM.Duplicates

src/Layers/W1/BaseApp/CRM/Duplicates/DuplicateSearchStringSetup.Table.al123 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 Microsoft.CRM.Duplicates;using Microsoft.CRM.Contact;using System.Reflection;table 5095 "Duplicate Search String Setup"{    Caption = 'Duplicate Search String Setup';    DataClassification = CustomerContent;    Permissions = tabledata "Cont. Duplicate Search String" = id;    fields    {        field(1; "Field No."; Integer)        {            Caption = 'Field No.';            trigger OnValidate()            var                "Field": Record "Field";            begin                Field.Get(DATABASE::Contact, "Field No.");                "Field Name" := Field.FieldName;            end;        }        field(2; "Part of Field"; Enum "Duplicate Search String Part")        {            Caption = 'Part of Field';            ToolTip = 'Specifies the part of the field to use to generate the search string. There are two options: First and Last.';        }        field(3; Length; Integer)        {            Caption = 'Length';            ToolTip = 'Specifies how many characters the search string will contain. You can enter a number from 2 to 10. The program automatically enters 5 as a default value.';            InitValue = 5;            MaxValue = 10;            MinValue = 2;        }        field(4; "Field Name"; Text[30])        {            Caption = 'Field Name';            ToolTip = 'Specifies the field to use to generate the search string.';        }    }    keys    {        key(Key1; "Field No.", "Part of Field")        {            Clustered = true;        }    }    fieldgroups    {    }    trigger OnDelete()    var        ContDuplicateSearchString: Record "Cont. Duplicate Search String";    begin        ContDuplicateSearchString.SetRange("Field No.", "Field No.");        ContDuplicateSearchString.SetRange("Part of Field", "Part of Field");        ContDuplicateSearchString.DeleteAll();    end;    procedure CreateDefaultSetup()    var        Contact: Record Contact;    begin        DeleteAll();        InsertDuplicateSearchString(Contact.FieldNo(Name), 5);        InsertDuplicateSearchString(Contact.FieldNo(Address), 5);        InsertDuplicateSearchString(Contact.FieldNo(City), 5);        InsertDuplicateSearchString(Contact.FieldNo("Phone No."), 5);        InsertDuplicateSearchString(Contact.FieldNo("VAT Registration No."), 5);        InsertDuplicateSearchString(Contact.FieldNo("Post Code"), 5);        InsertDuplicateSearchString(Contact.FieldNo("E-Mail"), 5);        InsertDuplicateSearchString(Contact.FieldNo("Mobile Phone No."), 5);    end;    local procedure InsertDuplicateSearchString(FieldNo: Integer; SearchLength: Integer)    begin        Init();        Validate("Field No.", FieldNo);        Validate("Part of Field", "Part of Field"::First);        Validate(Length, SearchLength);        Insert();        Validate("Part of Field", "Part of Field"::Last);        Insert();    end;    procedure LookupFieldName()    var        "Field": Record "Field";        FieldSelection: Codeunit "Field Selection";        IsHandled: Boolean;    begin        IsHandled := false;        OnBeforeLookupFieldName(Rec, Field, IsHandled);        if IsHandled then            exit;        Field.SetRange(TableNo, DATABASE::Contact);        Field.SetFilter(Type, '%1|%2', Field.Type::Text, Field.Type::Code);        Field.SetRange(Class, Field.Class::Normal);        if FieldSelection.Open(Field) then            Validate("Field No.", Field."No.");    end;    [IntegrationEvent(false, false)]    local procedure OnBeforeLookupFieldName(var DuplicateSearchStringSetup: Record "Duplicate Search String Setup"; var Field: Record "Field"; var IsHandled: Boolean)    begin    end;}