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...
-
"Error while setting server report parameters. Error Message: The item ´/DynamicsAx/PurchPurchaseOrderreport.Report4´ cannot be found ...
-
When we work with entries data that contain sequence number sometime we need an improvement to create in another way, a Generate perhaps. ...
-
SrsReportViewer|AxReportViewer_RefreshComplete
Tidak ada komentar:
Posting Komentar