{"title":"部门人员数量和休假统计","inframe":false,"hidden":false,"roles":{"demo":1,"dev":1},"pageLink":"","children":[{"configs":{"itemId":"module"},"children":[{"configs":{"sql":"select\nb.DEPT_NAME,\ncount(*)*50 as \"EMPLOYEES_COUNT\",\nsum(VACATION_HOURS) as \"VACATION_HOURS\"\nfrom WB_EMPLOYEE a, WB_EMP_DEPT b\nwhere a.DEPT_ID=b.DEPT_ID\ngroup by b.DEPT_NAME order by min(a.DEPT_ID)","itemId":"dataprovider1"},"children":[],"type":"dataprovider","expanded":false}],"type":"module","expanded":true}],"iconCls":""}