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