控制用户可申请的未归档流程数
特定用户、特定流程,当前处于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】'

浙公网安备 33010602011771号