szjazz 发表于 2024-11-24 13:04:40

查询配置参数引用名?

看了演示案例里,
知识库应用里,在脚本里调用参数有用到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;

请问哪种写法是正确的?

论坛管理员 发表于 2024-11-25 10:25:38

都正确,建议使用this.parameters
参考:http://host/api/server.service.module_parameters.html#server.service.module_parameters
页: [1]
查看完整版本: 查询配置参数引用名?