Senin, 22 April 2019

Relasi antara Worfklow dan Table document

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;

Tidak ada komentar:

Posting Komentar

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...