|
楼主 |
发表于 2020-1-19 18:16:16
|
显示全部楼层
var taskid = this.getContext().getTask();
filter = "(SA_Task.sFlowID in (select x.sFlowID from SA_Task x where x = '"+taskid+"'))";
没有获取到,获取到的流程ID为空,系统内置的流程记录就可以查询到
SELECT SA_Task.* FROM SA_Task SA_Task WHERE (( (SA_Task.sWithdraw is null) OR (SA_Task.sWithdraw = 0) ) AND ( ( (SA_Task.sKindID = 'tkTask') AND (SA_Task.sExecutorPersonID is not null) AND ( SA_Task.sStatusID in ('tesPaused', 'tesFinished', 'tesReturned', 'tesAborted', 'tesTransmited', 'tesWaited') ) ) OR ( (SA_Task.sKindID = 'tkExecutor') AND ( SA_Task.sStatusID in ('tesPaused', 'tesFinished', 'tesReturned', 'tesAborted', 'tesTransmited') ) ) )) AND (((SA_Task.sFlowID in (select x.sFlowID from SA_Task x where x = '')))) ORDER BY SA_Task.sActualFinishTime asc LIMIT 0, 20
|
|