Hand-Aurora-工作流相关操作
查看工作流是否有重复提交
select wm_concat(t.instance_id), wm_concat(t.document_info) from zj_wfl_workflow_instance_v t
where t.creation_date between to_date('2017-1-1','yyyy-MM-dd') and to_date('2018-1-31','yyyy-MM-dd')
and t.workflow_code <> 'CS_NOTICE'
group by t.creation_date , t.workflow_id
having count(1) > 1;
批量通过用户通知
declare
p_result varchar2(100);
p_user_id number := 2533; -- 用户ID
begin
for
共有 0 条评论