泛微OA-岗位矩阵反查流程

select b.matrixid,b.displayname,n.groupname,nb.nodename,wb.workflowname from 	workflow_groupdetail_matrix a
left join matrixFieldInfo b on a.value_field=b.id and a.matrix=b.matrixid
	left join workflow_groupdetail c on a.groupdetailid=c.id
	left join workflow_nodegroup n on n.id=c.groupid
	left join workflow_nodebase nb on nb.id=n.nodeid
	left join workflow_flownode fn on fn.nodeid=nb.id
	left join workflow_base wb on wb.id=fn.workflowid
where  1=1 and a.matrix=4 and wb.id=isnull(wb.activeVersionID,wb.id)
and displayname='催收专员'