X++ Code Identify The Workflow Is Active (Or) Not In AX-2012 R3

static void RB_ActiveWorkflow(Args _args)
{
    WorkflowVersionTable        WorkflowVersionTable;
    WorkflowTable               WorkflowTable;
    #define.SalesCategory('SalesCategory')

    select firstonly DataArea,CategoryName,DefaultConfiguration from WorkflowTable
        where WorkflowTable.DataArea == curext()
        &&    WorkflowTable.CategoryName == #SalesCategory
        &&    WorkflowTable.DefaultConfiguration == NoYes::Yes
    join WorkflowTable, Enabled from WorkflowVersionTable
        where WorkflowVersionTable.WorkflowTable == WorkflowTable.RecId
        &&    WorkflowVersionTable.Enabled == NoYes::Yes;

    if (WorkflowTable)
    {
        info('Workflow Active in this company');
    }
}

No comments:

Post a Comment