1.工作流中审批信息查看脚本如下(脚本主要体现工作流中各表的关系):
select distinct bill.fnumber as 中标通知书编码,act.FActDefName_l2 as 节点名称,
approve.FOpinion_l2 as 审批意见,approve.FHandlerContent as 处理策略,
approve.FIsPass AS 审批处理,detail.FPersonuserName_l2 as 复核人,approve.FcreateTime as 审批时间
from t_wfr_actInst as act
inner join t_WFR_ProcinstRef as bizRef on bizRef.FProcInstID=act.FProcInstID
inner join T_WFR_ProcInst as pro on pro.FProcInstID=ACT.FProcInstID
inner join t_wfr_Assigndetail as detail on detail.FActdefID=act.FActdefID and detail.FProcInstID=act.FProcInstID
inner join T_ECC_InviteNotice bill on bill.fid=bizRef.FrefID
inner join T_BAS_MultiApprove as approve on approve.FASSIGNMENTID=detail.FAssignID
inner join T_BD_Person as person on person.fid=detail.FPersonEMPID
inner join T_ORG_PositionMember AS pmb ON person.FID = pmb.FPersonID and pmb.FisPrimary=1