Table 5095 Duplicate Search String Setup
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;}