var paramobj = parameters;
var starttime =parameters.starttime;
var endtime =parameters.endtime;
var sql="select o.application,o.createtime,o.id,o.starttime,o.creatorunit,o.title,o.stringvalue01,o.stringvalue02,o.stringvalue03,o.stringvalue04 from com.x.processplatform.core.entity.content.workcompleted o "
sql ="where o.createtime >= {ts '" starttime "'} and o.createtime <= {ts '" endtime "'}";
return sql;直接编写jpql创建语句-示例如下图：
{
"starttime": "{ts '2021-03-01 21:04:16'}"
}
