如何把流程流转给指定的人

lwcompany

流程流转给指定的人按照http://bbs.wex5.com/forum.php?mod=viewthread&tid=49744贴子做了如下语句也不好用
relationValues('SA_OPPerson','sID','SA_OPPerson.sName=''孙总''',null,'sName','/system/data')

jishuang

表达式需要的数据类型是
List<com.justep.system.opm.OrgUnit>

而relationValue的返回类型是Object
可以自己创建一个List把数据放进行
然后用findPersonMembersByIDList就跟案例是一样的做法

lwcompany

<fn name="findPersonMembersByIDList" category="组织函数" code-model="/system/logic/code" code="OrgFn.findPersonMembersByIDList" type="List&lt;OrgUnit&gt;">
    <label language="zh_CN">根据人的ID获取人员成员</label>  
代码是依据人的ID获取人员成员，我不这个意思，我想直接打开流转页面后，显示孙总这个指定的人

jishuang

流转的时候就是给人员成员的
findPersonMembersByIDList就是根据你传的人员ID查出所有的人员成员

如果你的值返回的就是人员成员的值可以用findOrgUnitsByFID(Object fids)
根据组织单元的FID获取指定的组织单元

lwcompany

findOrgUnitsByFID(relationValues('SA_OPPerson','sID','SA_OPPerson.sName=''孙总''',null,'sName','/system/data'，
试了上面语句还是不好用

Caused by: com.justep.system.util.BizSystemException: 编码: JUSTEP180197; 提示: 任务"审批:录入资金日报表"必须指定执行者
        at com.justep.system.util.BizSystemException.create(Unknown Source)
        at com.justep.system.process.PNEngineUtils.processControlItemToTask(Unknown Source)
        at com.justep.system.process.PNEngineUtils.createActivityTask(Unknown Source)
        at com.justep.system.process.PNEngineUtils.inputActivityInstance(Unknown Source)
        at com.justep.system.process.PNEngine.inputAI(Unknown Source)
        at com.justep.system.process.PNEngine.execute(Unknown Source)
        at com.justep.system.process.StartProcessEngine.execute(Unknown Source)
        at com.justep.system.process.ProcessEngine.start(Unknown Source)
        at ProcessProcedure.startProcess(ProcessProcedure.java:148)
        ... 38 more

能远程下吗

jishuang

sID要写具体的主键值，不是主键名
'sName'不需要加引号

lwcompany

jishuang 发表于 2016-12-15 14:15
sID要写具体的主键值，不是主键名
'sName'不需要加引号

indOrgUnitsByFID(relationValues('SA_OPPerson','KtwfoLMSFL3H5Zs6mfF','SA_OPPerson.sName=''孙总''',null,'sName','/system/data'))
sname 不加引号提示非法字符还提示必须指定执行者

lwcompany

com.justep.model.exception.ModelException: 编码: JUSTEP154064; 提示: 计算表达式findOrgUnitsByFID(relationValues('SA_OPPerson','KtwfoLMSFL3H5Zs6mfF','SA_OPPerson.sCode=skj',null,'sCode','/system/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.StartProcessQueryEngine.execute(Unknown Source)
        at com.justep.system.process.ProcessEngine.startQuery(Unknown Source)
        at ProcessProcedure.startProcessQuery(ProcessProcedure.java:95)
        ... 48 more
Caused by: com.justep.model.exception.ModelException: 编码: JUSTEP154075; 提示: 调用函数findOrgUnitsByFID出错
        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)
        ... 59 more
Caused by: com.justep.model.exception.ModelException: 编码: JUSTEP154075; 提示: 调用函数relationValues出错
        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)
        ... 68 more
Caused by: java.lang.reflect.InvocationTargetException
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:606)
        ... 77 more
Caused by: com.justep.exception.BusinessException: 编码: JUSTEP150210; 提示: 执行KSQL出错, KSQL: select SA_OPPerson.sCode from SA_OPPerson SA_OPPerson  where SA_OPPerson='KtwfoLMSFL3H5Zs6mfF' and (SA_OPPerson.sCode=skj)
--> 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.util.BizUtils.getRelationValues(Unknown Source)
        at com.justep.system.util.BizUtils.getRelationValues(Unknown Source)
        at DataFn.relationValues(DataFn.java:31)
        ... 81 more
Caused by: com.justep.exception.BusinessException: 编码: JUSTEP154054; 提示: KSQL语法错误, skj找不到对应的符号描述
        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.IdentiferNode.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)
        ... 88 more

jishuang

SA_OPPerson.sCode=skj什么地方加的这个条件?

lwcompany

SA_OPPerson.sCode=skj