Table 149002 BCPT Log Entry

Performance Toolkit, System.Tooling

src/Tools/Performance Toolkit/App/src/BCPTLogEntry.Table.al158 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 System.Tooling;using System.Reflection;table 149002 "BCPT Log Entry"{    DataClassification = SystemMetadata;    DrillDownPageId = "BCPT Log Entries";    Extensible = false;    Access = Internal;    ReplicateData = false;    fields    {        field(1; "Entry No."; Integer)        {            Caption = 'Entry No.';            AutoIncrement = true;        }        field(2; "BCPT Code"; Code[10])        {            Caption = 'BCPT Code';            NotBlank = true;            TableRelation = "BCPT Header";        }        field(3; "BCPT Line No."; Integer)        {            Caption = 'Line No.';        }        field(4; "Start Time"; DateTime)        {            Caption = 'Start Time';        }        field(5; "End Time"; DateTime)        {            Caption = 'End Time';        }        field(6; "Message"; text[250])        {            Caption = 'Message';        }        field(7; "Codeunit ID"; Integer)        {            Caption = 'Codeunit ID';        }        field(8; "Codeunit Name"; Text[250])        {            Caption = 'Codeunit Name';            FieldClass = FlowField;            CalcFormula = lookup(AllObjWithCaption."Object Caption" where("Object Type" = const(Codeunit), "Object ID" = field("Codeunit ID")));        }        field(9; "Duration (ms)"; integer)        {            Caption = 'DurationInMs (ms)';        }        field(10; "Status"; Option)        {            Caption = 'Status';            OptionMembers = Success,Error;        }        field(11; Operation; Text[100])        {            Caption = 'Operation';        }        field(12; "No. of SQL Statements"; Integer)        {            Caption = 'No. of SQL Statements';        }        field(13; Version; Integer)        {            DataClassification = SystemMetadata;            Caption = 'Version';        }        field(14; "Session No."; Integer)        {            DataClassification = SystemMetadata;            Caption = 'Session No.';        }        field(15; Tag; Text[20])        {            DataClassification = CustomerContent;            Caption = 'Tag';        }        field(16; "Error Call Stack"; Text[2048])        {            DataClassification = CustomerContent;            Caption = 'Error Call Stack';        }        field(17; "Test Company Name"; Text[30])        {            DataClassification = CustomerContent;            Caption = 'Test Company Name';        }        field(18; RunID; Guid)        {            DataClassification = SystemMetadata;            Caption = 'RunID';        }        field(20; "Orig. Operation"; Text[100])        {            Caption = 'Orig. Operation';        }        /// <summary>        /// Contains the original status of the test if any event subscribers modifies the status of the test        /// </summary>        field(21; "Orig. Status"; Option)        {            Caption = 'Orig. Status';            OptionMembers = Success,Error;        }        /// <summary>        /// Contains the original message of the test if any event subscribers modifies the message of the test        /// </summary>        field(22; "Orig. Message"; Text[250])        {            Caption = 'Orig. Message';        }        /// <summary>        /// Is true if any event subscribers has modified the log entry        /// </summary>        field(23; "Log was Modified"; Boolean)        {            Caption = 'Log was Modified';        }    }    keys    {        key(Key1; "Entry No.")        {            Clustered = true;        }        key(Key2; "BCPT Code", Version, "BCPT Line No.", Operation, "Duration (ms)", "No. of SQL Statements")        {            // Instead of a SIFT index. This will make both inserts and calculations faster - and non-blocking        }        key(Key3; "Duration (ms)")        {            SumIndexFields = "Duration (ms)";        }    }    trigger OnInsert()    begin        if "End Time" = 0DT then            "End Time" := CurrentDateTime;        if "Start Time" = 0DT then            "Start Time" := "End Time" - "Duration (ms)";        if "Duration (ms)" = 0 then            "Duration (ms)" := "End Time" - "Start Time";        "Session No." := SessionId();    end;}