![](https://img-blog.csdnimg.cn/20201014180756927.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
应用程序
ksose
喜欢交流运维方面的技术包括交换路由、linux,操作系统等等
展开
-
Ecology E9 查询部门人员信息
select * from ( select j.Name,j.Section, (case when j.Department is null then j.Section else j.Department end ) as Department,j.Branch,j.Company from ( select g.lastname as Name,g.departmentmark as Section,i.departmentmark as Department,g.subcompan...原创 2020-08-26 09:54:19 · 453 阅读 · 0 评论 -
Ecology 查询某人所有流程待办事项
查询A的所有待办流程: select distinct(a.requestid),b.requestname from workflow_currentoperator a,workflow_requestbase where isremark in (0,1,8,9) and a.requestid = b.requestid and useid = A的id原创 2020-08-26 09:52:59 · 275 阅读 · 0 评论 -
Ecology E9 查询某人待办流程未读的方法
select distinct(a.requestid),b.requestname from workflow_currentoperator a,workflow_requestbase b where b.status!='提醒' and isremark in (0) and viewtype=0 and a.requestid = b.requestid and userid = 19原创 2020-08-26 09:50:37 · 337 阅读 · 0 评论