下拉框级联

wjl1995

  如何给单个下拉框配置数据源，我需要不让列的数据出现重复，distinct又不能接多个列,我在想做两个数据源时一直出错，data[Sb_Renwufx]的idColumn[SB_RENWUFX]没有在select部分定义
获取到选中的下拉框的值如何给另一个下拉框绑定数据，我也还没解决，希望有大神能帮帮忙，万分感谢

jishuang

用两个bizData,关联不同的queryAction

gridselect做级联下拉可以参考http://docs.wex5.com/bex5-ui-question-list-10094/

https://pan.baidu.com/s/1cxHxro#list/path=%2F的第6章6.3小节也有级联下拉的介绍

wjl1995

2017-04-26 18:46:57 编码: JUSTEP001008; 提示: data[Sb_ResultZkkh]的idColumn[SB_RENWUFX]没有在select部分定义
javax.servlet.ServletException: com.justep.xbl.runtime.XBLException: 编码: JUSTEP001008; 提示: data[Sb_ResultZkkh]的idColumn[SB_RENWUFX]没有在select部分定义
        at com.justep.ui.servlet.MainServlet.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.portal.filter.RedirectFilter.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.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.xbl.runtime.XBLException: 编码: JUSTEP001008; 提示: data[Sb_ResultZkkh]的idColumn[SB_RENWUFX]没有在select部分定义
        at com.justep.xbl.runtime.XBLException.create(Unknown Source)
        at com.justep.ui2.system.component.data.bizdata.BizDataDef.getIdColumn(Unknown Source)
        at BizData.getColDef(BizData.java:213)
        at BizData.processDataConfig(BizData.java:80)
        at Data.processData(Data.java:65)
        at Data.execute(Data.java:42)
        at com.justep.ui.component.ComponentEngine.processServerTemplate(Unknown Source)
        at com.justep.ui.component.ComponentEngine.parser(Unknown Source)
        at com.justep.ui.component.ComponentEngine.parser(Unknown Source)
        at com.justep.ui.component.ComponentEngine.parser(Unknown Source)
        at com.justep.ui.component.ComponentEngine.execute(Unknown Source)
        at com.justep.ui.WindowCompiler2.w2Middle(Unknown Source)
        at com.justep.ui.WindowCompiler2.compile(Unknown Source)
        at com.justep.ui.WindowServer2.compileWindow(Unknown Source)
        at com.justep.ui.WindowServer2.service(Unknown Source)
        ... 17 more
2017-04-26 18:46:57 开始-WINDOW生成中间文件: /UI2/SA/task/taskView/submitActivity.w
四月 26, 2017 6:46:57 下午 org.apache.catalina.core.StandardWrapperValve invoke
严重: Servlet.service() for servlet main-servlet threw exception
com.justep.xbl.runtime.XBLException: 编码: JUSTEP001008; 提示: data[Sb_ResultZkkh]的idColumn[SB_RENWUFX]没有在select部分定义
        at com.justep.xbl.runtime.XBLException.create(Unknown Source)
        at com.justep.ui2.system.component.data.bizdata.BizDataDef.getIdColumn(Unknown Source)
        at BizData.getColDef(BizData.java:213)
        at BizData.processDataConfig(BizData.java:80)
        at Data.processData(Data.java:65)
        at Data.execute(Data.java:42)
        at com.justep.ui.component.ComponentEngine.processServerTemplate(Unknown Source)
        at com.justep.ui.component.ComponentEngine.parser(Unknown Source)
        at com.justep.ui.component.ComponentEngine.parser(Unknown Source)
        at com.justep.ui.component.ComponentEngine.parser(Unknown Source)
        at com.justep.ui.component.ComponentEngine.execute(Unknown Source)
        at com.justep.ui.WindowCompiler2.w2Middle(Unknown Source)
        at com.justep.ui.WindowCompiler2.compile(Unknown Source)
        at com.justep.ui.WindowServer2.compileWindow(Unknown Source)
        at com.justep.ui.WindowServer2.service(Unknown Source)
        at com.justep.ui.servlet.MainServlet.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.portal.filter.RedirectFilter.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.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)

jishuang

data[Sb_ResultZkkh]的idColumn[SB_RENWUFX]没有在select部分定义

data关联的queryAction怎么定义的？

wjl1995

queryaction的select里面就是这个select distinct SB_RENWUFX.JIANCEZB as JIANCEZB
    from SB_RENWUFX SB_RENWUFX

jishuang

queryAction上的idColumns设置的是JIANCEZB吗？

wjl1995

解决了，就是你说的这个属性之前没有去设置过

wjl1995

下拉框的默认值怎么给它设置为空啊，我的一直默认拿到第一行，就算显示是空白的，用data.getvalue("");获取值总是第一行的，怎么解决啊

jishuang

把下拉区域关联的data的autoLoad设置为false

wjl1995

谢谢