多对多查询时-报JUSTEP151044错误

asia668

jishuang 发表于 2019-5-28 16:59
重写queryAction参考http://docs.wex5.com/bex5-process-question-list-10039/

现改为单表，并匹配字段，但还是报错：
1.JUSTEP150210，找不到错在哪里；
2.没有将概念eaba_file映射到数据库；数据库映射设置：我已勾选，下面的截图。
请帮忙指点！谢谢！
------------------------------------------------------------------------------------------------------------------------------------------------------
修改后的action语法:
public static Table qqueryEaba_file(List range,String concept,String select,String from,String aggregate,String dataModel,
                         String fnModel,String condition,Boolean distinct,String idColumn,String filter,Integer limit,Integer offset,
                         String columns,String orderBy,String aggregateColumns,Map variables){
                 String ksql="Select a.eaba00,a.eaba01,a.eaba02,a.eaba11,a.eaba12, a.eaba14,a.eaba15,a.eaba27,a.eaba28,a.eaba46,a.eaba49 from eaba_file a  " ;
                Table table =  KSQL.select(ksql, null, "/xxx/ERP/market/data", null);
                 return table;
    }
-------------------------------------------------------------------------------------------------------------------------
报错内容，如下:
刷新数据失败！ ,
执行KSQL出错, KSQL: Select a.eaba00,a.eaba01,a.eaba02,a.eaba11,a.eaba12, a.eaba14,a.eaba15,a.eaba27,a.eaba28,a.eaba46,a.eaba49 from eaba_file a
--> sql:
--> binds: []
编码：JUSTEP150210
[url=]隐藏详细[/url]
java.lang.reflect.InvocationTargetException at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:497) at com.justep.system.action.Engine.invokeActions(Native Method) at com.justep.system.action.Engine.invokeActions(Unknown Source) at com.justep.business.server.BusinessServer.doAction(Unknown Source) at com.justep.business.server.BusinessServer.doExcute(Unknown Source) at com.justep.business.server.BusinessServer.excute(Unknown Source) at com.justep.business.server.BusinessServer.excute(Unknown Source) at com.justep.business.server.BusinessServerServlet.execService(Unknown Source) at com.justep.business.server.BusinessServerServlet.service(Unknown Source) at javax.servlet.http.HttpServlet.service(HttpServlet.java:723) at com.justep.x.bs.BusinessServerServlet.service(Unknown Source) at javax.servlet.http.HttpServlet.service(HttpServlet.java:723) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.justep.micro.service.MicroServiceFilter.doFilter(Unknown Source) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293) at org.apache.coyote.http11.Http11AprProcessor.process(Http11AprProcessor.java:879) at org.apache.coyote.http11.Http11AprProtocol$Http11ConnectionHandler.process(Http11AprProtocol.java:617) at org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:1774) at java.lang.Thread.run(Thread.java:745) Caused by: com.justep.exception.BusinessException: 编码: JUSTEP150210; 提示: 执行KSQL出错, KSQL: Select a.eaba00,a.eaba01,a.eaba02,a.eaba11,a.eaba12, a.eaba14,a.eaba15,a.eaba27,a.eaba28,a.eaba46,a.eaba49 from eaba_file a  --> sql:  --> binds: [] 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.KSQL.select(Unknown Source) at Market.qqueryEaba_file(Market.java:26) ... 30 more Caused by: com.justep.exception.BusinessException: 编码: JUSTEP154001; 提示: 模块/xxx/ERP/market/data中, 没有将概念eaba_file映射到数据库 at com.justep.exception.BusinessException.create(Unknown Source) at com.justep.util.Utils.check(Unknown Source) at com.justep.system.ksql.ConceptMapping.getConceptMapping(Unknown Source) at com.justep.system.ksql.parser.AbstractParser.confirmSymTable(Unknown Source) at com.justep.system.ksql.parser.AbstractParser.parse(Unknown Source) ... 35 more

jishuang

没有生成数据库表

asia668

1.单表查询，已可以实现；
-----------------------------------------------------------------------------------------------------------------------
1.多表查询，我在研究看看；有参考的案例么？
2.选择grid表中的数据后，子页面发送父页面的语法，可以这么写么？请帮忙看看！谢谢！

this.owner.send({
                       p_eaba01:this.comp('mainData').getValueByID('eaba01', checkedID),
            });

jishuang

1.有的是一对多的http://bbs.wex5.com/forum.php?mod=viewthread&tid=37258
2.http://docs.wex5.com/page-interaction/