[适用版本]:8.2,8.5,8.5sp1

[解决方案]:

--查询所有员工的上级岗位及上级员工
select ADMINP.fdisplayname_l2 组织全名称,POSITION.Fname_l2 职位名称,POSITION.fnumber 职位编码,ADMINP.fnumber 组织编码,PERSON.fname_l2 员工姓名,PERSON.fnumber 员工编码, PPOSITION.Fname_l2 上级职位名称, PPOSITION.fnumber 上级职位编码 ,PPERSON.fname_l2 上级员工姓名,PPERSON.fnumber 上级员工编码,PPUSER.FIsDelete 上级用户状态,PPUSER.FForbidden 上级用户状态
FROM T_BD_PERSON PERSON
LEFT OUTER JOIN T_ORG_PositionMember PM ON PM.FPERSONID = PERSON.FID
LEFT OUTER JOIN T_ORG_Position POSITION ON POSITION.FID = PM.FPOSITIONID
LEFT OUTER JOIN T_ORG_ADMIN ADMINP ON ADMINP.FID = POSITION.FADMINORGUNITID
LEFT OUTER JOIN T_ORG_PositionHierarchy chierarchy on chierarchy.FChildID=POSITION.FID
LEFT OUTER JOIN T_ORG_Position PPOSITION ON PPOSITION.FID = chierarchy.FParentID
LEFT OUTER JOIN T_ORG_PositionMember PPPM ON PPPM.FPositionID = PPOSITION.FID
LEFT OUTER JOIN T_BD_PERSON PPERSON ON PPERSON.FID=PPPM.FPersonID
left outer join t_pm_user PPUSER on PPERSON.FID=PPUSER.FPERSONID
--where ADMINP.fdisplayname_l2 like '环球集团_房地产_深圳区域公司_%'//可指定组织全称模糊匹配查询
-- and fHierarchyID='00000000-0000-0000-0000-000000000001396FCAD0'//可指定查询行政汇报关系上级
order by ADMINP.fdisplayname_l2,PPERSON.fnumber