报表类型:单个查询
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