查询流程节点审批人或者审批岗位
SELECT L.FDISPLAYNAME 流程名称,T.FNUMBER 编码 , MO.FNAME 入口单据, T.审批结点与人员 , T.FDEFINITIONXML 源流程定义XML FROM (
SELECT CONVERT(VARCHAR(MAX), FDefinitionXML.query('
for $Loc in /ApprovalProcess/Activities/*,
$DisplayName in $Loc/DisplayName[1],
$name in $Loc//Receivers/*/Name
where $DisplayName!="" and local-name($Loc) ="FinalApprovalActivity" or local-name($Loc) = "ApprovalActivity"
return
concat($DisplayName,"|",$name,",")
')) as 审批结点与人员 ,*
FROM AIS20230822142558..T_WF_PROCDEF
) T JOIN AIS20230822142558..T_WF_PROCDEF_L L ON T.FPROCDEFID=L.FPROCDEFID
JOIN AIS20230822142558..T_META_OBJECTTYPE_L MO ON T.FOBJECTTYPEID=MO.FID
WHERE 审批结点与人员 <> '' and (审批结点与人员 like '%销售经理%' or 审批结点与人员 like '%张三%')
SELECT CONVERT(VARCHAR(MAX), FDefinitionXML.query('
for $Loc in /ApprovalProcess/Activities/*,
$DisplayName in $Loc/DisplayName[1],
$name in $Loc//Receivers/*/Name
where $DisplayName!="" and local-name($Loc) ="FinalApprovalActivity" or local-name($Loc) = "ApprovalActivity"
return
concat($DisplayName,"|",$name,",")
')) as 审批结点与人员 ,*
FROM AIS20230822142558..T_WF_PROCDEF
) T JOIN AIS20230822142558..T_WF_PROCDEF_L L ON T.FPROCDEFID=L.FPROCDEFID
JOIN AIS20230822142558..T_META_OBJECTTYPE_L MO ON T.FOBJECTTYPEID=MO.FID
WHERE 审批结点与人员 <> '' and (审批结点与人员 like '%销售经理%' or 审批结点与人员 like '%张三%')
查询流程节点审批人或者审批岗位
SELECT L.FDISPLAYNAME 流程名称,T.FNUMBER 编码 , MO.FNAME 入口单据, T.审批结点与人员 , T.FDEFINITIONXML 源流程定义XML FR...
点击下载文档
本文2024-09-16 19:01:04发表“云星空知识”栏目。
本文链接:https://wenku.my7c.com/article/kingdee-k3cloud-25868.html
您需要登录后才可以发表评论, 登录登录 或者 注册
最新文档
热门文章