所有流程的待处理人view_dclrforallflow

以流程为维度，查询出本流程的所有待处理人

思路分析：将所有流程待办中userid按照requestid合并起来

注意：Oracle关于列转行的写法和sqlserver不一样，需要单独根据规则来写

--Sqlserver实现

SELECT

       requestid,

       (STUFF ((SELECT ',' + CAST(userid AS  varchar)

                       FROM   view_alltodo

                       WHERE requestid =  c.requestid FOR XML PATH ( '' ) ),1,1,'' ) ) as dclr--流程的全部待处理人

FROM

       view_alltodo c

GROUP BY requestid;

--Oracle实现

select  requestid,

       LISTAGG(userid, ',') within group(order  by requestid) as dclr

  from view_alltodo

 --where requestid = 4225 –(where条件写在group by 前面)
 

UP  BY requestid;

group by requestid