流程怎么做判断?

shuaigej · 发表于 2016-9-28 13:40:01

本帖最后由 shuaigej 于 2016-9-28 16:12 编辑

页面是一个select，当select=a时，下一节点人为A，当select=b时，下一节点人为B

a-A
b-B
都在数据表中有对应

shuaigej · 发表于 2016-9-28 16:12:31

a-A
b-B
都在数据表中有对应

jishuang · 发表于 2016-9-28 17:11:03

参考http://bbs.wex5.com/forum.php?mo ... &extra=page%3D1

shuaigej · 发表于 2016-9-29 09:18:21

报了错：
2016-09-29 09:14:20 excute stream action, params:{"accept":"application/json","action":"externalAdvanceProcessQueryAction","actionFlag":"__action_0__","activity":"mainActivity","contentType":"application/json","executeContext":"","executor":"","parameters":{"task":"9B9192B3057648628CCC4FA615EBFDA8"},"process":"/gdms/baoxiu/process/baoxiu/baoxiuProcess"}
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: 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.invokeAction(Native Method)
at com.justep.system.action.Engine.invokeAction(Unknown Source)
at com.justep.model.impl.UtilImplementInstance.invokeAction(Unknown Source)
at com.justep.model.impl.UtilImplementInstance.invokeAction(Unknown Source)
at com.justep.system.action.ActionUtils.invokeAction(Unknown Source)
at com.justep.system.process.ProcessUtils.advanceProcessQuery(Unknown Source)
at ExternalProcessProcedure.advanceProcessQuery(ExternalProcessProcedure.java:26)
... 27 more
Caused by: com.justep.model.exception.ModelException: 编码: JUSTEP154064; 提示: 计算表达式findPersonMembersByID(null,'relationValue(''FIXMNG_MAIN'',''getProcessData1()'',null,null,''next'',''/gdms/baoxiu/data'')')出错
at com.justep.model.exception.ModelException.create(Unknown Source)
at com.justep.system.ksql.parser.ExpressionImpl.evaluate(Unknown Source)
at com.justep.system.process.ExpressEngine.calculate(Unknown Source)
at com.justep.system.process.ProcessRuleEngine.exprToOrgUnit(Unknown Source)
at com.justep.system.process.ProcessRuleEngine.executorRangeToProcessControlItem(Unknown Source)
at com.justep.system.process.ProcessRuleEngine.executeRuleToProcessControlItem(Unknown Source)
at com.justep.system.process.ProcessRuleEngine.executeRuleToProcessControl(Unknown Source)
at com.justep.system.process.ProcessQueryEngine.makeFlowIn(Unknown Source)
at com.justep.system.process.ProcessQueryEngine.makeTo(Unknown Source)
at com.justep.system.process.ProcessQueryEngine.makeTo(Unknown Source)
at com.justep.system.process.AdvanceProcessQueryEngine.doFlowOutNormal(Unknown Source)
at com.justep.system.process.AdvanceProcessQueryEngine.doFlowOut(Unknown Source)
at com.justep.system.process.AdvanceProcessQueryEngine.doExecute(Unknown Source)
at com.justep.system.process.AdvanceProcessQueryEngine.execute(Unknown Source)
at com.justep.system.process.ProcessEngine.advanceQuery(Unknown Source)
at ProcessProcedure.advanceProcessQuery(ProcessProcedure.java:338)
... 38 more
Caused by: com.justep.model.exception.ModelException: 编码: JUSTEP154075; 提示: 调用函数findPersonMembersByID出错
at com.justep.model.exception.ModelException.create(Unknown Source)
at com.justep.system.ksql.parser.ExpressionImpl.functionExpression(Unknown Source)
at com.justep.system.ksql.parser.ExpressionImpl.constExpression(Unknown Source)
at com.justep.system.ksql.parser.ExpressionImpl.unaryExpression(Unknown Source)
at com.justep.system.ksql.parser.ExpressionImpl.multiExpression(Unknown Source)
at com.justep.system.ksql.parser.ExpressionImpl.addExpression(Unknown Source)
at com.justep.system.ksql.parser.ExpressionImpl.compExpression(Unknown Source)
at com.justep.system.ksql.parser.ExpressionImpl.notExpression(Unknown Source)
at com.justep.system.ksql.parser.ExpressionImpl.andExpression(Unknown Source)
at com.justep.system.ksql.parser.ExpressionImpl.orExpression(Unknown Source)
... 53 more
Caused by: 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)
... 62 more
Caused by: com.justep.exception.BusinessException: 编码: JUSTEP150210; 提示: 执行KSQL出错, KSQL: select org.sFID, org.sFName from SA_OPOrg org where org.sValidState=1 and (org.sPersonID='relationValue('FIXMNG_MAIN','getProcessData1()',null,null,'next','/gdms/baoxiu/data')') order by org.sSequence
--> 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 com.justep.system.opm.OrgUtils.doFindOrgUnits(Unknown Source)
at com.justep.system.opm.OrgUtils.doFindPersonMembersByID(Unknown Source)
at com.justep.system.opm.OrgUtils.findPersonMembersByID(Unknown Source)
at OrgFn.findPersonMembersByID(OrgFn.java:122)
... 66 more
Caused by: com.justep.exception.KSQLException: 编码: JUSTEP154115; 提示: KSQL语法错误, relationValue('^^FIXMNG_MAIN','g中未找到需要的元素, 位置106期望是)
at com.justep.exception.KSQLException.create(Unknown Source)
at com.justep.system.ksql.token.TokenManager.matchToken(Unknown Source)
at com.justep.system.ksql.token.TokenManager.match(Unknown Source)
at com.justep.system.ksql.parser.AbstractParser.unaryExpression(Unknown Source)
at com.justep.system.ksql.parser.AbstractParser.multiExpression(Unknown Source)
at com.justep.system.ksql.parser.AbstractParser.addExpression(Unknown Source)
at com.justep.system.ksql.parser.AbstractParser.compExpression(Unknown Source)
at com.justep.system.ksql.parser.AbstractParser.notExpression(Unknown Source)
at com.justep.system.ksql.parser.AbstractParser.andExpression(Unknown Source)
at com.justep.system.ksql.parser.AbstractParser.orExpression(Unknown Source)
at com.justep.system.ksql.parser.AbstractParser.conditionExpression(Unknown Source)
at com.justep.system.ksql.parser.AbstractParser.whereExpression(Unknown Source)
at com.justep.system.ksql.parser.AbstractParser.selectSentenceNode(Unknown Source)
at com.justep.system.ksql.parser.QueryParser.start(Unknown Source)
at com.justep.system.ksql.parser.QueryParser.start(Unknown Source)
at com.justep.system.ksql.parser.AbstractParser.parse(Unknown Source)
... 74 more

执行规范里人员设置为：findPersonMembersByID(null,'relationValue(''FIXMNG_MAIN'',''getProcessData1()'',null,null,''next'',''/gdms/baoxiu/data'')')

jishuang · 发表于 2016-9-29 09:24:28

relationValue(''FIXMNG_MAIN'',''getProcessData1()'',null,null,''next'',''/gdms/baoxiu/data'')中的引号都用单引号

shuaigej · 发表于 2016-9-29 09:27:10

仍抱这个错，而且改完单引号后变成这个：无标题.png

jishuang · 发表于 2016-9-29 09:30:10

relationValue(''FIXMNG_MAIN',getProcessData1(),null,null,'next','/gdms/baoxiu/data')

jishuang · 发表于 2016-9-29 09:36:56

还有一种方案是设置执行规则，一个环节上添加多个执行规则，执行规则的生效条件中去判断字段的值，然后在执行者表达式中去获取不同的人

shuaigej · 发表于 2016-9-29 09:43:51

不需要这种，这种会把字段写死，不好。上面报错那种就符合我的需求，但是为什么会报错呢？
您7楼给的一看都不对：
relationValue(''FIXMNG_MAIN',getProcessData1(),null,null,'next','/gdms/baoxiu/data')
FIXMNG_MAIN前为什么两个分号？

jishuang · 发表于 2016-9-29 09:59:20

relationValue('FIXMNG_MAIN',getProcessData1(),null,null,'next','/gdms/baoxiu/data')

		自动登录	找回密码
密码			注册

[结贴] 流程怎么做判断?