查询配置参数引用名？

szjazz

看了演示案例里，
知识库应用里，在脚本里调用参数有用到parameters

[AppleScript] 纯文本查看 复制代码

var paramObj =  parameters || {};
var sql = "select * from CMS_DOCUMENT t ";

if(paramObj.ids && paramObj.ids.length>0){
    sql += "where t.xstringValue01  in ('" + paramObj.ids.join("','") + "')"

}else{
    sql += "where 1>2"
}


return sql;

固定资产应用里，报修记录（按年份）的脚本里调用参数用到写法this.parameters

[AppleScript] 纯文本查看 复制代码

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