控制用户可申请的未归档流程数

特定用户、特定流程,当前处于A节点的流程数:

select COUNT(1)
from workflow_requestbase 
WHERE workflowid='【流程id】'
AND currentnodeid='【A节点id】' 
AND creater='【流程创建人id】'

特定用户、特定流程,当前未归档的流程数:

select COUNT(1)
from workflow_requestbase 
WHERE workflowid='【流程id】'
AND currentnodeid!='【归档节点id】' 
AND creater='【流程创建人id】'
posted @ 2022-08-26 09:21  LUNA2333  阅读(48)  评论(0)    收藏  举报