问题现象: | 人员有兼职岗位时,在工作流中能获取对应的兼职岗位,但是无法获取对应人员 SELECT hr_hi_person.cpsn_num, hr_hi_person.cpsn_name FROM hr_hi_person with(nolock) WHERE hr_hi_person.cpsn_num IN (SELECT hr_hi_person.cpsn_num FROM hr_hi_Person with(nolock) WHERE cpsn_num IN (SELECT cpsn_num FROM hr_hi_jobinfo with(nolock) where blastflag=1 AND bPartJob=0 AND cjobcode IN (SELECT hr_om_job.cjobcode FROM hr_om_job with(nolock) WHERE (hr_om_job.vjobname = '办事员' OR hr_om_job.vjobname = '项目经理') AND hr_om_job.cJobcode IN (SELECT cjobcode FROM Hr_OM_job A with(nolock), Department B with(nolock), Department C with(nolock) WHERE A.cdepcode = B.cdepcode and (B.cdepcode like C.cdepcode + '%' and (B.idepgrade >= C.idepgrade and B.idepgrade |
问题原因: | |
解决方案: | 您好, 此问题【经查看数据/测试】现做如下分析与答复: 【问题原因】 岗位下没有人员,工作流是不支持的。必须哟对应的人员。 【注意事项】修改前请务必做好数据备份; 【提示】如有问题,敬请及时邮件联系 |
相关补丁: | |
版本: | U8 V10.0 |
模块: | 工作流 |
产品: | 公共平台 |
问题名称: | 工作流能获取对应的兼职岗位,无法获取对应人员 |
最后更新: | 2011-09-08 23:24:34 |