说明:一条流程可能在多个用户的账户中有待办
以用户为维度,可根据用户查出本人所有待办流程
所有流程的待办view_alltodo
select distinct row_number() OVER (ORDER BY c.requestid) AS id,--根据请求ID排序的序号生成
ID requestid ,--流程
ID userid,--用户ID
workflowid --流程ID
from workflow_currentoperator c --流程当前操作人表
where ((c.isremark = '0' and
(c.takisremark is null or c.takisremark = 0))
or
c.isremark in ('1', '5', '8', '9', '7')) and
c.islasttimes = 1