retrieve worker line manger ( report to position worker name ) using x++

(0) Share

Report

Posted on by Community Member

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));
   }


}

*This post is locked for comments

I have the same question (0)

All responses (3)

Answers (0)

Rohin 4,624 on at

Like (0)

Report

RE: retrieve worker line manger ( report to position worker name ) using x++

Sorry, but you have not mention what problem you are getting with this? any specific error or not getting expected result?

please provide more details

Was this reply helpful? Yes No
Suggested answer

Rohin 4,624 on at

Like (1)

Report
RE: retrieve worker line manger ( report to position worker name ) using x++

Well, I have tried your job in my environment and realized that you are not getting report to position and report to position worker name what you are expecting .

If i am right here, I modified you code to get report to position name , please see below code:

static void GetPosOFEmployees(Args _args) { HcmWorker hcmWorker; HcmPositionWorkerAssignment workerAssignment; HcmPosition hcmPosition; HcmPositionDetail hcmPositionDetail; HcmPositionHierarchy hcmPositionHierarchy; // declare this table to get report to position 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 hcmPositionHierarchy where hcmPositionHierarchy.Position == hcmPosition.RecId join position, description from hcmPositionDetail where hcmPositionDetail.Position == hcmPosition.RecId { info(strFmt("%1's position is %2 and report to position :%3 ",hcmWorker.name(), hcmPositionDetail.Description,hcmPosition::find(hcmPositionHierarchy.ParentPosition).description())); } }

similarly , you can get report to position worker name. please let me know if it helps you

Was this reply helpful? Yes No
Muhammad Zahid 480 on at

Like (0)

Report

RE: retrieve worker line manger ( report to position worker name ) using x++

Hi I have the similar scenario I am trying to show the position id , worker name and positionreporttoid and workerreportingtoname using the data entity D365 for operations on which change tracking is enable.

I am able to get the reportstopositionid through hcmpositionhierarchy and than through hcmposition table but when I try join it with hcmpositionworkerassingment and than hcmworker to get the worker name of position reports to. I am getting multiple records of child records of that position if I modified the reports toposition data at any stage.

Can anyone guide me how can i get the reports to position name in my data entity with out getting the multiple records?? can we use display methods or anything else?

below is the image of my data entity.

Was this reply helpful? Yes No