Tuesday, 13 September 2016

Code for Work flow submitted date

select  workflowtrackingstatustable
           join workflowtrackingtable
               where workflowtrackingstatustable .ContextRecId == ITLPayReimbursementApplication.RecId
                   && workflowtrackingtable.TrackingContext == workflowtrackingcontext::Workflow
                   && workflowtrackingtable.TrackingType == workflowtrackingtype::Submission
                   && workflowtrackingtable.WorkflowTrackingStatusTable == workflowtrackingstatustable.recid
           join WorkflowTable
                   where
                   WorkflowTable.DocumentTableName == "ITLPayReimbursementApplication"
                   && workflowtrackingstatustable.ConfigurationNumber == WorkflowTable.SequenceNumber;
           {

               ITLPayAppChildTMP.WorkFlowSubmissionDate = DateTimeUtil::date(workflowTrackingTable.createdDateTime);
           }

No comments:

Post a Comment

POSTMAN D365

  Postman is useful to test the behavior of different OData class from/to D365FO. In this post we will see the steps to setup Postman with D...