查询配置参数引用名?
看了演示案例里,知识库应用里,在脚本里调用参数有用到parameters
var paramObj =parameters || {};
var sql = "select * from CMS_DOCUMENT t ";
if(paramObj.ids && paramObj.ids.length>0){
sql += "where t.xstringValue01in ('" + paramObj.ids.join("','") + "')"
}else{
sql += "where 1>2"
}
return sql;
固定资产应用里,报修记录(按年份)的脚本里调用参数用到写法this.parameters
var sql = "SELECT count(o.xpublishTime) as ACOUNT,EXTRACT(MONTH FROM o.xpublishTime) as AMONTH FROM CMS_DOCUMENT o";
sql += " where o.xpublishTime is not null and o.xcategoryName='报修记录'";
if(this.parameters.year){
sql += " and EXTRACT(YEAR FROM o.xpublishTime)="+this.parameters.year;
}
sql += " group by EXTRACT(MONTH FROM o.xpublishTime)";
return sql;
请问哪种写法是正确的?
都正确,建议使用this.parameters
参考:http://host/api/server.service.module_parameters.html#server.service.module_parameters
页:
[1]