Showing posts with label Workflow Instance Number Based on Journal Number in Ax 2009. Show all posts
Showing posts with label Workflow Instance Number Based on Journal Number in Ax 2009. Show all posts

Thursday, 3 March 2016

How to Get Workflow Instance Number Based on Journal Number in Ax 2009

static void JournalNumBase_InstanceNum(Args _args)
{
    ledgerjournaltable          ledgerjournaltable;
    workflowtrackingtable       workflowtrackingtable;
    workflowtrackingstatustable workflowtrackingstatustable;
    Recid           recid;
    //CorrelationId   CorrelationId;
    guid            CorrelationId;

    select  Recid from ledgerjournaltable where ledgerjournaltable.JournalNum=="JN-000247" ;
    recid = ledgerjournaltable.RecId;

    select  workflowtrackingtable where workflowtrackingtable.ContextRecId == recid;
    CorrelationId = workflowtrackingtable.CorrelationId;

    select  workflowtrackingstatustable where workflowtrackingstatustable.CorrelationId ==CorrelationId;

    info(strfmt("Instance id %1 ",workflowtrackingstatustable.InstanceNumber));


}