列prjMaterialsLoan必须包含在select查出列中

qwertyu

报错信息：
编码: JUSTEP150210; 提示: 执行KSQL出错, KSQL: SELECT prjMaterialsLoanDetail,prjMaterialsLoanDetail.mainID as mainID,prjMaterialsLoan.borrowNo as borrowNo,prjMaterialsLoanDetail.fileName as fileName,prjMaterialsLoanDetail.fileDept as fileDept,prjMaterialsLoanDetail.fileDeptId as fileDeptId,prjMaterialsLoanDetail.borrowWay as borrowWay,prjMaterialsLoanDetail.borrowTime as borrowTime,prjMaterialsLoanDetail.returnTime as returnTime,prjMaterialsLoanDetail.actualReturn as actualReturn,prjMaterialsLoan.fCreatePersonName as fCreatePersonName,prjMaterialsLoan.fCreatePersonID as fCreatePersonID,prjMaterialsLoan.fCreatePersonCode as fCreatePersonCode,prjMaterialsLoan.fCreatePersonFID as fCreatePersonFID,prjMaterialsLoan.fCreateDeptName as fCreateDeptName,prjMaterialsLoan.fCreateDeptID as fCreateDeptID,prjMaterialsLoan.fCreateDeptCode as fCreateDeptCode,prjMaterialsLoan.fCreatdTime as fCreatdTime,prjMaterialsLoan.fUpdateTime as fUpdateTime,prjMaterialsLoan.fActivity as fActivity,prjMaterialsLoan.fActivityName as fActivityName,prjMaterialsLoan.fTaskID as fTaskID,prjMaterialsLoan.fProcessID as fProcessID,prjMaterialsLoan.processStatus as processStatus,prjMaterialsLoan.borrowType as borrowType,prjMaterialsLoan.reason as reason,prjMaterialsLoan.attachment as attachment,prjMaterialsLoan.bidNo as bidNo,prjMaterialsLoan.bidName as bidName,prjMaterialsLoan.accountUnitCode as accountUnitCode,prjMaterialsLoan.accountUnitName as accountUnitName  FROM prjMaterialsLoanDetail prjMaterialsLoanDetail  join prjMaterialsLoan prjMaterialsLoan on prjMaterialsLoanDetail.mainID = prjMaterialsLoan WHERE (prjMaterialsLoan.processStatus in ('已完成', '流程中')  AND prjMaterialsLoan.borrowNo LIKE 'XMZLJY%') AND (( fCreatePersonID='200493' )) ORDER BY prjMaterialsLoanDetail.borrowTime desc LIMIT 0, 20\n --> sql: \n --> binds: []\n\tat com.justep.exception.BusinessException.create(Unknown Source)\n\tat com.justep.system.data.impl.TableUtilsImplement.ksqlSelect(Unknown Source)\n\tat com.justep.system.data.impl.TableUtilsImplement.ksqlSelect(Unknown Source)\n\tat com.justep.system.data.impl.TableUtilsImplement.ksqlSelect(Unknown Source)\n\tat com.justep.system.data.BizData.query(Unknown Source)\n\tat BizProcedure.query(BizProcedure.java:12)\n\t... 30 more\nCaused by: com.justep.exception.BusinessException: 编码: JUSTEP154053; 提示: KSQL语法错误, columns中的列prjMaterialsLoan必须包含在select查出列中\n\tat com.justep.exception.BusinessException.create(Unknown Source)\n\tat com.justep.util.Utils.check(Unknown Source)\n\tat com.justep.system.ksql.parser.AbstractParser.handleColumns(Unknown Source)\n\tat com.justep.system.ksql.parser.AbstractParser.selectSentenceNode(Unknown Source)\n\tat com.justep.system.ksql.parser.QueryParser.start(Unknown Source)\n\tat com.justep.system.ksql.parser.QueryParser.start(Unknown Source)\n\tat com.justep.system.ksql.parser.AbstractParser.parse(Unknown Source)\n\t... 35 more\n","messages":["编码: JUSTEP150210; 提示: 执行KSQL出错, KSQL: SELECT prjMaterialsLoanDetail,prjMaterialsLoanDetail.mainID as mainID,prjMaterialsLoan.borrowNo as borrowNo,prjMaterialsLoanDetail.fileName as fileName,prjMaterialsLoanDetail.fileDept as fileDept,prjMaterialsLoanDetail.fileDeptId as fileDeptId,prjMaterialsLoanDetail.borrowWay as borrowWay,prjMaterialsLoanDetail.borrowTime as borrowTime,prjMaterialsLoanDetail.returnTime as returnTime,prjMaterialsLoanDetail.actualReturn as actualReturn,prjMaterialsLoan.fCreatePersonName as fCreatePersonName,prjMaterialsLoan.fCreatePersonID as fCreatePersonID,prjMaterialsLoan.fCreatePersonCode as fCreatePersonCode,prjMaterialsLoan.fCreatePersonFID as fCreatePersonFID,prjMaterialsLoan.fCreateDeptName as fCreateDeptName,prjMaterialsLoan.fCreateDeptID as fCreateDeptID,prjMaterialsLoan.fCreateDeptCode as fCreateDeptCode,prjMaterialsLoan.fCreatdTime as fCreatdTime,prjMaterialsLoan.fUpdateTime as fUpdateTime,prjMaterialsLoan.fActivity as fActivity,prjMaterialsLoan.fActivityName as fActivityName,prjMaterialsLoan.fTaskID as fTaskID,prjMaterialsLoan.fProcessID as fProcessID,prjMaterialsLoan.processStatus as processStatus,prjMaterialsLoan.borrowType as borrowType,prjMaterialsLoan.reason as reason,prjMaterialsLoan.attachment as attachment,prjMaterialsLoan.bidNo as bidNo,prjMaterialsLoan.bidName as bidName,prjMaterialsLoan.accountUnitCode as accountUnitCode,prjMaterialsLoan.accountUnitName as accountUnitName  FROM prjMaterialsLoanDetail prjMaterialsLoanDetail  join prjMaterialsLoan prjMaterialsLoan on prjMaterialsLoanDetail.mainID = prjMaterialsLoan WHERE (prjMaterialsLoan.processStatus in ('已完成', '流程中')  AND prjMaterialsLoan.borrowNo LIKE 'XMZLJY%') AND (( fCreatePersonID='200493' )) ORDER BY prjMaterialsLoanDetail.borrowTime desc LIMIT 0, 20\n --> sql: \n --> binds: []","编码: JUSTEP154053; 提示: KSQL语法错误, columns中的列prjMaterialsLoan必须包含在select查出列中"],"url":"https://m.cicdi.com/BusinessServer/business-action","param":{"contentType":"json","accept":"application/json","process":"/JSPTPDERP/meetingAndScreen/process/prjMaterialsLoan/prjMaterialsLoanProcess","activity":"query","actionFlag":"__action_0__","executor":"","executeContext":"","action":"queryPrjMaterialsLoan_Detail","parameters":{"variables":{},"filter":"( fCreatePersonID='200493' )","offset":0,"limit":20,"columns":"fileDept,reason,fileName,processStatus,fCreatePersonID,bidNo,accountUnitCode,borrowWay,prjMaterialsLoanDetail,fCreatePersonName,fCreatdTime,fActivityName,attachment,borrowTime,mainID,borrowNo,bidName,fCreateDeptID,fCreateDeptCode,fileDeptId,actualReturn,fCreatePersonCode,accountUnitName,returnTime,prjMaterialsLoan,fProcessID,fUpdateTime,fCreateDeptName,fTaskID,borrowType,fCreatePersonFID,fActivity"},"translateParameter":{"dataType":"row-list","transformIdcolumn":true,"includeState":true,"useNamespace":true,"cellnameByRelation":false,"rowsConfig":{"concept":"prjMaterialsLoanDetail","sequence":"fileDept,reason,fileName,processStatus,fCreatePersonID,bidNo,accountUnitCode,borrowWay,prjMaterialsLoanDetail,fCreatePersonName,fCreatdTime,fActivityName,attachment,borrowTime,mainID,borrowNo,bidName,fCreateDeptID,fCreateDeptCode,fileDeptId,actualReturn,fCreatePersonCode,accountUnitName,returnTime,prjMaterialsLoan,fProcessID,fUpdateTime,fCreateDeptName,fTaskID,borrowType,fCreatePersonFID,fActivity"}}}}__justepServerErrorEnd__

