问题现象: | 人员有兼职岗位时,在工作流中能获取对应的兼职岗位,但是无法获取对应人员 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 |
问题原因: | |
解决方案: | 您好,此问题与201108310110号问题重复,请跟踪201108310110号问题处理情况,谢谢! 若有问题,请及时反馈! U8/CRM/PLM |
相关补丁: | |
版本: | U8 V10.0 |
模块: | 工作流 |
产品: | 公共平台 |
问题名称: | 工作流能获取对应的兼职岗位,无法获取对应人员 |
最后更新: | 2011-09-08 23:24:37 |