select a.* from `gdia_results`.`ads_fixed_Premium_propulsion` a join gdia_middle.sys_company_conversion b on a.permission=b.permission where 1=1 and a.areacode = substring('${fine_username}',5,6) ${if(or(MID(fine_username,1,4)="CIRC",MID (fine_username,1,4)="GDIA"), if(len(enddate)==0,"and a.companycode=b.comcode ","and a.companycode=b.comcode and a.statistics_date='"+enddate+"' and isnewcar = '"+isnewcar+"'and motortypename = '"+motortypename+"'") , if(len(enddate)==0,"and a.companycode=b.comcode "," and b.comcode=substring ('"+fine_username+"',1,4) and a.statistics_date='"+enddate+"' and isnewcar = '"+isnewcar+"'and motortypename = '"+motortypename+"'"))} order by a.comnumber 正常直接预览是能看全部数据的 但是加上下拉选的条件就不好使了。。看不见数据。可是在sql数据集加上下拉选条件预览的时候有数据 |