泛微OA查询SQL-查询引用矩阵的流程

select 
g.name  as  矩阵名称,
f.workflowname as 流程名称,
f.version as 版本号,
d.nodename as 节点名称,
(case e.nodetype when '0' then '提交' when '1' then '审批' when '2' then '执行' when '3' then '归档'  end) as  paytype,  
a.groupname as 操作组名称,
t.orders
from workflow_groupdetail t
right join workflow_nodegroup a on a.id=t.groupid
left join workflow_groupdetail_matrix  b on b.groupdetailid=t.id
left join matrixfieldinfo c on c.id = b.value_field
left join workflow_nodebase d on d.id=a.nodeid
left join workflow_flownode e on e.nodeid = d.id
left join workflow_base f on f.id = e.workflowid
left join matrixinfo g on g.id = b.matrix
where 1=1
and f.isvalid= '1'
and c.displayname = '财务管理部分管院领导'
order by g.id,f.workflowname,f.version desc,d.nodename,t.orders