【泛微OA】常用的门户图表元素sql

最新推荐文章于 2025-07-04 09:19:47 发布

原创

最新推荐文章于 2025-07-04 09:19:47 发布 · 1k 阅读

12 ·

CC 4.0 BY-SA版权

文章标签：

#sql #数据库

1、流程操作次数（条形图）

select * from (select (select lastname from hrmresource where id =userid),count(*) as 流程操作人次数 from workflow_currentoperator group by userid order by count(*) desc)where rownum<=10
sqlserver:select top 10* from (select (select lastname from hrmresource where id =userid),count(*) as 流程操作人次数 from workflow_currentoperator group by userid order by count(*) desc)

2、各单位人数比（饼图 3D）

select * from (select(select subcompanyname from hrmsubcompany where id=subCompanyId1),count(id) As cids from hrmresource group by subCompanyId1 order by cids desc)where rownum<=10
sqlserver:select top 10* from (select(select subcompanyname from hrmsubcompany where id=subCompanyId1),count(id) As cids from hrmresource group by subCompanyId1 order by cids desc)

3、登陆次数排名（面积图 '2012-07-01' 到 '2012-08-20'之间的）

select * from (select relatedname,count(*) as 系统登陆次数 from
SysMaintenanceLog where operatetype = 6 a