报表获取ID信息

暗夜的忧伤

楼上是sqlaction的形式；
使用ksqlaction 只要在编辑器写入where 字段=:传入的参数名称 就可以了

wangxiaoyu

暗夜的忧伤 发表于 2014-6-27 14:16
楼上是sqlaction的形式；
使用ksqlaction只要在编辑器写入where 字段=:传入的参数名称 就可以了
...

我试了你的方法，但是控制台报错：
<action direct-execute="true" process="/LsCityBuilding/ProjectInfoManage/process/ConstructionProject1/constructionProject1Process" activity="billsActivity" action-flag="__action_0__" executor="" execute-context="" name="LXAction2"><parameters xmlns:xbiz="http://www.justep.com/xbiz#"><parameter name="variables"/></parameters></action>
java.lang.reflect.InvocationTargetException
        at sun.reflect.GeneratedMethodAccessor233.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:592)
        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.BusinessServerServlet.execService(Unknown Source)
        at com.justep.business.server.BusinessServerServlet.service(Unknown Source)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
        at com.justep.x.bs.BusinessServerServlet.service(Unknown Source)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
        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:102)
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
        at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:857)
        at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)
        at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
        at java.lang.Thread.run(Thread.java:595)
Caused by: com.justep.exception.BusinessException: 编码: JUSTEP150210; 提示: 执行KSQL出错, KSQL: select PartProjectInfo.*,PartProject.*,ProjectBills.* from PartProjectInfo PartProjectInfo  optional  join PartProject PartProject on PartProjectInfo.partID = PartProject optional  join ProjectBills ProjectBills on PartProjectInfo.ProjectBillsID = ProjectBills where PartProjectInfo.ProjectBillsID = :id
        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 KSQLProcedure.query(KSQLProcedure.java:20)
        ... 25 more
Caused by: com.justep.exception.BusinessException: 编码: JUSTEP154150; 提示: 找不到变量id对应的值
        at com.justep.exception.BusinessException.create(Unknown Source)
        at com.justep.util.Utils.check(Unknown Source)
        at com.justep.system.ksql.visitor.SQLVisitor.visit(Unknown Source)
        at com.justep.system.ksql.node.VariableNode.accept(Unknown Source)
        at com.justep.system.ksql.visitor.SQLVisitor.visitChildren(Unknown Source)
        at com.justep.system.ksql.visitor.SQLVisitor.visit(Unknown Source)
        at com.justep.system.ksql.node.CompExpressionNode.accept(Unknown Source)
        at com.justep.system.ksql.visitor.SQLVisitor.visitChildren(Unknown Source)
        at com.justep.system.ksql.visitor.SQLVisitor.visit(Unknown Source)
        at com.justep.system.ksql.node.WhereNode.accept(Unknown Source)
        at com.justep.system.ksql.visitor.SQLVisitor.visitChildren(Unknown Source)
        at com.justep.system.ksql.visitor.SQLVisitor.visit(Unknown Source)
        at com.justep.system.ksql.node.SelectSentenceNode.accept(Unknown Source)
        at com.justep.system.ksql.visitor.SQLVisitor.visitChildren(Unknown Source)
        at com.justep.system.ksql.visitor.QueryVisitor.visit(Unknown Source)
        at com.justep.system.ksql.node.QuerySentence.accept(Unknown Source)
        ... 30 more
[ERROR] 2014-06-27 16:29:38,051 com.justep.report.controller.DataController - 报表数据获取失败
执行KSQL出错, KSQL: select PartProjectInfo.*,PartProject.*,ProjectBills.* from PartProjectInfo PartProjectInfo  optional  join PartProject PartProject on PartProjectInfo.partID = PartProject optional  join ProjectBills ProjectBills on PartProjectInfo.ProjectBillsID = ProjectBills where PartProjectInfo.ProjectBillsID = :id
com.justep.report.exception.ReportServerException: 报表数据获取失败
        at com.justep.report.controller.DataController.execute(Unknown Source)
        at com.justep.report.controller.GenericControllerChain.execute(Unknown Source)
        at com.justep.report.controller.InitController.execute(Unknown Source)
        at com.justep.report.controller.GenericControllerChain.execute(Unknown Source)
        at com.justep.report.Servlet.a(Unknown Source)
        at com.justep.report.Servlet.doPost(Unknown Source)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
        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:102)
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
        at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:857)
        at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)
        at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
        at java.lang.Thread.run(Thread.java:595)