qwertyu

"action":"queryPrjMaterialsLoan_Detail"
select prjMaterialsLoanDetail,prjMaterialsLoanDetail.mainID as mainID,prjMaterialsLoan.borrowNo as borrowNo,prjMaterialsLoanDetail.fileName as fileName,prjMaterialsLoanDetail.fileDept as fileDept,prjMaterialsLoanDetail.fileDeptId as fileDeptId,prjMaterialsLoanDetail.borrowWay as borrowWay,prjMaterialsLoanDetail.borrowTime as borrowTime,prjMaterialsLoanDetail.returnTime as returnTime,prjMaterialsLoanDetail.actualReturn as actualReturn,prjMaterialsLoan.fCreatePersonName as fCreatePersonName,prjMaterialsLoan.fCreatePersonID as fCreatePersonID,prjMaterialsLoan.fCreatePersonCode as fCreatePersonCode,prjMaterialsLoan.fCreatePersonFID as fCreatePersonFID,prjMaterialsLoan.fCreateDeptName as fCreateDeptName,prjMaterialsLoan.fCreateDeptID as fCreateDeptID,prjMaterialsLoan.fCreateDeptCode as fCreateDeptCode,prjMaterialsLoan.fCreatdTime as fCreatdTime,prjMaterialsLoan.fUpdateTime as fUpdateTime,prjMaterialsLoan.fActivity as fActivity,prjMaterialsLoan.fActivityName as fActivityName,prjMaterialsLoan.fTaskID as fTaskID,prjMaterialsLoan.fProcessID as fProcessID,prjMaterialsLoan.processStatus as processStatus,prjMaterialsLoan.borrowType as borrowType,prjMaterialsLoan.reason as reason,prjMaterialsLoan.attachment as attachment,prjMaterialsLoan.bidNo as bidNo,prjMaterialsLoan.bidName as bidName,prjMaterialsLoan.accountUnitCode as accountUnitCode,prjMaterialsLoan.accountUnitName as accountUnitName
    from prjMaterialsLoanDetail prjMaterialsLoanDetail
     join prjMaterialsLoan prjMaterialsLoan on prjMaterialsLoanDetail.mainID = prjMaterialsLoan
    where prjMaterialsLoan.processStatus in ('已完成', '流程中')  AND prjMaterialsLoan.borrowNo LIKE 'XMZLJY%'
    order by prjMaterialsLoanDetail.borrowTime desc

