请教一下，多表查询

fangyeer

bex5中是否可以通过在baas中添加自定义action,关联java方法，然后在前台用baasdata来实现多表查询，例如http://bbs.wex5.com/forum.php?mod=viewthread&tid=117690&highlight=%E5%A4%9A%E8%A1%A8%E6%9F%A5%E8%AF%A2&mobile=2这个例子？

jishuang

可以，部署的是需要baas也部署

BIZ中也可以自己定义action，在java中自己写sql多表关联查询啊

fangyeer

BIZ中自定义action?有例子吗？

jishuang

https://pan.baidu.com/s/1cxHxro#list/path=%2F
第4章4.5.2

fangyeer

新建了一个action,建立w文件使用，data里有数据，但是在浏览器打开出错，别的W文件都正常，错误如下

无法获取未定义或 null 引用的属性“userdata”





隐藏详细

TypeError: 无法获取未定义或 null 引用的属性“userdata” at callback (http://192.168.3.3:8080/x5/UI2/v ... mon.min.js:12:61648) at h (http://192.168.3.3:8080/x5/UI2/v ... mmon.min.js:12:6880) at f (http://192.168.3.3:8080/x5/UI2/v ... ore.min.js:71:42062) at l.add (http://192.168.3.3:8080/x5/UI2/v ... ore.min.js:71:42384) at _sendRequest (http://192.168.3.3:8080/x5/UI2/v ... mmon.min.js:12:7227) at Request.sendRequest (http://192.168.3.3:8080/x5/UI2/v ... mmon.min.js:12:7559) at $var._sendBizRequest (eval code:1:554) at Request.sendBizRequest (http://192.168.3.3:8080/x5/UI2/v ... mmon.min.js:12:9810) at _doRefreshData (http://192.168.3.3:8080/x5/UI2/v ... mon.min.js:12:61298) at doRefreshData (http://192.168.3.3:8080/x5/UI2/v ... mon.min.js:12:59038)

fangyeer

刷新此页以查看 F12 工具打开前可能已出现的消息。
TypeError: 无法获取未定义或 null 引用的属性“userdata”
   at callback (http://192.168.3.3:8080/x5/UI2/v ... mon.min.js:12:61648)
   at h (http://192.168.3.3:8080/x5/UI2/v ... mmon.min.js:12:6880)
   at f (http://192.168.3.3:8080/x5/UI2/v ... ore.min.js:71:42062)
   at l.add (http://192.168.3.3:8080/x5/UI2/v ... ore.min.js:71:42384)
   at _sendRequest (http://192.168.3.3:8080/x5/UI2/v ... mmon.min.js:12:7227)
   at Request.sendRequest (http://192.168.3.3:8080/x5/UI2/v ... mmon.min.js:12:7559)
   at $var._sendBizRequest (eval code:1:554)
   at Request.sendBizRequest (http://192.168.3.3:8080/x5/UI2/v ... mmon.min.js:12:9810)
   at _doRefreshData (http://192.168.3.3:8080/x5/UI2/v ... mon.min.js:12:61298)
   at doRefreshData (http://192.168.3.3:8080/x5/UI2/v ... mon.min.js:12:59038)
SCRIPT5007: 无法获取未定义或 null 引用的属性“userdata”
core.min.js, 行71 字符285692

jishuang

如果是要把自定义的action的数据给data
参考
http://docs.wex5.com/bex5-ui-question-list-10069/

fangyeer

我按楼上做了，现在提示：模块"/appdemo"不存在

编码：JUSTEP151058


模块"/appdemo"不存在

编码：JUSTEP151058



隐藏详细

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 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.Http11Processor.process(Http11Processor.java:861) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:606) at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489) at java.lang.Thread.run(Thread.java:745) Caused by: com.justep.exception.BusinessException: 编码: JUSTEP151058; 提示: 模块"/appdemo"不存在 at com.justep.exception.BusinessException.create(Unknown Source) at com.justep.util.Utils.check(Unknown Source) at com.justep.model.impl.ModelLoader.loadExtAttribute(Unknown Source) at com.justep.model.impl.ModelLoader.loadModel(Unknown Source) at com.justep.model.impl.ModelLoader.loadModel(Unknown Source) at com.justep.model.impl.ModelLoader.loadModel(Unknown Source) at com.justep.model.impl.ModelLoader.loadModel(Unknown Source) at com.justep.model.impl.ModelLoader.loadModel(Unknown Source) at com.justep.model.impl.ModelImpl.getModel(Unknown Source) at com.justep.model.impl.UtilImplementInstance.getModel(Unknown Source) at com.justep.model.ModelUtils.getModel(Unknown Source) at com.justep.system.data.KSQL.select(Unknown Source) at Songhuo.LoaData(Songhuo.java:30) ... 27 more

fangyeer

2017-12-15 21:21:59 加载模块：/appdemo/test/data ...
2017-12-15 21:21:59 加载模块：/appdemo/test ...
2017-12-15 21:21:59 加载模块：/appdemo ...
2017-12-15 21:21:59 excute stream action, params:{"accept":"application/json","action":"LoaData","actionFlag":"__action_0__","activity":"listActivity5","contentType":"json","executeContext":"","executor":"","process":"/songhuorenwu/songhuo/process/songhuodan/songhuodanProcess"}
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 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.Http11Processor.process(Http11Processor.java:861)
        at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:606)
        at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
        at java.lang.Thread.run(Thread.java:745)
Caused by: com.justep.exception.BusinessException: 编码: JUSTEP151058; 提示: 模块"/appdemo"不存在
        at com.justep.exception.BusinessException.create(Unknown Source)
        at com.justep.util.Utils.check(Unknown Source)
        at com.justep.model.impl.ModelLoader.loadExtAttribute(Unknown Source)
        at com.justep.model.impl.ModelLoader.loadModel(Unknown Source)
        at com.justep.model.impl.ModelLoader.loadModel(Unknown Source)
        at com.justep.model.impl.ModelLoader.loadModel(Unknown Source)
        at com.justep.model.impl.ModelLoader.loadModel(Unknown Source)
        at com.justep.model.impl.ModelLoader.loadModel(Unknown Source)
        at com.justep.model.impl.ModelImpl.getModel(Unknown Source)
        at com.justep.model.impl.UtilImplementInstance.getModel(Unknown Source)
        at com.justep.model.ModelUtils.getModel(Unknown Source)
        at com.justep.system.data.KSQL.select(Unknown Source)
        at Songhuo.LoaData(Songhuo.java:30)
        ... 27 more

fangyeer

我在action的java是这样写的
public static Table LoaData(String data1){
                 String ksql = "select SO_KHZL.*,SO_WPXQ.* from SO_KHZL SO_KHZL where SO_WPXQ.fZBID = SO_KHZL";//需要查询数据的ksql
                Table table = KSQL.select(ksql, null, "/appdemo/test/data", null);//调用平台提供的API执行sql，并返回table
                return table;
        }
}