人事主档信息怎么查询是否上传过照片

[适用版本]

8.2sp2

[解决方案]

问题:人事主档信息怎么查询是否上传过照片

处理方案:

前台不支持配置查询,如需,可后台导出,参考语句如下

select c.FDISPLAYNAME_l2 as orgadmin , a.FNUMBER as fnumber ,a.fname_l2 as fname

from t_bd_person as a

left join t_hr_personposition as b on a.fid=b.fp