[适用版本]

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.fpersonid

left join T_ORG_admin as c on b.FPERSONDEP =c.fid

where a.fid not in (select fpersonid from t_hr_personphoto where fimagedata is not null )