泛微工作流相关表

Workflow

workflow当前状态　　workflow_requestbase  requestid

记录workflow的seq号码   workflow_codeSeqRecord

workflow的公共选择框 workflow_SelectItem

--查询执行中尚未审批的流程和审批人

select 
hr.lastname  approver
,wn.nodename 
,wb.workflowname
--,wc.isremark
,wr.requestname 
,hr.email
,wr.lastoperatedate
,DATEDIFF(day,wr.lastoperatedate,getdate()) delayday
--,wr.* 
from 
workflow_currentoperator wc
join HrmResource hr on wc.userid = hr.id
join workflow_nodebase wn on wc.nodeid = wn.id
join workflow_base wb on wc.workflowid = wb.id
join workflow_requestbase wr on wc.requestid = wr.requestid
where 
    wn.isstart = 0  --非开始
and  wn.isend = 0   --非归档
and wc.isremark not in('2','8','4','1')  --2提交；8抄送;4-抄送不提交