I want to create small job that list all worker name, position, report to position, and report to position worker name
static void GetPosOFEmployees(Args _args) { HcmWorker hcmWorker; HcmPositionWorkerAssignment workerAssignment; HcmPosition hcmPosition; HcmPositionDetail hcmPositionDetail; while select recid, person from hcmWorker join worker, position from workerAssignment where workerAssignment.Worker == hcmWorker.RecId join recid from hcmPosition where hcmPosition.RecId == workerAssignment.Position join position, description from hcmPositionDetail where hcmPositionDetail.Position == hcmPosition.RecId { info(strFmt("%1's position is %2 ",hcmWorker.name(), hcmPositionDetail.Description)); } }