知识库 >> 软件使用教程及资料 >> 配置和管理 >> 报表功能 >> 
[#242] 查询超过3天没处理协作事项的协作人和件数
【内容】

报表类型:单个查询

SQL:

select u.displayName as [协办人],count(w.ProblemID) as [未处理事务数]
FROM Pts_CoWorkers w join Accounts_users u on w.UserID= u.UserID
WHERE IsWorked = 0 AND CreateTime < Datediff(d, -3, getdate())
group by u.DisplayName
order by count(w.ProblemID) desc

如果需要查询具体事项,则使用下面的SQL:

select u.displayName as [协办人],w.ProblemID as [事务ID], w.CreateTime as [开始时间]
FROM Pts_CoWorkers w join Accounts_users u on w.UserID= u.UserID
WHERE IsWorked = 0 AND CreateTime < Datediff(d, -3, getdate())
order by u.displayname

【备注】