Page 20445 Qlty. Test Lookup

Quality Management, Microsoft.QualityManagement.Configuration.Template.Test

src/Apps/W1/Quality Management/app/src/Configuration/Template/Test/QltyTestLookup.Page.al469 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.QualityManagement.Configuration.Template.Test;using Microsoft.QualityManagement.Configuration.Result;/// <summary>/// This page lets you define data points, questions, measurements, and entries with their allowable values and default passing thresholds. You can later use these tests in Quality Inspection Templates./// </summary>page 20445 "Qlty. Test Lookup"{    Caption = 'Quality Test Lookup';    AboutTitle = 'Configure Available Tests';    AboutText = 'This page lets you define data points, questions, measurements, and entries with their allowable values and default passing thresholds. You can later use these tests in Quality Inspection Templates.';    PageType = List;    SourceTable = "Qlty. Test";    SourceTableView = sorting(Code);    UsageCategory = None;    ApplicationArea = QualityManagement;    CardPageId = "Qlty. Test Card";    layout    {        area(Content)        {            repeater(GroupTests)            {                ShowCaption = false;                field("Code"; Rec.Code)                {                    AboutTitle = 'Code';                    AboutText = 'The short code to identify the test. You can enter a maximum of 20 characters, both numbers and letters.';                }                field(Description; Rec.Description)                {                    AboutTitle = 'Description';                    AboutText = 'The friendly description for the Test. You can enter a maximum of 100 characters, both numbers and letters.';                }                field("Test Value Type"; Rec."Test Value Type")                {                    trigger OnValidate()                    begin                        UpdateRowData();                    end;                }                field("Allowable Values"; Rec."Allowable Values")                {                    Editable = IsAllowableValuesEditable;                    AboutTitle = 'Allowable Values';                    AboutText = 'What the quality inspector can enter and the range of information they can put in. For example if you want a measurement such as a percentage that collects between 0 and 100 you would enter 0..100. This is not the pass or acceptable condition, these are just the technically possible values that the inspector can enter. You would then enter a passing condition in your result conditions. If you had a result of Pass being 80 to 100, you would then configure 80..100 for that result.';                    trigger OnAssistEdit()                    begin                        Rec.AssistEditAllowableValues();                    end;                }                field("Default Value"; Rec."Default Value")                {                    AboutTitle = 'Default Value';                    AboutText = 'A default value to set on the test.';                    trigger OnAssistEdit()                    begin                        Rec.AssistEditDefaultValue();                    end;                }                field("Unit of Measure Code"; Rec."Unit of Measure Code")                {                }                field(Field1; MatrixArrayConditionCellData[1])                {                    CaptionClass = '3,' + StrSubstNo(ConditionLbl, MatrixArrayCaptionSet[1]);                    ToolTip = 'Specifies the passing condition for this result. If you had a result of Pass being 80 to 100, you would then configure 80..100 here.';                    AboutTitle = 'Result Condition Expression';                    AboutText = 'The passing condition for this result. If you had a result of Pass being 80 to 100, you would then configure 80..100 here.';                    Visible = Visible1;                    Editable = Editable1;                    trigger OnValidate()                    begin                        UpdateMatrixDataCondition(1);                    end;                }                field(Field1_Desc; MatrixArrayConditionDescriptionCellData[1])                {                    CaptionClass = '3,' + StrSubstNo(DescriptionLbl, MatrixArrayCaptionSet[1]);                    ToolTip = 'Specifies a description for people of this result condition. If you had a result of Pass being 80 to 100, you would put in text describing this. This text will be visible when recording inspections and will show up on the Certificate of Analysis.';                    AboutTitle = 'Result Condition Description';                    AboutText = 'A description for people of this result condition. If you had a result of Pass being 80 to 100, you would put in text describing this. This text will be visible when recording inspections and will show up on the Certificate of Analysis.';                    Visible = Visible1;                    Editable = Editable1;                    trigger OnValidate()                    begin                        UpdateMatrixDataConditionDescription(1);                    end;                }                field(Field2; MatrixArrayConditionCellData[2])                {                    CaptionClass = '3,' + StrSubstNo(ConditionLbl, MatrixArrayCaptionSet[2]);                    ToolTip = 'Specifies the passing condition for this result. If you had a result of Pass being 80 to 100, you would then configure 80..100 here.';                    AboutTitle = 'Result Condition Expression';                    AboutText = 'The passing condition for this result. If you had a result of Pass being 80 to 100, you would then configure 80..100 here.';                    Visible = Visible2;                    Editable = Editable2;                    trigger OnValidate()                    begin                        UpdateMatrixDataCondition(2);                    end;                }                field(Field2_Desc; MatrixArrayConditionDescriptionCellData[2])                {                    CaptionClass = '3,' + StrSubstNo(DescriptionLbl, MatrixArrayCaptionSet[2]);                    ToolTip = 'Specifies a description for people of this result condition. If you had a result of Pass being 80 to 100, you would put in text describing this. This text will be visible when recording inspections and will show up on the Certificate of Analysis.';                    AboutTitle = 'Result Condition Description';                    AboutText = 'A description for people of this result condition. If you had a result of Pass being 80 to 100, you would put in text describing this. This text will be visible when recording inspections and will show up on the Certificate of Analysis.';                    Visible = Visible2;                    Editable = Editable2;                    trigger OnValidate()                    begin                        UpdateMatrixDataConditionDescription(2);                    end;                }                field(Field3; MatrixArrayConditionCellData[3])                {                    CaptionClass = '3,' + StrSubstNo(ConditionLbl, MatrixArrayCaptionSet[3]);                    ToolTip = 'Specifies the passing condition for this result. If you had a result of Pass being 80 to 100, you would then configure 80..100 here.';                    AboutTitle = 'Result Condition Expression';                    AboutText = 'The passing condition for this result. If you had a result of Pass being 80 to 100, you would then configure 80..100 here.';                    Visible = Visible3;                    Editable = Editable3;                    trigger OnValidate()                    begin                        UpdateMatrixDataCondition(3);                    end;                }                field(Field3_Desc; MatrixArrayConditionDescriptionCellData[3])                {                    CaptionClass = '3,' + StrSubstNo(DescriptionLbl, MatrixArrayCaptionSet[3]);                    ToolTip = 'Specifies a description for people of this result condition. If you had a result of Pass being 80 to 100, you would put in text describing this. This text will be visible when recording inspections and will show up on the Certificate of Analysis.';                    AboutTitle = 'Result Condition Description';                    AboutText = 'A description for people of this result condition. If you had a result of Pass being 80 to 100, you would put in text describing this. This text will be visible when recording inspections and will show up on the Certificate of Analysis.';                    Visible = Visible3;                    Editable = Editable3;                    trigger OnValidate()                    begin                        UpdateMatrixDataConditionDescription(3);                    end;                }                field(Field4; MatrixArrayConditionCellData[4])                {                    CaptionClass = '3,' + StrSubstNo(ConditionLbl, MatrixArrayCaptionSet[4]);                    ToolTip = 'Specifies a test condition for a promoted result. This is dynamic based on the promoted results, this is result condition 4.';                    Visible = Visible4;                    Editable = Editable4;                    trigger OnValidate()                    begin                        UpdateMatrixDataCondition(4);                    end;                }                field(Field4_Desc; MatrixArrayConditionDescriptionCellData[4])                {                    CaptionClass = '3,' + StrSubstNo(DescriptionLbl, MatrixArrayCaptionSet[4]);                    ToolTip = 'Specifies a test condition for a promoted result. This is dynamic based on the promoted results, this is result condition 4.';                    Visible = Visible4;                    Editable = Editable4;                    trigger OnValidate()                    begin                        UpdateMatrixDataConditionDescription(4);                    end;                }                field(Field5; MatrixArrayConditionCellData[5])                {                    CaptionClass = '3,' + StrSubstNo(ConditionLbl, MatrixArrayCaptionSet[5]);                    ToolTip = 'Specifies a test condition for a promoted result. This is dynamic based on the promoted results, this is result condition 5.';                    Visible = Visible5;                    Editable = Editable5;                    trigger OnValidate()                    begin                        UpdateMatrixDataCondition(5);                    end;                }                field(Field5_Desc; MatrixArrayConditionDescriptionCellData[5])                {                    CaptionClass = '3,' + StrSubstNo(DescriptionLbl, MatrixArrayCaptionSet[5]);                    ToolTip = 'Specifies a test condition for a promoted result. This is dynamic based on the promoted results, this is result condition 5.';                    Visible = Visible5;                    Editable = Editable5;                    trigger OnValidate()                    begin                        UpdateMatrixDataConditionDescription(5);                    end;                }                field(Field6; MatrixArrayConditionCellData[6])                {                    CaptionClass = '3,' + StrSubstNo(ConditionLbl, MatrixArrayCaptionSet[6]);                    ToolTip = 'Specifies a test condition for a promoted result. This is dynamic based on the promoted results, this is result condition 6.';                    Visible = Visible6;                    Editable = Editable6;                    trigger OnValidate()                    begin                        UpdateMatrixDataCondition(6);                    end;                }                field(Field6_Desc; MatrixArrayConditionDescriptionCellData[6])                {                    CaptionClass = '3,' + StrSubstNo(DescriptionLbl, MatrixArrayCaptionSet[6]);                    ToolTip = 'Specifies a test condition for a promoted result. This is dynamic based on the promoted results, this is result condition 6.';                    Visible = Visible6;                    Editable = Editable6;                    trigger OnValidate()                    begin                        UpdateMatrixDataConditionDescription(6);                    end;                }                field(Field7; MatrixArrayConditionCellData[7])                {                    CaptionClass = '3,' + StrSubstNo(ConditionLbl, MatrixArrayCaptionSet[7]);                    ToolTip = 'Specifies a test condition for a promoted result. This is dynamic based on the promoted results, this is result condition 7.';                    Visible = Visible7;                    Editable = Editable7;                    trigger OnValidate()                    begin                        UpdateMatrixDataCondition(7);                    end;                }                field(Field7_Desc; MatrixArrayConditionDescriptionCellData[7])                {                    CaptionClass = '3,' + StrSubstNo(DescriptionLbl, MatrixArrayCaptionSet[7]);                    ToolTip = 'Specifies a test condition for a promoted result. This is dynamic based on the promoted results, this is result condition 7.';                    Visible = Visible7;                    Editable = Editable7;                    trigger OnValidate()                    begin                        UpdateMatrixDataConditionDescription(7);                    end;                }                field(Field8; MatrixArrayConditionCellData[8])                {                    CaptionClass = '3,' + StrSubstNo(ConditionLbl, MatrixArrayCaptionSet[8]);                    ToolTip = 'Specifies a test condition for a promoted result. This is dynamic based on the promoted results, this is result condition 8.';                    Visible = Visible8;                    Editable = Editable8;                    trigger OnValidate()                    begin                        UpdateMatrixDataCondition(8);                    end;                }                field(Field8_Desc; MatrixArrayConditionDescriptionCellData[8])                {                    CaptionClass = '3,' + StrSubstNo(DescriptionLbl, MatrixArrayCaptionSet[8]);                    ToolTip = 'Specifies a test condition for a promoted result. This is dynamic based on the promoted results, this is result condition 8.';                    Visible = Visible8;                    Editable = Editable8;                    trigger OnValidate()                    begin                        UpdateMatrixDataConditionDescription(8);                    end;                }                field(Field9; MatrixArrayConditionCellData[9])                {                    CaptionClass = '3,' + StrSubstNo(ConditionLbl, MatrixArrayCaptionSet[9]);                    ToolTip = 'Specifies a test condition for a promoted result. This is dynamic based on the promoted results, this is result condition 9.';                    Visible = Visible9;                    Editable = Editable9;                    trigger OnValidate()                    begin                        UpdateMatrixDataCondition(9);                    end;                }                field(Field9_Desc; MatrixArrayConditionDescriptionCellData[9])                {                    CaptionClass = '3,' + StrSubstNo(DescriptionLbl, MatrixArrayCaptionSet[9]);                    ToolTip = 'Specifies a test condition for a promoted result. This is dynamic based on the promoted results, this is result condition 9.';                    Visible = Visible9;                    Editable = Editable9;                    trigger OnValidate()                    begin                        UpdateMatrixDataConditionDescription(9);                    end;                }                field(Field10; MatrixArrayConditionCellData[10])                {                    CaptionClass = '3,' + StrSubstNo(ConditionLbl, MatrixArrayCaptionSet[10]);                    ToolTip = 'Specifies a test condition for a promoted result. This is dynamic based on the promoted results, this is result condition 10.';                    Visible = Visible10;                    Editable = Editable10;                    trigger OnValidate()                    begin                        UpdateMatrixDataCondition(10);                    end;                }                field(Field10_Desc; MatrixArrayConditionDescriptionCellData[10])                {                    CaptionClass = '3,' + StrSubstNo(DescriptionLbl, MatrixArrayCaptionSet[10]);                    ToolTip = 'Specifies a test condition for a promoted result. This is dynamic based on the promoted results, this is result condition 10.';                    Visible = Visible10;                    Editable = Editable10;                    trigger OnValidate()                    begin                        UpdateMatrixDataConditionDescription(10);                    end;                }                field("Lookup Table No."; Rec."Lookup Table No.")                {                    Visible = false;                    AboutTitle = 'Lookup Table No.';                    AboutText = 'When using a table lookup as a data type then this defines which table you are looking up. For example, if you want to show a list of available reason codes from the reason code table then you would use table 231 "Reason Code" here.';                    trigger OnAssistEdit()                    begin                        Rec.AssistEditLookupTable();                    end;                }                field("Lookup Table Name"; Rec."Lookup Table Caption")                {                    Visible = false;                    AboutTitle = 'Lookup Table No.';                    AboutText = 'The name of the lookup table. When using a table lookup as a data type then this is the name of the table that you are looking up. For example, if you want to show a list of available reason codes from the reason code table then you would use table 231 "Reason Code" here.';                    trigger OnAssistEdit()                    begin                        Rec.AssistEditLookupTable();                    end;                }                field("Lookup Field No."; Rec."Lookup Field No.")                {                    Visible = false;                    AboutTitle = 'Lookup Field No.';                    AboutText = 'This is the field within the Lookup Table to use for the lookup. For example if you had table 231 "Reason Code" as your lookup table, then you could use from the "Reason Code" table field "1" which represents the field "Code" on that table. When someone is recording an inspection, and choosing the test value they would then see as options the values from this field.';                    trigger OnAssistEdit()                    begin                        Rec.AssistEditLookupField();                    end;                }                field("Lookup Field Name"; Rec."Lookup Field Caption")                {                    Visible = false;                    AboutTitle = 'Lookup Field Name';                    AboutText = 'This is the name of the field within the Lookup Table to use for the lookup. For example if you had table 231 "Reason Code" as your lookup table, and also were using field "1" as the Lookup Field (which represents the field "Code" on that table) then this would show "Code"';                    trigger OnAssistEdit()                    begin                        Rec.AssistEditLookupField();                    end;                }                field("Lookup Table Filter"; Rec."Lookup Table Filter")                {                    Visible = false;                    AboutTitle = 'Lookup Table Filter';                    AboutText = 'This allows you to restrict which data are available from the Lookup Table by using a standard Business Central filter expression. For example if you were using table 231 "Reason Code" as your lookup table and wanted to restrict the options to codes that started with "R" then you could enter: where("Code"=filter(R*))';                    trigger OnAssistEdit()                    begin                        Rec.AssistEditLookupTableFilter();                    end;                }            }        }    }    var        QltyResultConditionMgmt: Codeunit "Qlty. Result Condition Mgmt.";        MatrixSourceRecordId: array[10] of RecordId;        MatrixArrayConditionCellData: array[10] of Text;        MatrixArrayConditionDescriptionCellData: array[10] of Text;        MatrixArrayCaptionSet: array[10] of Text;        Visible1, Visible2, Visible3, Visible4, Visible5, Visible6, Visible7, Visible8, Visible9, Visible10 : Boolean;        Editable1, Editable2, Editable3, Editable4, Editable5, Editable6, Editable7, Editable8, Editable9, Editable10 : Boolean;        IsAllowableValuesEditable: Boolean;        DescriptionLbl: Label '%1 Description', Comment = '%1 = Matrix field caption';        ConditionLbl: Label '%1 Condition', Comment = '%1 = Matrix field caption';    trigger OnOpenPage()    var        MatrixVisibleState: array[10] of Boolean;    begin        QltyResultConditionMgmt.GetDefaultPromotedResults(true, MatrixSourceRecordId, MatrixArrayConditionCellData, MatrixArrayConditionDescriptionCellData, MatrixArrayCaptionSet, MatrixVisibleState);        Visible1 := MatrixVisibleState[1];        Visible2 := MatrixVisibleState[2];        Visible3 := MatrixVisibleState[3];        Visible4 := MatrixVisibleState[4];        Visible5 := MatrixVisibleState[5];        Visible6 := MatrixVisibleState[6];        Visible7 := MatrixVisibleState[7];        Visible8 := MatrixVisibleState[8];        Visible9 := MatrixVisibleState[9];        Visible10 := MatrixVisibleState[10];    end;    trigger OnAfterGetRecord()    begin        UpdateRowData();    end;    /// <summary>    /// Loads promoted result data and updates condition editability for the current test.    /// </summary>    local procedure UpdateRowData()    var        DummyMatrixArrayCaptionSet: array[10] of Text;        DummyMatrixVisibleState: array[10] of Boolean;    begin        IsAllowableValuesEditable := not (Rec."Test Value Type" in [Rec."Test Value Type"::"Value Type Table Lookup"]);        QltyResultConditionMgmt.GetPromotedResultsForTest(Rec, MatrixSourceRecordId, MatrixArrayConditionCellData, MatrixArrayConditionDescriptionCellData, DummyMatrixArrayCaptionSet, DummyMatrixVisibleState);        Editable1 := Visible1 and DummyMatrixVisibleState[1];        Editable2 := Visible2 and DummyMatrixVisibleState[2];        Editable3 := Visible3 and DummyMatrixVisibleState[3];        Editable4 := Visible4 and DummyMatrixVisibleState[4];        Editable5 := Visible5 and DummyMatrixVisibleState[5];        Editable6 := Visible6 and DummyMatrixVisibleState[6];        Editable7 := Visible7 and DummyMatrixVisibleState[7];        Editable8 := Visible8 and DummyMatrixVisibleState[8];        Editable9 := Visible9 and DummyMatrixVisibleState[9];        Editable10 := Visible10 and DummyMatrixVisibleState[10];    end;    /// <summary>    /// Persists a promoted result condition from the lookup matrix.    /// </summary>    /// <param name="MatrixField">The one-based promoted result matrix index to update.</param>    local procedure UpdateMatrixDataCondition(MatrixField: Integer)    var        QltyIResultConditConf: Record "Qlty. I. Result Condit. Conf.";    begin        QltyIResultConditConf.Get(MatrixSourceRecordId[MatrixField]);        QltyIResultConditConf.Validate(Condition, MatrixArrayConditionCellData[MatrixField]);        QltyIResultConditConf.Modify(true);        CurrPage.Update(false);    end;    /// <summary>    /// Persists a promoted result condition description from the lookup matrix.    /// </summary>    /// <param name="MatrixField">The one-based promoted result matrix index to update.</param>    local procedure UpdateMatrixDataConditionDescription(MatrixField: Integer)    var        QltyIResultConditConf: Record "Qlty. I. Result Condit. Conf.";    begin        QltyIResultConditConf.Get(MatrixSourceRecordId[MatrixField]);        QltyIResultConditConf.Validate("Condition Description", MatrixArrayConditionDescriptionCellData[MatrixField]);        QltyIResultConditConf.Modify(true);        CurrPage.Update(false);    end;}