Table 5392 CRM Annotation Coupling
src/Layers/W1/BaseApp/Integration/D365Sales/CRMAnnotationCoupling.Table.al120 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.Integration.D365Sales;using System;using System.Environment.Configuration;using System.Utilities;table 5392 "CRM Annotation Coupling"{ Caption = 'CRM Annotation Coupling'; DataClassification = CustomerContent; fields { field(2; "Record Link Record ID"; RecordID) { Caption = 'Record Link Record ID'; DataClassification = CustomerContent; } field(3; "CRM Annotation ID"; Guid) { Caption = 'CRM Annotation ID'; DataClassification = SystemMetadata; } field(4; "Last Synch. DateTime"; DateTime) { Caption = 'Last Synch. DateTime'; DataClassification = SystemMetadata; } field(5; "CRM Created On"; DateTime) { Caption = 'CRM Created On'; DataClassification = SystemMetadata; } field(6; "CRM Modified On"; DateTime) { Caption = 'CRM Modified On'; DataClassification = SystemMetadata; } } keys { key(Key1; "Record Link Record ID", "CRM Annotation ID") { Clustered = true; } key(Key2; "Last Synch. DateTime") { } key(Key3; "CRM Created On") { } key(Key4; "CRM Modified On") { } } fieldgroups { } var RecordLinkAlreadyCoupledErr: Label 'Record Link %1 is already coupled to another CRM Annotation.', Comment = '%1 - an integer'; CRMAnnotationAlreadyCoupledErr: Label 'CRM Annotation %1 is already coupled to another Record Link.', Comment = '%1 - a GUID'; [Scope('OnPrem')] procedure CoupleRecordLinkToCRMAnnotation(RecordLink: Record "Record Link"; CRMAnnotation: Record "CRM Annotation") begin if Get(RecordLink.RecordId, CRMAnnotation.AnnotationId) then exit; if FindByRecordId(RecordLink.RecordId) then Error(RecordLinkAlreadyCoupledErr, RecordLink."Link ID"); if FindByCRMId(CRMAnnotation.AnnotationId) then Error(CRMAnnotationAlreadyCoupledErr, CRMAnnotation.AnnotationId); Init(); "Record Link Record ID" := RecordLink.RecordId; "CRM Annotation ID" := CRMAnnotation.AnnotationId; "Last Synch. DateTime" := CurrentDateTime; "CRM Created On" := CRMAnnotation.CreatedOn; "CRM Modified On" := CRMAnnotation.ModifiedOn; Insert(); end; [Scope('OnPrem')] procedure FindByRecordId(RecordId: RecordID): Boolean begin SetRange("Record Link Record ID", RecordId); exit(FindFirst()); end; [Scope('OnPrem')] procedure FindByCRMId(CRMId: Guid): Boolean begin SetRange("CRM Annotation ID", CRMId); exit(FindFirst()); end; procedure ExtractNoteText(AnnotationText: Text): Text var Regex: Codeunit Regex; HttpUtility: DotNet HttpUtility; LF: Char; begin LF := 10; AnnotationText := Regex.Replace(AnnotationText, '</p>', Format(LF)); AnnotationText := Regex.Replace(AnnotationText, '<.*?>', ''); AnnotationText := AnnotationText.Trim(); AnnotationText := HttpUtility.HtmlDecode(AnnotationText); exit(AnnotationText); end;}