Table 1525 Workflow - Record Change
src/Layers/W1/BaseApp/System/Workflow/WorkflowRecordChange.Table.al161 lines, Copyright (c) Microsoft Corporation. MIT
namespace System.Automation;using System.Reflection;table 1525 "Workflow - Record Change"{ Caption = 'Workflow - Record Change'; ReplicateData = true; DataClassification = CustomerContent; fields { field(1; "Entry No."; Integer) { AutoIncrement = true; Caption = 'Entry No.'; } field(2; "Table No."; Integer) { Caption = 'Table No.'; } field(3; "Field No."; Integer) { Caption = 'Field No.'; } field(4; "Old Value"; Text[250]) { Caption = 'Old Value'; } field(5; "New Value"; Text[250]) { Caption = 'New Value'; } field(6; "Record ID"; RecordID) { Caption = 'Record ID'; DataClassification = CustomerContent; } field(7; "Workflow Step Instance ID"; Guid) { Caption = 'Workflow Step Instance ID'; } field(8; "Field Caption"; Text[250]) { CalcFormula = lookup(Field."Field Caption" where(TableNo = field("Table No."), "No." = field("Field No."))); Caption = 'Field Caption'; FieldClass = FlowField; } field(9; Inactive; Boolean) { Caption = 'Inactive'; } } keys { key(Key1; "Entry No.") { Clustered = true; } key(Key2; "Workflow Step Instance ID", "Record ID") { } } fieldgroups { } procedure GetFormattedNewValue(FormatOptionString: Boolean): Text begin exit(FormatValue("New Value", FormatOptionString)); end; procedure GetFormattedOldValue(FormatOptionString: Boolean): Text begin exit(FormatValue("Old Value", FormatOptionString)); end; procedure FormatValue(Value: Text; FormatOptionString: Boolean): Text var DateFormula: DateFormula; RecRef: RecordRef; FieldRef: FieldRef; Bool: Boolean; Date: Date; DateTime: DateTime; Decimal: Decimal; Duration: Duration; "Integer": Integer; Option: Option; Time: Time; BigInteger: BigInteger; begin RecRef.Get("Record ID"); FieldRef := RecRef.Field("Field No."); case FieldRef.Type of FieldType::Date: begin Evaluate(Date, Value, 9); exit(Format(Date)); end; FieldType::Boolean: begin Evaluate(Bool, Value, 9); exit(Format(Bool)); end; FieldType::DateFormula: begin Evaluate(DateFormula, Value, 9); exit(Format(DateFormula)); end; FieldType::DateTime: begin Evaluate(DateTime, Value, 9); exit(Format(DateTime)); end; FieldType::BigInteger: begin Evaluate(BigInteger, Value, 9); exit(Format(BigInteger)); end; FieldType::Time: begin Evaluate(Time, Value, 9); exit(Format(Time)); end; FieldType::Option: begin Evaluate(Option, Value, 9); if FormatOptionString then begin FieldRef.Value := Option; exit(Format(FieldRef.Value)); end; exit(Format(Option)); end; FieldType::Integer: begin Evaluate(Integer, Value, 9); exit(Format(Integer)); end; FieldType::Duration: begin Evaluate(Duration, Value, 9); exit(Format(Duration)); end; FieldType::Decimal: begin Evaluate(Decimal, Value, 9); exit(Format(Decimal)); end; FieldType::Code, FieldType::Text: exit(Format(Value)); else exit(Format(Value)); end; end;}