Table 771 Analysis Report Chart Line
src/Layers/W1/BaseApp/Inventory/Analysis/AnalysisReportChartLine.Table.al161 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.Inventory.Analysis;using System.Visualization;table 771 "Analysis Report Chart Line"{ Caption = 'Analysis Report Chart Line'; DataClassification = CustomerContent; fields { field(1; "User ID"; Text[132]) { Caption = 'User ID'; DataClassification = EndUserIdentifiableInformation; Editable = false; TableRelation = "Analysis Report Chart Setup"."User ID" where(Name = field(Name), "Analysis Area" = field("Analysis Area")); } field(2; Name; Text[30]) { Caption = 'Name'; Editable = false; TableRelation = "Analysis Report Chart Setup".Name where("User ID" = field("User ID"), "Analysis Area" = field("Analysis Area")); } field(3; "Analysis Line Line No."; Integer) { Caption = 'Analysis Line Line No.'; ToolTip = 'Specifies the number of the analysis report line that the specific chart is based on.'; Editable = false; TableRelation = "Analysis Line"."Line No." where("Analysis Area" = field("Analysis Area"), "Analysis Line Template Name" = field("Analysis Line Template Name")); } field(4; "Analysis Column Line No."; Integer) { Caption = 'Analysis Column Line No.'; ToolTip = 'Specifies the number of the analysis report column that the advanced chart is based on.'; Editable = false; TableRelation = "Analysis Column"."Line No." where("Analysis Area" = field("Analysis Area"), "Analysis Column Template" = field("Analysis Column Template Name")); } field(6; "Analysis Area"; Enum "Analysis Area Type") { Caption = 'Analysis Area'; Editable = false; TableRelation = "Analysis Report Chart Setup"."Analysis Area" where("User ID" = field("User ID"), Name = field(Name)); } field(7; "Analysis Line Template Name"; Code[10]) { Caption = 'Analysis Line Template Name'; ToolTip = 'Specifies the name. This field is intended only for internal use.'; Editable = false; TableRelation = "Analysis Report Chart Setup"."Analysis Line Template Name" where("User ID" = field("User ID"), "Analysis Area" = field("Analysis Area"), Name = field(Name)); } field(8; "Analysis Column Template Name"; Code[10]) { Caption = 'Analysis Column Template Name'; ToolTip = 'Specifies the name. This field is intended only for internal use.'; Editable = false; TableRelation = "Analysis Report Chart Setup"."Analysis Column Template Name" where("User ID" = field("User ID"), "Analysis Area" = field("Analysis Area"), Name = field(Name)); } field(10; "Original Measure Name"; Text[111]) { Caption = 'Original Measure Name'; ToolTip = 'Specifies the analysis report columns or lines that you select to insert in the Analysis Report Chart Setup window.'; Editable = false; } field(15; "Measure Name"; Text[111]) { Caption = 'Measure Name'; ToolTip = 'Specifies the analysis report columns or lines that the measures on the y-axis in the specific chart are based on.'; trigger OnValidate() begin TestField("Measure Name"); end; } field(20; "Measure Value"; Text[30]) { Caption = 'Measure Value'; Editable = false; } field(40; "Chart Type"; Option) { Caption = 'Chart Type'; ToolTip = 'Specifies how the analysis report values are represented graphically in the specific chart.'; OptionCaption = ' ,Line,StepLine,Column,StackedColumn'; OptionMembers = " ",Line,StepLine,Column,StackedColumn; trigger OnValidate() var AnalysisReportChartSetup: Record "Analysis Report Chart Setup"; AnalysisReportChartLine: Record "Analysis Report Chart Line"; BusinessChartBuffer: Record "Business Chart Buffer"; ActualNumMeasures: Integer; begin if ("Chart Type" <> "Chart Type"::" ") and IsMeasure() then begin AnalysisReportChartSetup.Get("User ID", "Analysis Area", Name); AnalysisReportChartSetup.SetLinkToMeasureLines(AnalysisReportChartLine); AnalysisReportChartLine.SetFilter("Chart Type", '<>%1', AnalysisReportChartLine."Chart Type"::" "); ActualNumMeasures := 0; if AnalysisReportChartLine.FindSet() then repeat if (AnalysisReportChartLine."Analysis Line Line No." <> "Analysis Line Line No.") or (AnalysisReportChartLine."Analysis Column Line No." <> "Analysis Column Line No.") then ActualNumMeasures += 1; until AnalysisReportChartLine.Next() = 0; if ActualNumMeasures >= BusinessChartBuffer.GetMaxNumberOfMeasures() then BusinessChartBuffer.RaiseErrorMaxNumberOfMeasuresExceeded(); end; end; } } keys { key(Key1; "User ID", "Analysis Area", Name, "Analysis Line Line No.", "Analysis Column Line No.") { Clustered = true; } } fieldgroups { } local procedure IsMeasure() Result: Boolean var AnalysisReportChartSetup: Record "Analysis Report Chart Setup"; begin AnalysisReportChartSetup.Get("User ID", "Analysis Area", Name); case AnalysisReportChartSetup."Base X-Axis on" of AnalysisReportChartSetup."Base X-Axis on"::Period: Result := true; AnalysisReportChartSetup."Base X-Axis on"::Line: if "Analysis Line Line No." = 0 then Result := true; AnalysisReportChartSetup."Base X-Axis on"::Column: if "Analysis Column Line No." = 0 then Result := true; end; end; procedure GetDefaultChartType(): Integer begin exit("Chart Type"::Column); end;}