|
楼主 |
发表于 2016-4-1 11:23:55
|
显示全部楼层
if(ydbrq){
str_where += " AND G_DQBML.DBRQ >= stringToDateTime('"+ydbrq+" 00:00:00"+"') AND G_DQBML.DBRQ <= stringToDateTime('"+ydbrq+" 23:59:59"+"') ";
}
if(yfcrq){
str_where += " AND G_DQBML.FCRQ >= stringToDateTime('"+yfcrq+" 00:00:00"+"') AND G_DQBML.FCRQ <= stringToDateTime('"+yfcrq+" 23:59:59"+"') ";
}
if(yb1){
str_where += " AND G_DQBML.LSH IN ( SELECT p1.LSH from G_DQBZW p1 WHERE p1.PM = '"+yb1+"' ) ";
}
bizDataYM.setFilter('filter1', str_where);
我这样写的,报错~
编码: JUSTEP150210; 提示: 执行KSQL出错, KSQL: SELECT G_DQBML.* FROM G_DQBML G_DQBML WHERE (( 1 = 1 AND G_DQBML.LSH IN ( SELECT p1.LSH from G_DQBZW p1 WHERE p1.PM = '钢丝绳' ) )) ORDER BY G_DQBML.LSH desc LIMIT 0, 25
编码: JUSTEP154053; 提示: KSQL语法错误, columns中的列LSH必须包含在select查出列中 |
|