解决办法,取数据库中按日期排列的最后一条数据。
//取流程节点的审批人
var opts="";
var userProcess = getUserProcess();
var doc = getCurrentDocument();
var domainid = getDomainid();
var nodeName="工艺审核"; //流程节点名称
println(nodeName+"======nodeName=====");
var sql="select * from(select id,actorid as item_actorid,processtime as item_processtime,name as item_name,'" + domainid + "' as domainid from T_ACTORHIS where NODEHIS_ID in (select ID from t_relationhis where docid='"+doc.getId()+"' and startnodename='"+nodeName+"' ) order by processtime desc)where rownum=1";
//var sql="select ID from t_relationhis where docid='"+doc.getId()+"' and startnodename='"+nodeName+"'";
var datas = queryBySQL(sql);
println(datas+"======datas=======");
for (var it = datas.iterator(); it.hasNext();) {
var d = it.next();
println(d+"==ddddd====");
if(d!=null){
opts=d.getItemValueAsString("name");
println(opts+"=====opts====");}
}opts; |