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)
Erorr CS1963 - An expression tree may not contain a dynamic operation.
Kali ini saya mendapatkan erorr dengan code CS1963, padahal sebelumnya saya sudah mendefinisikan 'var item in Model' di @foreach(var...
-
My code here is to copy Purchase Agreement line from reference Purchase Agreement to new Purchase Agreement. static void PSMCopydirecttoag...
-
If you want to try custom your notification, AX Standard can bring the user to the form where the information exist but when the form was...
-
"Error while setting server report parameters. Error Message: The item ´/DynamicsAx/PurchPurchaseOrderreport.Report4´ cannot be found ...
Tidak ada komentar:
Posting Komentar