Query 1501 Workflow Instance

App
Base Application
Namespace
System.Automation
Versions
17-28

Versions171819202122232425262728

Source29

Source in 29

src/Layers/W1/BaseApp/System/Workflow/WorkflowInstance.Query.al94 lines, Copyright (c) Microsoft Corporation. MIT

namespace System.Automation;

query 1501 "Workflow Instance"
{
    Caption = 'Workflow Instance';
    OrderBy = ascending(Sequence_No);

    elements
    {
        dataitem(Workflow; Workflow)
        {
            column("Code"; "Code")
            {
            }
            column(Workflow_Description; Description)
            {
            }
            column(Enabled; Enabled)
            {
            }
            dataitem(Workflow_Step_Instance; "Workflow Step Instance")
            {
                DataItemLink = "Workflow Code" = Workflow.Code;
                SqlJoinType = InnerJoin;
                column(Instance_ID; ID)
                {
                }
                column(Workflow_Code; "Workflow Code")
                {
                }
                column(Step_ID; "Workflow Step ID")
                {
                }
                column(Step_Description; Description)
                {
                }
                column(Entry_Point; "Entry Point")
                {
                }
                column(Record_ID; "Record ID")
                {
                }
                column(Created_Date_Time; "Created Date-Time")
                {
                }
                column(Created_By_User_ID; "Created By User ID")
                {
                }
                column(Last_Modified_Date_Time; "Last Modified Date-Time")
                {
                }
                column(Last_Modified_By_User_ID; "Last Modified By User ID")
                {
                }
                column(Status; Status)
                {
                }
                column(Previous_Workflow_Step_ID; "Previous Workflow Step ID")
                {
                }
                column(Next_Workflow_Step_ID; "Next Workflow Step ID")
                {
                }
                column(Type; Type)
                {
                }
                column(Function_Name; "Function Name")
                {
                }
                column(Argument; Argument)
                {
                }
                column(Original_Workflow_Code; "Original Workflow Code")
                {
                }
                column(Original_Workflow_Step_ID; "Original Workflow Step ID")
                {
                }
                column(Sequence_No; "Sequence No.")
                {
                }
                dataitem(Workflow_Event; "Workflow Event")
                {
                    DataItemLink = "Function Name" = Workflow_Step_Instance."Function Name";
                    column(Table_ID; "Table ID")
                    {
                    }
                }
            }
        }
    }
}