|
|
您好:流程历史中某个节点审批人的信息是存放在T_ACTORHIS表中的,您可以通过如下代码实现:
var opts=$TOOLS.createOptions();
var userProcess = getUserProcess();
var doc = getCurrentDocument();
var domainid = getDomainid();
var nodeName="流程审批"; //流程节点名称
var sql="select id,actorid as item_actorid,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+"')";
println(sql+"=====sql===");
var datas = queryBySQL(sql);
for (var it = datas.iterator(); it.hasNext();) {
var d = it.next();
var userid = d.getItemValueAsString("actorid");
var username = d.getItemValueAsString("name");
opts.add(username,userid);
}opts;
|
|