Monday, August 28, 2017

Get Report to Position

HcmPositionRecId                        SelfPosition;
HcmPositionHierarchy                    PositionHierarchy;
uctdatetime utcDT = dtatimeutlill::;
SelfPosition = HcmPositionWorkerAssignment::find(HcmWorkerPrimaryPosition::findByWorker(HcmWorker::findByPerson("current person").RecId).PositionAssignment).Position;
    select validTimeState(utcDT) PositionHierarchy
    where PositionHierarchy.Position  == SelfPosition  && PositionHierarchy.PositionHierarchyType != 0;
    report to postion = HcmWorker::find(HcmWorkerPrimaryPosition::findByPositionAssignment(HcmPositionWorkerAssignment::findByPosition(PositionHierarchy.ParentPosition).RecId).Worker).Person;

No comments:

Post a Comment

Disabling the flight in D365FO (CHD - Tier 1)

 INSERT INTO dbo.SYSFLIGHTING(FLIGHTNAME, ENABLED)  VALUES ('<FlightObjectName>_KillSwitch', 1)  or  INSERT INTO dbo.SYSFLIGHT...