SQLServer:
查询某个流程所有请求的每个节点操作者的耗时(相当于流程状态页的耗时)
select requestid as 请求id,(select requestname from workflow_requestbase wr where wr.requestid = wc.requestid ) as 请求标题
,nodeid as 节点id,(select nodename from workflow_nodebase where id = nodeid ) as 节点名称
,userid as 操作者id,(select lastname from HrmResource where id = userid) as 操作者姓名
,(convert(float,convert(datetime,CASE WHEN operatedate <> ‘’ THEN convert(varchar,operatedate+’ ‘+operatetime,20) ELSE convert(varchar,GETDATE(),20) END))-convert(float,convert(datetime,convert(varchar,receivedate+’ '+receivetime,20))))2460 as 操作耗时分钟
,receivedate+ ’ ‘+operatetime as 接收时间
,operatedate+’ '+receivetime as 操作时间
from workflow_currentoperator wc where workflowid = 流程id