Table 7158 Analysis Dim. Selection Buffer
src/Layers/W1/BaseApp/Inventory/Analysis/AnalysisDimSelectionBuffer.Table.al224 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 Microsoft.Finance.Dimension;using Microsoft.Inventory.Item;using Microsoft.Inventory.Location;table 7158 "Analysis Dim. Selection Buffer"{ Caption = 'Analysis Dim. Selection Buffer'; ReplicateData = false; DataClassification = CustomerContent; fields { field(1; "Code"; Text[30]) { Caption = 'Code'; ToolTip = 'Specifies a code for the selection.'; DataClassification = SystemMetadata; } field(2; Description; Text[30]) { Caption = 'Description'; ToolTip = 'Specifies a description of the selection.'; DataClassification = SystemMetadata; } field(3; Selected; Boolean) { Caption = 'Selected'; DataClassification = SystemMetadata; trigger OnValidate() begin "New Dimension Value Code" := ''; "Dimension Value Filter" := ''; Level := Level::" "; end; } field(4; "New Dimension Value Code"; Code[20]) { Caption = 'New Dimension Value Code'; DataClassification = SystemMetadata; TableRelation = if (Code = const('Item')) Item."No." else if (Code = const('Location')) Location.Code else "Dimension Value".Code where("Dimension Code" = field(Code), Blocked = const(false)); trigger OnValidate() begin Selected := true; end; } field(5; "Dimension Value Filter"; Code[250]) { Caption = 'Dimension Value Filter'; ToolTip = 'Specifies the dimension value that the analysis view is based on.'; DataClassification = SystemMetadata; TableRelation = if (Code = const('Item')) Item."No." else if (Code = const('Location')) Location.Code else "Dimension Value".Code where("Dimension Code" = field(Code)); ValidateTableRelation = false; trigger OnValidate() begin Selected := (Level <> Level::" ") or ("Dimension Value Filter" <> ''); end; } field(6; Level; Option) { Caption = 'Level'; ToolTip = 'Specifies the level for the selected dimension for analysis.'; DataClassification = SystemMetadata; OptionCaption = ' ,Level 1,Level 2,Level 3'; OptionMembers = " ","Level 1","Level 2","Level 3"; trigger OnValidate() begin Selected := (Level <> Level::" ") or ("Dimension Value Filter" <> ''); end; } } keys { key(Key1; "Code") { Clustered = true; } key(Key2; Level, "Code") { } } fieldgroups { } var AnalysisSelectedDim: Record "Analysis Selected Dimension";#pragma warning disable AA0074#pragma warning disable AA0470 Text000: Label 'Another user has modified the selected dimensions for the %1 field after you retrieved it from the database.\'; Text002: Label 'Enter your changes again in the Dimension Selection window by clicking the AssistButton in the %1 field. ';#pragma warning restore AA0470#pragma warning restore AA0074 procedure CompareDimText(ObjectType: Integer; ObjectID: Integer; AnalysisArea: Integer; AnalysisViewCode: Code[10]; SelectedDimText: Text[250]; DimTextFieldName: Text[100]) var AnalysisSelectedDim2: Record "Analysis Selected Dimension"; SelectedDimTextFromDb: Text[250]; begin SelectedDimTextFromDb := ''; AnalysisSelectedDim2.SetCurrentKey( "User ID", "Object Type", "Object ID", "Analysis Area", "Analysis View Code", Level, "Dimension Code"); AnalysisSelectedDim2.SetRange("User ID", UserId); AnalysisSelectedDim2.SetRange("Object Type", ObjectType); AnalysisSelectedDim2.SetRange("Object ID", ObjectID); AnalysisSelectedDim2.SetRange("Analysis Area", AnalysisArea); AnalysisSelectedDim2.SetRange("Analysis View Code", AnalysisViewCode); if AnalysisSelectedDim2.Find('-') then repeat AddDimCodeToText(AnalysisSelectedDim2."Dimension Code", SelectedDimTextFromDb); until AnalysisSelectedDim2.Next() = 0; if SelectedDimTextFromDb <> SelectedDimText then Error( Text000 + Text002, DimTextFieldName); end; local procedure AddDimCodeToText(DimCode: Code[20]; var Text: Text[250]) begin if Text = '' then Text := DimCode else if (StrLen(Text) + StrLen(DimCode)) <= (MaxStrLen(Text) - 4) then Text := StrSubstNo('%1; %2', Text, DimCode) else Text := StrSubstNo('%1;...', Text) end; procedure SetDimSelection(ObjectType: Integer; ObjectID: Integer; AnalysisArea: Integer; AnalysisViewCode: Code[10]; var SelectedDimText: Text[250]; var AnalysisDimSelBuf: Record "Analysis Dim. Selection Buffer") begin AnalysisSelectedDim.SetRange("User ID", UserId); AnalysisSelectedDim.SetRange("Object Type", ObjectType); AnalysisSelectedDim.SetRange("Object ID", ObjectID); AnalysisSelectedDim.SetRange("Analysis Area", AnalysisArea); AnalysisSelectedDim.SetRange("Analysis View Code", AnalysisViewCode); AnalysisSelectedDim.DeleteAll(); SelectedDimText := ''; AnalysisDimSelBuf.SetCurrentKey(Level, Code); AnalysisDimSelBuf.SetRange(Selected, true); if AnalysisDimSelBuf.Find('-') then repeat AnalysisSelectedDim."User ID" := CopyStr(UserId(), 1, MaxStrLen(AnalysisSelectedDim."User ID")); AnalysisSelectedDim."Object Type" := ObjectType; AnalysisSelectedDim."Object ID" := ObjectID; AnalysisSelectedDim."Analysis Area" := "Analysis Area Type".FromInteger(AnalysisArea); AnalysisSelectedDim."Analysis View Code" := AnalysisViewCode; AnalysisSelectedDim."Dimension Code" := AnalysisDimSelBuf.Code; AnalysisSelectedDim."New Dimension Value Code" := AnalysisDimSelBuf."New Dimension Value Code"; AnalysisSelectedDim."Dimension Value Filter" := AnalysisDimSelBuf."Dimension Value Filter"; AnalysisSelectedDim.Level := AnalysisDimSelBuf.Level; AnalysisSelectedDim.Insert(); AddDimCodeToText(AnalysisSelectedDim."Dimension Code", SelectedDimText); until AnalysisDimSelBuf.Next() = 0; end; procedure SetDimSelectionLevel(ObjectType: Integer; ObjectID: Integer; AnalysisArea: Integer; AnalysisViewCode: Code[10]; var SelectedDimText: Text[250]) var Item: Record Item; Location: Record Location; ItemAnalysisView: Record "Item Analysis View"; Dim: Record Dimension; TempAnalysisDimSelBuf: Record "Analysis Dim. Selection Buffer" temporary; AnalysisDimSelectionLevel: Page "Analysis Dim. Selection-Level"; begin Clear(AnalysisDimSelectionLevel); if ItemAnalysisView.Get(AnalysisArea, AnalysisViewCode) then begin if Dim.Get(ItemAnalysisView."Dimension 1 Code") then AnalysisDimSelectionLevel.InsertDimSelBuf( AnalysisSelectedDim.Get(UserId, ObjectType, ObjectID, AnalysisArea, AnalysisViewCode, Dim.Code), Dim.Code, Dim.GetMLName(GlobalLanguage), AnalysisSelectedDim."Dimension Value Filter", AnalysisSelectedDim.Level); if Dim.Get(ItemAnalysisView."Dimension 2 Code") then AnalysisDimSelectionLevel.InsertDimSelBuf( AnalysisSelectedDim.Get(UserId, ObjectType, ObjectID, AnalysisArea, AnalysisViewCode, Dim.Code), Dim.Code, Dim.GetMLName(GlobalLanguage), AnalysisSelectedDim."Dimension Value Filter", AnalysisSelectedDim.Level); if Dim.Get(ItemAnalysisView."Dimension 3 Code") then AnalysisDimSelectionLevel.InsertDimSelBuf( AnalysisSelectedDim.Get(UserId, ObjectType, ObjectID, AnalysisArea, AnalysisViewCode, Dim.Code), Dim.Code, Dim.GetMLName(GlobalLanguage), AnalysisSelectedDim."Dimension Value Filter", AnalysisSelectedDim.Level); AnalysisDimSelectionLevel.InsertDimSelBuf( AnalysisSelectedDim.Get(UserId, ObjectType, ObjectID, AnalysisArea, AnalysisViewCode, Item.TableCaption()), Item.TableCaption(), Item.TableCaption(), AnalysisSelectedDim."Dimension Value Filter", AnalysisSelectedDim.Level); AnalysisDimSelectionLevel.InsertDimSelBuf( AnalysisSelectedDim.Get(UserId, ObjectType, ObjectID, AnalysisArea, AnalysisViewCode, Location.TableCaption()), Location.TableCaption(), Location.TableCaption(), AnalysisSelectedDim."Dimension Value Filter", AnalysisSelectedDim.Level); end; AnalysisDimSelectionLevel.LookupMode := true; if AnalysisDimSelectionLevel.RunModal() = ACTION::LookupOK then begin AnalysisDimSelectionLevel.GetDimSelBuf(TempAnalysisDimSelBuf); SetDimSelection(ObjectType, ObjectID, AnalysisArea, AnalysisViewCode, SelectedDimText, TempAnalysisDimSelBuf); end; end;}