select workflowtrackingstatustable
join workflowtrackingtable
where workflowtrackingstatustable .ContextRecId == ITLPayReimbursementApplication .RecId
&& workflowtrackingtable.Tracking Context == workflowtrackingcontext::Workf low
&& workflowtrackingtable.Tracking Type == workflowtrackingtype::Submissi on
&& workflowtrackingtable.Workflow TrackingStatusTable == workflowtrackingstatustable.re cid
join WorkflowTable
where
WorkflowTable.DocumentTableNa me == "ITLPayReimbursementApplicatio n"
&& workflowtrackingstatustable.Co nfigurationNumber == WorkflowTable.SequenceNumber;
{
ITLPayAppChildTMP.WorkFlowSub missionDate = DateTimeUtil::date(workflowTra ckingTable.createdDateTime);
}
No comments:
Post a Comment