w页面ksql只查询报错

胡屠户

UI2中w页面，模块没有对应biz层,只有UI层：

数据源 tempTaskData：
concept: SA_Task
reader:   /system/logic/action/queryTaskAction
columns:为空，选中后面按钮能够展示出字段

执行下面：var tempTaskData = this.comp("tempTaskData")；
tempTaskData.setFilter("idFilter", " SA_Task = (select s1.sFlowID from SA_Task s1 where s1 = '"+self.taskid+"')");
tempTaskData.refreshData();


提示错误：com.justep.exception.BusinessException: 编码: JUSTEP150210; 提示: 执行KSQL出错, KSQL: SELECT SA_Task.* FROM SA_Task SA_Task WHERE (( SA_Task = (select s1.sFlowID from SA_Task s1 where s1 = 'FFD9FD4594EE4077BB27C52068AE8945'))) LIMIT 0, 1 --> sql:  --> binds: [] at
BizProcedure.query(BizProcedure.java:36) ... 26 more Caused by: com.justep.exception.BusinessException: 编码: JUSTEP154053; 提示: KSQL语法错误, columns中的列sFlowID必须包含在select查出列中 at


可能是什么问题导致的呢？

jishuang

(select s1.sFlowID as sFlowID1 from SA_Task s1 where s1 = '"+self.taskid+"')

胡屠户

jishuang 发表于 2018-10-24 09:32
(select s1.sFlowID  as sFlowID1 from SA_Task s1 where s1 = '"+self.taskid+"')

结贴吧