qwertyu

尝试过把prjMaterialsLoan写在查询列中，但是会报错：未明确定义列

jishuang

ksql编辑器中通过概念中选择这个列看看

qwertyu

jishuang 发表于 2019-9-23 08:56
ksql编辑器中通过概念中选择这个列看看

把这列加上去以后报错未明确定义列

Caused by: com.justep.exception.BusinessException: 编码: JUSTEP150039; 提示: 执行sql: SELECT ROWNUM AS JUSTEP_RN__, JUSTEP_TABLE__.* FROM (SELECT  prjMaterialsLoanDetail.FILEDEPT AS fileDept, prjMaterialsLoan.REASON AS reason, prjMaterialsLoanDetail.FILENAME AS fileName, prjMaterialsLoan.PROCESSSTATUS AS processStatus, prjMaterialsLoan.FCREATEPERSONID AS fCreatePersonID, prjMaterialsLoan.BIDNO AS bidNo, prjMaterialsLoan.ACCOUNTUNITCODE AS accountUnitCode, prjMaterialsLoanDetail.BORROWWAY AS borrowWay, prjMaterialsLoanDetail.fID, prjMaterialsLoan.FCREATEPERSONNAME AS fCreatePersonName, prjMaterialsLoan.FCREATDTIME AS fCreatdTime, prjMaterialsLoan.FACTIVITYNAME AS fActivityName, prjMaterialsLoan.ATTACHMENT AS attachment, prjMaterialsLoanDetail.BORROWTIME AS borrowTime, prjMaterialsLoanDetail.MAINID AS mainID, prjMaterialsLoan.BORROWNO AS borrowNo, prjMaterialsLoan.BIDNAME AS bidName, prjMaterialsLoan.FCREATEDEPTID AS fCreateDeptID, prjMaterialsLoan.FCREATEDEPTCODE AS fCreateDeptCode, prjMaterialsLoanDetail.FILEDEPTID AS fileDeptId, prjMaterialsLoanDetail.ACTUALRETURN AS actualReturn, prjMaterialsLoan.FCREATEPERSONCODE AS fCreatePersonCode, prjMaterialsLoan.ACCOUNTUNITNAME AS accountUnitName, prjMaterialsLoanDetail.RETURNTIME AS returnTime, prjMaterialsLoan.fID, prjMaterialsLoan.FPROCESSID AS fProcessID, prjMaterialsLoan.FUPDATETIME AS fUpdateTime, prjMaterialsLoan.FCREATEDEPTNAME AS fCreateDeptName, prjMaterialsLoan.FTASKID AS fTaskID, prjMaterialsLoan.BORROWTYPE AS borrowType, prjMaterialsLoan.FCREATEPERSONFID AS fCreatePersonFID, prjMaterialsLoan.FACTIVITY AS fActivity FROM PRJMATERIALSLOANDETAIL prjMaterialsLoanDetail JOIN PRJMATERIALSLOAN prjMaterialsLoan ON prjMaterialsLoanDetail.MAINID = prjMaterialsLoan.fID  WHERE  ( ( prjMaterialsLoan.PROCESSSTATUS IN (?, ?) ) AND (prjMaterialsLoan.BORROWNO LIKE ?) ) AND (fCreatePersonID = ?)   ORDER BY prjMaterialsLoanDetail.BORROWTIME DESC) JUSTEP_TABLE__  WHERE ROWNUM<21, binds: [已完成, 流程中, XMZLJY%, 200588]出错
        at com.justep.exception.BusinessException.create(Unknown Source)
        at com.justep.system.ksql.KSQLUtils.execSqlSelect(Unknown Source)
        ... 40 more
