[适用版本]

8.5sp1,8.6,8.6sp1

[解决方案]

问题:获取直接上级为空问题的数据修复语句

处理方案:

参考脚本如下

--备份数据

select * into positionmember1014 from t_org_positionmember

--修复数据

insert into t_org_positionmember(fid,fpositionid,fpersonid,fisprimary,FCREATORID,FCREATETIME,FLASTUPDATEUSERID,FLASTUPDATETIME,FHRORGUNITID,FCONTROLUNITID, FCHECKLEN, FISCHECK,FCHECKSTATE)

select newbosid('0127BD68') fid,fpositionid,fpersonid,FASSIGNTYPE fisprimary,FCREATORID,FCREATETIME,FLASTUPDATEUSERID,FLASTUPDATETIME,FHRORGUNITID,FCONTROLUNITID,0 FCHECKLEN,0 FISCHECK,1 FCHECKSTATE

from t_hr_emporgrelation where FPERSONID ='EaEAAABjCVeA733t' and FLEFFDT ={ts '2199-12-31'}