数据集的sql语句，在数据库中能够查询出所有数据，放在报表10.0里查询不全，在8.0里也能查询齐全，是怎么回事呢？不全的数据都是以前 SELECT a.id,a.org_id,a.person_id,b.name,b.birthday,TIMESTAMPDIFF(YEAR, b.birthday, CURDATE()) as age,b.sex,b.tel,c.profession,b.current_area_id,d.province,d.city,d.district, b.current_addr, a.dept_id,e.name as dept_name,a.check_time,a.diagnose_time,disease_name,a.dot_user_id,f.realname as dot_realname FROM t_rc_aids a left join t_person b on a.person_id=b.id left join t_person_ext c on a.person_id=c.person_id left join t_area d on b.current_area_id=d.id left join t_org_department e on a.dept_id=e.id left join t_user f on a.dot_user_id=f.id where a.del_flag=0 and b.del_flag=0 and a.org_id='${orgId}' and Year(a.report_time)='${year}'; |
1min目标场景问卷
立即参与
