|
使用调度任务调度后端脚本,脚本用于更新数据库字段,但总报错,检查了属性名称和实体uri以及单据编码都没问题,wapper也是根据文档格式进行的编写,但始终找不到原因,求大神指点迷津
日志如下:
函数执行失败2,异常信息:"YonQL查询失败:Error querying database. Cause: java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax;。querySchema:{\"fields\":[{\"name\":\"*\"}],\"conditions\":[{\"op\":\"and\",\"items\":[{\"name\":\"isReview\",\"op\":\"eq\",\"v1\":\"2\",\"attr\":\"bggwbzzy.bggwbzzy.bg_job_performance_evaluation.isReview\"},{\"name\":\"evaStatus\",\"op\":\"neq\",\"v1\":\"2\",\"attr\":\"bggwbzzy.bggwbzzy.bg_job_performance_evaluation.evaStatus\"},{\"name\":\"evaTime\",\"op\":\"lt\",\"v1\":\"2023-12-06 06:44:56\",\"attr\":\"bggwbzzy.bggwbzzy.bg_job_performance_evaluation.evaTime\"},{\"name\":\"dr\",\"op\":\"eq\",\"v1\":0,\"attr\":\"bggwbzzy.bggwbzzy.bg_job_performance_evaluation.dr\"},{\"name\":\"ytenantId\",\"op\":\"eq\",\"v1\":\"d6xscxbs\",\"attr\":\"bggwbzzy.bggwbzzy.bg_job_performance_evaluation.ytenantId\"}]}]}"
脚本如下:
实体设计如下:
|
本帖子中包含更多资源,您需要 登录 才可以下载或查看,没有帐号?立即注册
X
|