首页 > 其他 > 详细

EAS工作流审批记录提取

时间:2021-04-29 10:11:55      阅读:22      评论:0      收藏:0      [点我收藏+]

 

		sql.append(" select t3.factdefname_l2,t2.fname_l2 person,t.fispass,t.fopinion_l2,t.fcreatetime ");
		sql.append(" from T_BAS_MultiApprove t  ");
		sql.append(" inner join t_pm_user t2 on t2.fid=t.fcreatorid ");
		sql.append(" left join T_WFR_AssignDetail t3 on t3.FASSIGNID=t.FASSIGNMENTID ");
		sql.append(" where t.fbillId = ‘").append(pk.toString()).append("‘ AND fstatus = 1 ");
		sql.append(" order by t.fCREATETIME desc");

  

select t3.factdefname_l2,t2.fname_l2 person,t.fispass,t.fopinion_l2,t.fcreatetime
		from T_BAS_MultiApprove t 
		inner join t_pm_user t2 on t2.fid=t.fcreatorid
		left join T_WFR_AssignDetail t3 on t3.FASSIGNID=t.FASSIGNMENTID
		where t.fbillId = ‘YZoAAABDd3SarJDl‘ AND fstatus = 1
		order by t.fCREATETIME desc

  

EAS工作流审批记录提取

原文:https://www.cnblogs.com/duomi/p/14716290.html

(0)
(0)
   
举报
评论 一句话评论(0
关于我们 - 联系我们 - 留言反馈 - 联系我们:wmxa8@hotmail.com
© 2014 bubuko.com 版权所有
打开技术之扣,分享程序人生!