Table 7159 Analysis Selected Dimension
src/Layers/W1/BaseApp/Inventory/Analysis/AnalysisSelectedDimension.Table.al89 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.Security.AccessControl;table 7159 "Analysis Selected Dimension"{ Caption = 'Analysis Selected Dimension'; DataClassification = CustomerContent; fields { field(1; "User ID"; Code[50]) { Caption = 'User ID'; DataClassification = EndUserIdentifiableInformation; TableRelation = User."User Name"; } field(2; "Object Type"; Integer) { Caption = 'Object Type'; } field(3; "Object ID"; Integer) { Caption = 'Object ID'; } field(4; "Dimension Code"; Text[30]) { Caption = 'Dimension Code'; } field(5; "New Dimension Value Code"; Code[20]) { Caption = 'New Dimension Value Code'; } field(6; "Dimension Value Filter"; Code[250]) { Caption = 'Dimension Value Filter'; } field(7; Level; Option) { Caption = 'Level'; OptionCaption = ' ,Level 1,Level 2,Level 3'; OptionMembers = " ","Level 1","Level 2","Level 3"; } field(8; "Analysis View Code"; Code[10]) { Caption = 'Analysis View Code'; TableRelation = "Item Analysis View".Code where("Analysis Area" = field("Analysis Area")); } field(9; "Analysis Area"; Enum "Analysis Area Type") { Caption = 'Analysis Area'; } } keys { key(Key1; "User ID", "Object Type", "Object ID", "Analysis Area", "Analysis View Code", "Dimension Code") { Clustered = true; } key(Key2; "User ID", "Object Type", "Object ID", "Analysis Area", "Analysis View Code", Level, "Dimension Code") { } } fieldgroups { } procedure GetSelectedDim(UserID2: Code[50]; ObjectType: Integer; ObjectID: Integer; AnalysisArea: Integer; AnalysisViewCode: Code[10]; var TempAnalysisSelectedDim: Record "Analysis Selected Dimension" temporary) begin SetRange("User ID", UserID2); SetRange("Object Type", ObjectType); SetRange("Object ID", ObjectID); SetRange("Analysis Area", AnalysisArea); SetRange("Analysis View Code", AnalysisViewCode); if Find('-') then repeat TempAnalysisSelectedDim := Rec; TempAnalysisSelectedDim.Insert(); until Next() = 0; end;}