关于SA_OPOrg模型引用的一些问题

crackpot · 发表于 2013-6-6 20:15:57

本帖最后由 crackpot 于 2013-6-6 20:26 编辑

我这里的“配件领料明细表”模型是这样的，
5QQ图片20130606191550.jpg

其中的“队组”字段在“组织结构”那里有
我想对其进行排序。
6QQ图片20130606191623.jpg

在KSQL编辑器中，我增添了“组织结构”表中的“序列”字段。

在From设置中，表达式为：II_CB_PJRLLMX.fDZ = SA_OPOrg.sName
8QQ图片20130606191648.jpg

之后测试语句时候出现执行ksql异常，之前显示“下未找到概念SA_OPOrg的Store配置！”，我从论坛里http://bbs.justep.com/forum.php?mod=viewthread&tid=38382&highlight=include看到解决办法之添加了包含，不再出现那个错误提示
Caused by: com.justep.model.exception.ModelException: 执行ksql:select II_CB_PJRLLMX.fDZ as fDZ,II_CB_PJFL.fBM as fBM,(substring(II_CB_PJRLLMX.sFName, 1,  instr(II_CB_PJRLLMX.sFName, '/', 1) - 1 )) as fYJFL,II_CB_PJRLLMX.sCatalog as sCatalog,II_CB_PJRLLMX.sFName as sFName,II_CB_PJRLLMX.fRQ as fRQ,II_CB_PJRLLMX.fGG as fGG,sum(II_CB_PJRLLMX.fSL) as fSL,II_CB_PJRLLMX.fDW as fDW,II_CB_PJRLLMX.fDJ as fDJ,II_CB_PJRLLMX.fJE as fJE,II_CB_PJRLLMX.fGJ as fGJ,II_CB_PJRLLMX.fGJJE as fGJJE,SA_OPOrg.sSequence as sSequence    from II_CB_PJRLLMX II_CB_PJRLLMX    join II_CB_PJFL II_CB_PJFL on II_CB_PJRLLMX.sFName = II_CB_PJFL.sFName    join SA_OPOrg SA_OPOrg on II_CB_PJRLLMX.fDZ  =  SA_OPOrg.sName    where getMonth(II_CB_PJRLLMX.fRQ) = getMonth(:currentDate())    group by II_CB_PJRLLMX.fDZ, II_CB_PJRLLMX.sFName, II_CB_PJRLLMX.sCatalog, II_CB_PJRLLMX.fGG, II_CB_PJRLLMX.fDJ, II_CB_PJRLLMX.fGJ    order by II_CB_PJRLLMX.fDZ asc, II_CB_PJFL.fBM asc, II_CB_PJRLLMX.fGG asc LIMIT 0, 50时出错！
      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.KSQL.select(Unknown Source)
      at KSQLProcedure.query(KSQLProcedure.java:15)
      ... 25 more
Caused by: java.sql.SQLException: Table 'iims.sa_oporg' doesn't exist
      at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2928)
      at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1571)
      at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1666)
      at com.mysql.jdbc.Connection.execSQL(Connection.java:2994)
      at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:936)
      at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1030)
      at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
      at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
      at com.justep.system.ksql.KSQLUtils.execSqlSelect(Unknown Source)
      ... 30 more

Caused by: java.sql.SQLException: Table 'iims.sa_oporg' doesn't exist

为什么会出现这个提示啊？我想访问系统中的sa_oporg表数据啊

我就是想访问组织结构的原始数据来根据“组织结构”表中的“序列”字段对我材料领用明细进行对“队组”的排序