Hi All,
Environment : D365FO
I use display method in HcmPositionWorkerAssignment table on HcmPosition form
source and destination table is HcmPositionWorkerAssignment
New record only populate on the display method, is not show the old record while debugging its showing empty .
My code
[SysClientCacheDataMethodAttribute(true)] //This attribute will cache your display method.
public static display Name Ename(HcmPositionWorkerAssignment _this)
{
HcmPositionWorkerAssignment hcmPositionWorkerAssignmen,hcmPositionWorkerAssignmen1;
HcmWorker hcmworker;
utcdatetime minDateTime = DateTimeUtil::minValue() , maxDateTime = DateTimeUtil::maxValue();
Name name;
select firstonly ValidFrom,Position from hcmPositionWorkerAssignmen order by RecId desc
where hcmPositionWorkerAssignmen.Position ==_this.Position;
select firstonly validTimeState(minDateTime, maxDateTime) * from hcmPositionWorkerAssignmen1 order by RecId desc
where hcmPositionWorkerAssignmen1.ValidTo < hcmPositionWorkerAssignmen.ValidFrom && hcmPositionWorkerAssignmen1.Position == hcmPositionWorkerAssignmen.Position;
select hcmworker where hcmworker.RecId == hcmPositionWorkerAssignmen1.Worker;
return hcmworker.name();
}