Caused by: com.justep.report.exception.ReportServerException: 执行KSQL出错, KSQL: select PartProjectInfo.*,PartProject.*,ProjectBills.* from PartProjectInfo PartProjectInfo  optional  join PartProject PartProject on PartProjectInfo.partID = PartProject optional  join ProjectBills ProjectBills on PartProjectInfo.ProjectBillsID = ProjectBills where PartProjectInfo.ProjectBillsID = :id
        at com.justep.report.controller.DataController.a(Unknown Source)
        at com.justep.report.controller.DataController.a(Unknown Source)
        ... 20 more
Caused by: java.lang.Exception
        ... 22 more

暗夜的忧伤

wangxiaoyu 发表于 2014-6-27 16:29
我试了你的方法，但是控制台报错：

java.lang.reflect.InvocationTargetException

没有加变量名为id的变量，设计界面加上

wangxiaoyu

暗夜的忧伤 发表于 2014-6-27 16:40
没有加变量名为id的变量，设计界面加上

var projectBillsID = event.data.id;
        justep.xbl('ds1').setStringVar('id',projectBillsID);
       // alert(projectBillsID);
        
        justep.xbl('gridReport').refresh();


已经写了产给id，并且ksql中where中也写了.......=:id;现在可以实现就是双击grid行，跳转到报表页面，显示出当前行数据 的那个了，虽然页面上是实现成功了，但是控制台却报错。。。。。。。

暗夜的忧伤

wangxiaoyu 发表于 2014-6-27 17:11
var projectBillsID = event.data.id;
        justep.xbl('ds1').setStringVar('id',projectBillsID);
  ...

错误信息？

wangxiaoyu

暗夜的忧伤 发表于 2014-6-27 17:28
错误信息？

对呀，页面可以根据ID出现数据了，控制台就报错啦。

wangxiaoyu

暗夜的忧伤 发表于 2014-6-27 17:28
错误信息？

错误信息如下：
2014-06-27 17:30:35 开始-WINDOW生成中间文件: /UI/LsCityBuilding/ProjectInfoManage/process/ConstructionProject1/jihuaActivity.w
2014-06-27 17:30:35 结束-WINDOW生成中间文件: /UI/LsCityBuilding/ProjectInfoManage/process/ConstructionProject1/jihuaActivity.w
2014-06-27 17:30:35 开始-中间文件生成缓存文件: /UI/LsCityBuilding/ProjectInfoManage/process/ConstructionProject1/jihuaActivity.w
2014-06-27 17:30:35 结束-中间文件生成缓存文件: /UI/LsCityBuilding/ProjectInfoManage/process/ConstructionProject1/jihuaActivity.w
select ProjectBills.*,ProjectInfo.* from ProjectBills ProjectBills  optional  join ProjectInfo ProjectInfo on ProjectBills.projectID = ProjectInfo where ProjectInfo.changjianFabao = '承建' AND ProjectBills = :id2014-06-27 17:30:36 action:<?xml version="1.0" encoding="UTF-8"?>
<action direct-execute="true" process="/LsCityBuilding/ProjectInfoManage/process/ConstructionProject1/constructionProject1Process" activity="billsActivity" action-flag="__action_0__" executor="" execute-context="" name="LXAction1"><parameters xmlns:xbiz="http://www.justep.com/xbiz#"><parameter name="variables"/></parameters></action>
java.lang.reflect.InvocationTargetException
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:592)
        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.BusinessServerServlet.execService(Unknown Source)
        at com.justep.business.server.BusinessServerServlet.service(Unknown Source)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
        at com.justep.x.bs.BusinessServerServlet.service(Unknown Source)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
        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:102)
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
        at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:857)
        at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)
        at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
        at java.lang.Thread.run(Thread.java:595)
Caused by: com.justep.exception.BusinessException: 编码: JUSTEP150210; 提示: 执行KSQL出错, KSQL: select ProjectBills.*,ProjectInfo.* from ProjectBills ProjectBills  optional  join ProjectInfo ProjectInfo on ProjectBills.projectID = ProjectInfo where ProjectInfo.changjianFabao = '承建' AND ProjectBills = :id
        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 KSQLProcedure.query(KSQLProcedure.java:21)
        ... 26 more