Caused by: java.sql.SQLException: ORA-00918: 未明确定义列

        at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
        at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
        at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
        at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:743)
        at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:213)
        at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:796)
        at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1031)
        at oracle.jdbc.driver.T4CPreparedStatement.executeMaybeDescribe(T4CPreparedStatement.java:836)
        at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1124)
        at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3285)
        at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3329)
        at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
        at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
        ... 41 more

qwertyu

Caused by: com.justep.exception.BusinessException: 编码: JUSTEP150210; 提示: 执行KSQL出错, KSQL: SELECT prjMaterialsLoanDetail,prjMaterialsLoanDetail.mainID as mainID,prjMaterialsLoan.borrowNo as borrowNo,prjMaterialsLoanDetail.fileName as fileName,prjMaterialsLoanDetail.fileDept as fileDept,prjMaterialsLoanDetail.fileDeptId as fileDeptId,prjMaterialsLoanDetail.borrowWay as borrowWay,prjMaterialsLoanDetail.borrowTime as borrowTime,prjMaterialsLoanDetail.returnTime as returnTime,prjMaterialsLoanDetail.actualReturn as actualReturn,prjMaterialsLoan,prjMaterialsLoan.fCreatePersonName as fCreatePersonName,prjMaterialsLoan.fCreatePersonID as fCreatePersonID,prjMaterialsLoan.fCreatePersonCode as fCreatePersonCode,prjMaterialsLoan.fCreatePersonFID as fCreatePersonFID,prjMaterialsLoan.fCreateDeptName as fCreateDeptName,prjMaterialsLoan.fCreateDeptID as fCreateDeptID,prjMaterialsLoan.fCreateDeptCode as fCreateDeptCode,prjMaterialsLoan.fCreatdTime as fCreatdTime,prjMaterialsLoan.fUpdateTime as fUpdateTime,prjMaterialsLoan.fActivity as fActivity,prjMaterialsLoan.fActivityName as fActivityName,prjMaterialsLoan.fTaskID as fTaskID,prjMaterialsLoan.fProcessID as fProcessID,prjMaterialsLoan.processStatus as processStatus,prjMaterialsLoan.borrowType as borrowType,prjMaterialsLoan.reason as reason,prjMaterialsLoan.attachment as attachment,prjMaterialsLoan.bidNo as bidNo,prjMaterialsLoan.bidName as bidName,prjMaterialsLoan.accountUnitCode as accountUnitCode,prjMaterialsLoan.accountUnitName as accountUnitName  FROM prjMaterialsLoanDetail prjMaterialsLoanDetail  join prjMaterialsLoan prjMaterialsLoan on prjMaterialsLoanDetail.mainID = prjMaterialsLoan WHERE (prjMaterialsLoan.processStatus in ('已完成', '流程中')  AND prjMaterialsLoan.borrowNo LIKE 'XMZLJY%') AND (( fCreatePersonID='200588' )) ORDER BY prjMaterialsLoanDetail.borrowTime desc LIMIT 0, 20
--> sql: SELECT ROWNUM AS JUSTEP_RN__, JUSTEP_TABLE__.* FROM (SELECT  prjMaterialsLoanDetail.FILEDEPT AS fileDept, prjMaterialsLoan.REASON AS reason, prjMaterialsLoanDetail.FILENAME AS fileName, prjMaterialsLoan.PROCESSSTATUS AS processStatus, prjMaterialsLoan.FCREATEPERSONID AS fCreatePersonID, prjMaterialsLoan.BIDNO AS bidNo, prjMaterialsLoan.ACCOUNTUNITCODE AS accountUnitCode, prjMaterialsLoanDetail.BORROWWAY AS borrowWay, prjMaterialsLoanDetail.fID, prjMaterialsLoan.FCREATEPERSONNAME AS fCreatePersonName, prjMaterialsLoan.FCREATDTIME AS fCreatdTime, prjMaterialsLoan.FACTIVITYNAME AS fActivityName, prjMaterialsLoan.ATTACHMENT AS attachment, prjMaterialsLoanDetail.BORROWTIME AS borrowTime, prjMaterialsLoanDetail.MAINID AS mainID, prjMaterialsLoan.BORROWNO AS borrowNo, prjMaterialsLoan.BIDNAME AS bidName, prjMaterialsLoan.FCREATEDEPTID AS fCreateDeptID, prjMaterialsLoan.FCREATEDEPTCODE AS fCreateDeptCode, prjMaterialsLoanDetail.FILEDEPTID AS fileDeptId, prjMaterialsLoanDetail.ACTUALRETURN AS actualReturn, prjMaterialsLoan.FCREATEPERSONCODE AS fCreatePersonCode, prjMaterialsLoan.ACCOUNTUNITNAME AS accountUnitName, prjMaterialsLoanDetail.RETURNTIME AS returnTime, prjMaterialsLoan.fID, prjMaterialsLoan.FPROCESSID AS fProcessID, prjMaterialsLoan.FUPDATETIME AS fUpdateTime, prjMaterialsLoan.FCREATEDEPTNAME AS fCreateDeptName, prjMaterialsLoan.FTASKID AS fTaskID, prjMaterialsLoan.BORROWTYPE AS borrowType, prjMaterialsLoan.FCREATEPERSONFID AS fCreatePersonFID, prjMaterialsLoan.FACTIVITY AS fActivity FROM PRJMATERIALSLOANDETAIL prjMaterialsLoanDetail JOIN PRJMATERIALSLOAN prjMaterialsLoan ON prjMaterialsLoanDetail.MAINID = prjMaterialsLoan.fID  WHERE  ( ( prjMaterialsLoan.PROCESSSTATUS IN (?, ?) ) AND (prjMaterialsLoan.BORROWNO LIKE ?) ) AND (fCreatePersonID = ?)   ORDER BY prjMaterialsLoanDetail.BORROWTIME DESC) JUSTEP_TABLE__  WHERE ROWNUM<21
--> binds: [已完成, 流程中, XMZLJY%, 200588]
        at com.justep.exception.BusinessException.create(Unknown Source)
        at com.justep.system.data.impl.TableUtilsImplement.ksqlSelect(Unknown Source)
        at com.justep.system.data.impl.TableUtilsImplement.ksqlSelect(Unknown Source)
        at com.justep.system.data.impl.TableUtilsImplement.ksqlSelect(Unknown Source)
        at com.justep.system.data.BizData.query(Unknown Source)
        at BizProcedure.query(BizProcedure.java:12)
        ... 35 more

