比较大小的两个操作数不允许为空

hailong

数值型字段比较数据大小的表达式怎么写？

审批流程条件表达式：relationValue('PR_JFSPB','getProcessData1()',null,null,'FBCSQJF_XX','/Project/approval/data')>= 10
提交时报错：
计算表达式relationValue('PR_JFSPB','getProcessData1()',null,null,'FBCSQJF_XX','/Project/approval/data')>= 10出错
编码：JUSTEP154064
隐藏详细
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; 提示: 计算表达式relationValue('PR_JFSPB','getProcessData1()',null,null,'FBCSQJF_XX','/Project/approval/data')>= 10出错 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.ExpressEngine.calculateBoolean(Unknown Source) at com.justep.system.process.ActivityEnabledEngine.unitfy(Unknown Source) at com.justep.system.process.ActivityEnabledEngine.isActiveActivity(Unknown Source) at com.justep.system.process.ActivityEnabledEngine.matchToken(Unknown Source) at com.justep.system.process.ActivityEnabledEngine.execute(Unknown Source) at com.justep.system.process.ProcessQueryEngine.activityCanActive(Unknown Source) at com.justep.system.process.ProcessQueryEngine.outPlace(Unknown Source) at com.justep.system.process.ProcessQueryEngine.outActivityInstance(Unknown Source) at com.justep.system.process.ProcessQueryEngine.outPlace(Unknown Source) at com.justep.system.process.ProcessQueryEngine.outActivityInstance(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:343) ... 38 more Caused by: com.justep.exception.BusinessException: 编码: JUSTEP154086; 提示: 比较大小的两个操作数不允许为空 at com.justep.exception.BusinessException.create(Unknown Source) at com.justep.util.Utils.check(Unknown Source) at com.justep.system.ksql.parser.ExpUtils.compare(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) ... 55 more

hailong

not(relationValue('PR_JFSPB','getProcessData1()',null,null,'FBCSQJF_XX','/Project/approval/data') = null) and relationValue('PR_JFSPB','getProcessData1()',null,null,'FBCSQJF_XX','/Project/approval/data')>=10
这么写到是不报错，但是比较大小判断的不对,不论大于小于结果都一样。

zpfmty

先判断一下：relationValue('PR_JFSPB','getProcessData1()',null,null,'FBCSQJF_XX','/Project/approval/data')，如果为空则置为0（整型或浮点型），再同10进行比较。