泛微oa查询某人的所有待办流程

泛微oa查询某人的所有待办流程

select t1.requestid,t1.requestname,t2.* from workflow_requestbase t1,workflow_currentoperator t2  

where  (t1.deleted <> 1 or t1.deleted is null or t1.deleted='') 

and t1.requestid = t2.requestid 

and t2.userid in (用户id) and t2.usertype=0  --替换用户的id， 

and ((t2.isremark=0 and (t2.takisremark is null or t2.takisremark=0 )) or t2.isremark in('1','5','8','9','7'))  

and (t1.deleted=0 or t1.deleted is null) and t2.islasttimes=1 and   (isnull(t1.currentstatus,-1) = -1 or (isnull(t1.currentstatus,-1)=0 and t1.creater in (用户id)))   --替换用户的id，

and t1.workflowid in (select id from workflow_base where   (isvalid='1' or isvalid='3') )  --有效流程