Berikut Relasi antara Workflow dengan Table docment yang memakai workflow:
WorkflowTrackingStatusTable.ContextCompanyId <> [tabledocument].DataAreaId
WorkflowTrackingStatusTable.ContextRecId <> [tabledocument].RecId
WorkflowTrackingStatusTable.ContextTableId <> tabledocument].TableId
Sample :
Asumsi saya mempunyai table dengan nama RFPTable
WorkflowTrackingStatusTable wfstatustable;
WorkflowTrackingTable wftrackingtable;
Description descriptwf;
RFPTable rfpTable;
;
select * from rfpTable
where rfpTable.TransNum == _dfpnumber;
select * from wfstatustable
where wfstatustable.ContextCompanyId == rfpTable.dataAreaId
&& wfstatustable.ContextRecId == rfpTable.RecId
&& wfstatustable.ContextTableId == rfpTable.TableId
&& (wfstatustable.TrackingStatus == WorkflowTrackingStatus::Completed || wfstatustable.TrackingStatus == WorkflowTrackingStatus::Pending);
while select * from wftrackingtable
order by createdDateTime asc
where wftrackingtable.WorkflowTrackingStatusTable == wfstatustable.RecId
&& (wftrackingtable.TrackingType == WorkflowTrackingType::Submission || wftrackingtable.TrackingType == WorkflowTrackingType::Approval)
{
descriptwf += strFmt("%1 (%2).",wftrackingtable.User,wftrackingtable.TrackingType);
}
return descriptwf;
All Archives in this blog may be used for the Junior,Dummies or someone who just started for career at Dynamics Ax ... A Place Where U can Start ur Code - right here ...
Langganan:
Posting Komentar (Atom)
Cloud hosted environment di D365
Biasanya kita menginginkan sebuah environment yang sama dengan LIVE/PROD untuk mengtest sebuah proses. Maka kita bisa menggunakan fitur Clou...
-
When we work with entries data that contain sequence number sometime we need an improvement to create in another way, a Generate perhaps. ...
-
"Error while setting server report parameters. Error Message: The item ´/DynamicsAx/PurchPurchaseOrderreport.Report4´ cannot be found ...
-
Public Common lookupReference() { Common ret; ret = HcmWorker::PSM_LookupReffWorker_ByDept(this,strFmt("%1...
Tidak ada komentar:
Posting Komentar