Tuesday, 22 January 2019

Worker line manager x++

static void WorkerLineManager(Args _args)
{
HcmPosition hcmPosition,hcmPositionLoc;
HcmPositionDetail positionDetail;
HcmPositionWorkerAssignment workerAssignment,workerAssignmentLoc;
HcmPositionHierarchy positionHierarchy, positionHierarchyLoc;
HcmWorker hcmWorker,hcmWorkerLoc;

select positionHierarchy
join hcmPosition
where hcmPosition.RecId == positionHierarchy.Position
join workerAssignment
where workerAssignment.Position == hcmPosition.RecId
join hcmWorker
where hcmWorker.RecId == workerAssignment.Worker
&& hcmWorker.PersonnelNumber == “891”;
{

select positionHierarchyLoc
join hcmPositionLoc
where hcmPositionLoc.RecId == positionHierarchy.ParentPosition
join workerAssignmentLoc
where workerAssignmentLoc.Position == hcmPositionLoc.RecId
join hcmWorkerLoc
where hcmWorkerLoc.RecId == workerAssignmentLoc.Worker;

info(strFmt(“%1–line manager %2”, hcmPositionLoc.PositionId,hcmWorkerLoc.PersonnelNumber));
}
}

No comments:

Post a Comment