jishuang

把sql语句复制到数据库中去执行看看

qwertyu

jishuang 发表于 2019-9-24 17:30
把sql语句复制到数据库中去执行看看

报错未明确定义列，但是我ksql写的有问题吗？6#是ksql的语句

qwertyu

action是这个：
select prjMaterialsLoanDetail,prjMaterialsLoanDetail.mainID as mainID,prjMaterialsLoan.borrowNo as borrowNo,prjMaterialsLoanDetail.fileName as fileName,prjMaterialsLoanDetail.fileDept as fileDept,prjMaterialsLoanDetail.fileDeptId as fileDeptId,prjMaterialsLoanDetail.borrowWay as borrowWay,prjMaterialsLoanDetail.borrowTime as borrowTime,prjMaterialsLoanDetail.returnTime as returnTime,prjMaterialsLoanDetail.actualReturn as actualReturn,prjMaterialsLoan.fCreatePersonName as fCreatePersonName,prjMaterialsLoan.fCreatePersonID as fCreatePersonID,prjMaterialsLoan.fCreatePersonCode as fCreatePersonCode,prjMaterialsLoan.fCreatePersonFID as fCreatePersonFID,prjMaterialsLoan.fCreateDeptName as fCreateDeptName,prjMaterialsLoan.fCreateDeptID as fCreateDeptID,prjMaterialsLoan.fCreateDeptCode as fCreateDeptCode,prjMaterialsLoan.fCreatdTime as fCreatdTime,prjMaterialsLoan.fUpdateTime as fUpdateTime,prjMaterialsLoan.fActivity as fActivity,prjMaterialsLoan.fActivityName as fActivityName,prjMaterialsLoan.fTaskID as fTaskID,prjMaterialsLoan.fProcessID as fProcessID,prjMaterialsLoan.processStatus as processStatus,prjMaterialsLoan.borrowType as borrowType,prjMaterialsLoan.reason as reason,prjMaterialsLoan.attachment as attachment,prjMaterialsLoan.bidNo as bidNo,prjMaterialsLoan.bidName as bidName,prjMaterialsLoan.accountUnitCode as accountUnitCode,prjMaterialsLoan.accountUnitName as accountUnitName
    from prjMaterialsLoanDetail prjMaterialsLoanDetail
     join prjMaterialsLoan prjMaterialsLoan on prjMaterialsLoanDetail.mainID = prjMaterialsLoan
    where prjMaterialsLoan.processStatus in ('已完成', '流程中')  AND prjMaterialsLoan.borrowNo LIKE 'XMZLJY%'
    order by prjMaterialsLoanDetail.borrowTime desc

jishuang

未明确定义列，oracle数据库报错的，把sql拿到数据库中执行看看具体是哪个列有问题，不是添加的这个列的问题