适用于使用主要任职作为流程直接上级的用户。

解决设置职位后，无法直观看出汇报关系。

祭出大杀器：

sql语句，可以向上查询到三级：

select tbdp.FNUMBER as 员工编码,tbdp.FNAME_l2 as 员工姓名,top.FNAME_l2 as 职位名称,top1.FNAME_l2 as 直接上级岗位 ,tbdp1.fname_l2 as 直接上级姓名, top2.FNAME_l2 as 二级上级岗位,tbdp2.fname_l2 as 二级上级姓名, top3.fname_l2 as 三级上级岗位,tbdp3.fname_l2 as 三级上级姓名, tobe.FDISPLAYNAME_l2  as 组织信息,tbdp.FDELETEDSTATUS as 状态  from T_HR_PersonPosition thrp

LEFT OUTER JOIN T_bd_person tbdp ON THRP.FPERSONID = TBDP.FID

LEFT OUTER JOIN T_ORG_POSITION top ON THRP.FPRIMARYPOSITIONID = TOP.FID

LEFT OUTER JOIN T_ORG_BASEUNIT tobe ON thrp.FPERSONDEP  = tobe.FID 

LEFT OUTER JOIN T_ORG_POSITION top1 on top.FPARENTID = top1.fid

LEFT OUTER JOIN T_ORG_PositionMember topm1 on topm1.FPOSITIONID = top1.fid

LEFT OUTER JOIN T_bd_person tbdp1 on tbdp1.fid = topm1.FPERSONID 

LEFT OUTER JOIN T_ORG_POSITION top2 on top1.FPARENTID = top2.fid

LEFT OUTER JOIN T_ORG_PositionMember topm2 on topm2.FPOSITIONID = top2.fid

LEFT OUTER JOIN T_bd_person tbdp2 on tbdp2.fid = topm2.FPERSONID 

LEFT OUTER JOIN T_ORG_POSITION top3 on top2.FPARENTID = top3.fid

LEFT OUTER JOIN T_ORG_PositionMember topm3 on topm3.FPOSITIONID = top3.fid

LEFT OUTER JOIN T_bd_person tbdp3 on tbdp3.fid = topm3.FPERSONID 

整理下你的SQL，T_ORG_POSITION top 修改 top为关键字，不能作为别名，修改为 T_ORG_POSITION top0:

select tbdp.FNUMBER as 员工编码,tbdp.FNAME_l2 as 员工姓名,

top0.FNAME_l2 as 职位名称,

top1.FNAME_l2 as 直接上级岗位 ,tbdp1.fname_l2 as 直接上级姓名, 

top2.FNAME_l2 as 二级上级岗位,tbdp2.fname_l2 as 二级上级姓名, 

top3.fname_l2 as 三级上级岗位,tbdp3.fname_l2 as 三级上级姓名, 

tobe.FDISPLAYNAME_l2 as 组织信息,

tbdp.FDELETEDSTATUS as 状态

 from T_HR_PersonPosition thrp 

 LEFT OUTER JOIN T_bd_person tbdp ON THRP.FPERSONID = TBDP.FID

 LEFT OUTER JOIN T_ORG_POSITION top0 ON THRP.FPRIMARYPOSITIONID = TOP0.FID

 LEFT OUTER JOIN T_ORG_BASEUNIT tobe ON thrp.FPERSONDEP= tobe.FID

 LEFT OUTER JOIN T_ORG_POSITION top1 on top0.FPARENTID = top1.fid

 LEFT OUTER JOIN T_ORG_PositionMember topm1 on topm1.FPOSITIONID = top1.fid

 LEFT OUTER JOIN T_bd_person tbdp1 on tbdp1.fid = topm1.FPERSONID

 LEFT OUTER JOIN T_ORG_POSITION top2 on top1.FPARENTID = top2.fid

 LEFT OUTER JOIN T_ORG_PositionMember topm2 on topm2.FPOSITIONID = top2.fid

 LEFT OUTER JOIN T_bd_person tbdp2 on tbdp2.fid = topm2.FPERSONID

 LEFT OUTER JOIN T_ORG_POSITION top3 on top2.FPARENTID = top3.fid

 LEFT OUTER JOIN T_ORG_PositionMember topm3 on topm3.FPOSITIONID = top3.fid

 LEFT OUTER JOIN T_bd_person tbdp3 on tbdp3.fid = topm3.FPERSONID