如何关联各表格:
SELECT t_WF_ActInst.FActivityId,
t_WF_ApprovalAssign.FResult, t_WF_ApprovalAssign.FDisposition,
t_WF_Receiver.FReceiverId, t_SEC_User.FName,
t_WF_ApprovalItem.FStatus, t_WF_ApprovalItem.FActionResult,
t_WF_ApprovalItem.FDisposition, t_WF_ApprovalItem.FCompletedTime
FROM t_WF_PiBiMap
INNER JOIN t_WF_ProcInst ON (t_WF_ProcInst.FProcInstId = t_WF_PiBiMap.FProcInstId)
INNER JOIN t_WF_ActInst on (t_WF_ActInst.FProcInstId = t_WF_ProcInst.FProcInstId)
INNER JOIN t_WF_Assign on (t_WF_Assign.FActInstId = t_WF_ActInst.FActInstId)
INNER JOIN t_WF_Receiver on (t_WF_Receiver.FAssignId = t_WF_Assign.FAssignId)
INNER JOIN t_SEC_User ON (t_SEC_User.FUserId = t_WF_Receiver.FReceiverId)
INNER JOIN t_WF_ApprovalAssign on (t_WF_Assign.FAssignId = t_WF_ApprovalAssign.FAssignId)
LEFT JOIN t_WF_ApprovalItem on (t_WF_ApprovalItem.FApprovalAssignId = t_WF_ApprovalAssign.FApprovalAssignId
AND t_WF_ApprovalItem.FReceiverId = t_WF_Receiver.FReceiverId)
WHERE t_WF_PiBiMap.FObjectTypeId = 'PUR_PurchaseOrder'
AND FKeyValue = '100000'
几个状态字段的枚举值说明
1. T_WF_PROCINST.FStatus :
0 = 准备;
1 = 完成;
2 = 挂起;
3 = 错误;
4 = 终止;
5 = 暂停;
2.T_WF_ACTINST.FSTATUS:
0 = 准备;
1 = 完成;
2 = 挂起;
3 = 舍弃;
4 = 失败;
3.T_WF_ASSIGN.FSTATUS
0 = 分配;
1 = 完成;
4.T_WF_APPROVALITEM.FSTATUS
0 = 待处理;
1 = 完成;
3 = 转发;
4 = 排队等待;
推荐阅读