How to get this update date(number 2), from status "Previous value : Scheduled" and updated "Value : Released" < this value is only one on databaselog
while select inventDim
join prodTab
where prodTab.InventDimId == inventDim.inventDimId
&& prodTab.ProdStatus == ProdStatus::Released >> i think this should be changed, but i dont know the solution
join sysLog
where sysLog.LogRecId == inventDim.RecId
&& sysLog.createdDateTime >= fromDate
&& sysLog.createdDateTime <= toDate
{
Tmp.clear();
Tmp.inventBatchId = inventDim.inventBatchId;
Tmp.ValidFrom = sysLog.createdDateTime;
Tmp.insert();
}
Please help.
Thanks in advance.
*This post is locked for comments