Table 5111 Rating
src/Layers/W1/BaseApp/CRM/Profiling/Rating.Table.al127 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.Profiling;table 5111 Rating{ Caption = 'Rating'; DataClassification = CustomerContent; fields { field(1; "Profile Questionnaire Code"; Code[20]) { Caption = 'Profile Questionnaire Code'; ToolTip = 'Specifies the code for the profile questionnaire that contains the question you use to create your rating.'; NotBlank = true; TableRelation = "Profile Questionnaire Header"; } field(2; "Profile Questionnaire Line No."; Integer) { Caption = 'Profile Questionnaire Line No.'; NotBlank = true; TableRelation = "Profile Questionnaire Line"."Line No." where("Profile Questionnaire Code" = field("Profile Questionnaire Code"), Type = const(Question), "Contact Class. Field" = const(Rating)); } field(3; "Rating Profile Quest. Code"; Code[20]) { Caption = 'Rating Profile Quest. Code'; ToolTip = 'Specifies the code for the profile questionnaire that contains the answer you use to create your rating.'; NotBlank = true; TableRelation = "Profile Questionnaire Header"; } field(4; "Rating Profile Quest. Line No."; Integer) { Caption = 'Rating Profile Quest. Line No.'; NotBlank = true; TableRelation = "Profile Questionnaire Line"."Line No." where("Profile Questionnaire Code" = field("Rating Profile Quest. Code"), Type = const(Answer)); } field(5; Points; Decimal) { AutoFormatType = 0; BlankZero = true; Caption = 'Points'; ToolTip = 'Specifies the number of points you have assigned to this answer.'; DecimalPlaces = 0 : 0; } field(6; "Profile Question Description"; Text[250]) { CalcFormula = lookup("Profile Questionnaire Line".Description where("Profile Questionnaire Code" = field("Profile Questionnaire Code"), "Line No." = field("Profile Questionnaire Line No."))); Caption = 'Profile Question Description'; ToolTip = 'Specifies the description you have entered for this rating question in the Description field in the Profile Questionnaire Setup window.'; Editable = false; FieldClass = FlowField; } } keys { key(Key1; "Profile Questionnaire Code", "Profile Questionnaire Line No.", "Rating Profile Quest. Code", "Rating Profile Quest. Line No.") { Clustered = true; } key(Key2; "Rating Profile Quest. Code", "Rating Profile Quest. Line No.") { } } fieldgroups { } trigger OnInsert() var ProfileQuestionnaireLine: Record "Profile Questionnaire Line"; begin ProfileQuestionnaireLine.Get("Profile Questionnaire Code", "Profile Questionnaire Line No."); CalcFields("Profile Question Description"); ErrorMessage := "Profile Question Description"; if RatingDeadlock(ProfileQuestionnaireLine, Rec) then Error(CopyStr( StrSubstNo(Text000, ProfileQuestionnaireLine.Description) + "Profile Question Description" + ' -> ' + ErrorMessage, 1, 1024)); end; var#pragma warning disable AA0074#pragma warning disable AA0470 Text000: Label 'Rating deadlock involving question %1 - insert aborted.\';#pragma warning restore AA0470#pragma warning restore AA0074 ErrorMessage: Text[1024]; local procedure RatingDeadlock(TargetProfileQuestnLine: Record "Profile Questionnaire Line"; NextRating: Record Rating) Deadlock: Boolean var Rating2: Record Rating; ProfileQuestionnaireLine: Record "Profile Questionnaire Line"; begin Deadlock := false; ProfileQuestionnaireLine.Get(NextRating."Rating Profile Quest. Code", NextRating."Rating Profile Quest. Line No."); Rating2.SetRange("Profile Questionnaire Code", NextRating."Rating Profile Quest. Code"); Rating2.SetRange("Profile Questionnaire Line No.", ProfileQuestionnaireLine.FindQuestionLine()); if Rating2.Find('-') then repeat ProfileQuestionnaireLine.Get(Rating2."Rating Profile Quest. Code", Rating2."Rating Profile Quest. Line No."); ProfileQuestionnaireLine.Get(Rating2."Rating Profile Quest. Code", ProfileQuestionnaireLine.FindQuestionLine()); if (TargetProfileQuestnLine."Profile Questionnaire Code" = ProfileQuestionnaireLine."Profile Questionnaire Code") and (TargetProfileQuestnLine."Line No." = ProfileQuestionnaireLine."Line No.") then Deadlock := true else if RatingDeadlock(TargetProfileQuestnLine, Rating2) then Deadlock := true; until (Deadlock = true) or (Rating2.Next() = 0); if Deadlock then begin Rating2.CalcFields("Profile Question Description"); ErrorMessage := CopyStr(Rating2."Profile Question Description" + ' -> ' + ErrorMessage, 1, 1024); end; end;}