Caused by: com.justep.exception.BusinessException: 编码: JUSTEP154150; 提示: 找不到变量id对应的值
        at com.justep.exception.BusinessException.create(Unknown Source)
        at com.justep.util.Utils.check(Unknown Source)
        at com.justep.system.ksql.visitor.SQLVisitor.visit(Unknown Source)
        at com.justep.system.ksql.node.VariableNode.accept(Unknown Source)
        at com.justep.system.ksql.visitor.SQLVisitor.visitChildren(Unknown Source)
        at com.justep.system.ksql.visitor.SQLVisitor.visit(Unknown Source)
        at com.justep.system.ksql.node.CompExpressionNode.accept(Unknown Source)
        at com.justep.system.ksql.visitor.SQLVisitor.visitChildren(Unknown Source)
        at com.justep.system.ksql.visitor.SQLVisitor.visit(Unknown Source)
        at com.justep.system.ksql.node.LogicalExpressionNode.accept(Unknown Source)
        at com.justep.system.ksql.visitor.SQLVisitor.visitChildren(Unknown Source)
        at com.justep.system.ksql.visitor.SQLVisitor.visit(Unknown Source)
        at com.justep.system.ksql.node.WhereNode.accept(Unknown Source)
        at com.justep.system.ksql.visitor.SQLVisitor.visitChildren(Unknown Source)
        at com.justep.system.ksql.visitor.SQLVisitor.visit(Unknown Source)
        at com.justep.system.ksql.node.SelectSentenceNode.accept(Unknown Source)
        at com.justep.system.ksql.visitor.SQLVisitor.visitChildren(Unknown Source)
        at com.justep.system.ksql.visitor.QueryVisitor.visit(Unknown Source)
        at com.justep.system.ksql.node.QuerySentence.accept(Unknown Source)
        ... 31 more
[ERROR] 2014-06-27 17:30:36,229 com.justep.report.controller.DataController - 报表数据获取失败
执行KSQL出错, KSQL: select ProjectBills.*,ProjectInfo.* from ProjectBills ProjectBills  optional  join ProjectInfo ProjectInfo on ProjectBills.projectID = ProjectInfo where ProjectInfo.changjianFabao = '承建' AND ProjectBills = :id
com.justep.report.exception.ReportServerException: 报表数据获取失败
        at com.justep.report.controller.DataController.execute(Unknown Source)
        at com.justep.report.controller.GenericControllerChain.execute(Unknown Source)
        at com.justep.report.controller.InitController.execute(Unknown Source)
        at com.justep.report.controller.GenericControllerChain.execute(Unknown Source)
        at com.justep.report.Servlet.a(Unknown Source)
        at com.justep.report.Servlet.doPost(Unknown Source)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
        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:102)
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
        at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:857)
        at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)
        at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
        at java.lang.Thread.run(Thread.java:595)
Caused by: com.justep.report.exception.ReportServerException: 执行KSQL出错, KSQL: select ProjectBills.*,ProjectInfo.* from ProjectBills ProjectBills  optional  join ProjectInfo ProjectInfo on ProjectBills.projectID = ProjectInfo where ProjectInfo.changjianFabao = '承建' AND ProjectBills = :id
        at com.justep.report.controller.DataController.a(Unknown Source)
        at com.justep.report.controller.DataController.a(Unknown Source)
        ... 20 more
Caused by: java.lang.Exception
        ... 22 more
select ProjectBills.*,ProjectInfo.* from ProjectBills ProjectBills  optional  join ProjectInfo ProjectInfo on ProjectBills.projectID = ProjectInfo where ProjectInfo.changjianFabao = '承建' AND ProjectBills = :idselect PartProjectInfo.*,PartProject.*,ProjectBills.* from PartProjectInfo PartProjectInfo  optional  join PartProject PartProject on PartProjectInfo.partID = PartProject optional  join ProjectBills ProjectBills on PartProjectInfo.ProjectBillsID = ProjectBills

whao410

明明ksql执行错误了啊，得不到id的值，怎么会呢？还能正常显示？

暗夜的忧伤

这里面 添加id的定义了吗？

whao410

支持楼上，估计....