通过脚本设置报表SQL数据源

【myApps/OBPM版本号】：v4.4- sp XX
【浏览器类型】：Chrome/其他
【联系方式-QQ】：请留下您的QQ号码
【联系电话】:    请留下您的联系电话，以便技术同事更好解决您的问题
【问题描述】：通过脚本设置报表SQL数据源









1、问题描述最好图文并茂，如有视频/脚本可直接放出，这样技术同事在处理该问题时效率更加高效哦~
2、如果该问题已得到解决，请在该帖子下回复\"已解决可结帖\"

//获取的是查询条件，组合成SQL数据源
(function () {
var doc = getCurrentDocument();
var ProjectName = doc.getItemValueAsString("S_ProjectName");
var ProjectCode = doc.getItemValueAsString("S_ProjectCode");
var ProjectPhase = doc.getItemValueAsString("S_ProjectPhase");
var sql = "select t.* from(select domainid, domainid as id ,item_selectplatform, item_platform,item_projectname , item_projectcode, item_ProjectPhase,item_ProductionPlace,count(*) as item_count from tlk_sample_vehicle_plan s where 1 = 1 group by domainid, item_selectplatform, item_platform,item_projectname, item_projectcode, item_projectphase,item_ProductionPlace) t where 1=1";
if (isNotNull(ProjectName)) {
   sql += " and item_projectname like '%" + ProjectName + "%'"
}
  if (isNotNull(ProjectCode)) {
   sql += " and item_projectcode like '%" + ProjectCode + "%'"
}
if (isNotNull(ProjectPhase)) {
   sql += " and item_ProjectPhase like '%" + ProjectPhase + "%'"
}
return sql;
})()