|

楼主 |
发表于 2017-12-27 00:32:47
|
显示全部楼层
现在我设置where如下
action如下
public static Table cha5(String concept,String idColumn,String select,String from,String condition,List<DataPermission> range,String filter,Boolean distinct,Integer offset,Integer limit,String columns,String orderBy,String aggregate,String aggregateColumns,Map<String, Object> variables,String dataModel,String fnModel){
String ksql = "select SO_KHZL.*,SO_WPXQ.*from SO_KHZL SO_KHZL optional join SO_WPXQ SO_WPXQ on SO_KHZL = SO_WPXQ.fZBID";//需要查询数据的ksql
System.out.println(condition);
if (Utils.isNotEmptyString(condition)) {
ksql = ksql + " where " + condition;
}
System.out.println(ksql);
Table table = KSQL.select(ksql, variables, "/songhuorenwu/songhuo/data", null);//调用平台提供的API执行sql,并返回table
return table;
在事件中设置如下:
Model.prototype.mainDataRefreshCreateParam = function(event){
var mapParam = new biz.Request.MapParam();
mapParam.put("p","%"+this.comp("statusData").val("starttime")+"%");
mapParam.put("a","SO_KHZL.fSHSJ between '"+this.comp("statusData").val("starttimee")+"' and '"+this.comp("statusData").val("endtime")+"'");
event.param.setMap("variables",mapParam);
};
现在不报错,时间段过滤没反应,请大神指点迷津?
|
|