EAS工作流审批记录提取

 

StringBuilder sql = new StringBuilder();
sql.append(" /*dialect*/select to_char(t.fcreatetime,'YYYY-MM-DD HH24:MI:SS'),t3.factdefname_l2,t2.fname_l2 person,t.t.FHandlerContent,t.fopinion_l2 ");
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(billId).append("' AND fstatus = 1 ");
sql.append(" order by t.fCREATETIME asc");

　　

select to_char(t.fcreatetime,'YYYY-MM-DD HH24:MI:SS'),t3.factdefname_l2,t2.fname_l2 person,t.t.FHandlerContent,t.fopinion_l2
		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 asc