Table 5111 Rating

Base Application, Microsoft.CRM.Profiling

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;}