规则里有多人时，表达式方式。

zyygod · 发表于 2018-8-13 15:43:25

本帖最后由 zyygod 于 2018-8-13 15:48 编辑

比如通知多个人时，表达式或者范围表达式应该给定什么样的格式。一个list集合里面用空格隔开吗？[张三李四王五 ]，是这种格式吗？还是有其他的格式，具体表现形式是什么。

jishuang · 发表于 2018-8-13 16:12:53

自己调用list的add添加数据就是需要的格式

zyygod · 发表于 2018-8-13 16:23:22

本帖最后由 zyygod 于 2018-8-13 16:26 编辑

jishuang 发表于 2018-8-13 16:12
自己调用list的add添加数据就是需要的格式

编码: JUSTEP180226; 提示: 表达式"personFn(relationValue('QXJJBXXB',null,'QXJJBXXB.YWH = :getProcessData2()',null,'XJYWH','/app/business/oa/holidayManager/backleave/data'))"计算的结果不是组织单元列表。

[姚智, 王思宇, 陈健（办）]这是我list add进去后取到的值。。

jishuang · 发表于 2018-8-13 16:38:23

List<OrgUnit>的

list中的要是OrgUnit的才可以

zyygod · 发表于 2018-8-13 16:54:12

本帖最后由 zyygod 于 2018-8-13 17:10 编辑

jishuang 发表于 2018-8-13 16:38
List的

list中的要是OrgUnit的才可以

findPersonMembersByIDList(personFn(relationValue('QXJJBXXB',null,'QXJJBXXB.YWH = :getProcessData2()',null,'XJYWH','/app/business/oa/holidayManager/backleave/data')))

[28099750D35A43358A7A2DE989191604, 231A63A95724482F82051BBD5F6931F2, EB0547E0C3B04CD882BDE3B47022000B]list<String>取到的值
[, [28099750D35A43358A7A2DE989191604, , 231A63A95724482F82051BBD5F6931F2, , EB0547E0C3B04CD882BDE3B47022000B]]List<List<String>>取到的值

结果是不报错了，但是没有取到值。

public static List<List<String>> personFn(String XJYWH) {
List<List<String>> list1 = new ArrayList<List<String>>();
List<String> list3 = new ArrayList<String>();
System.out.println(XJYWH);
String sql = "Select a.PERSONID from SPQKB a where a.YWH ='" + XJYWH + "' ";
System.out.println(sql+"12312312312312312");
Table table = SQL.select(sql, null, "/app/business/oa/holidayManager/backleave/data", null);
Iterator<Row> rows = table.iterator();
List<String> list2 = new ArrayList<String>();
while (rows.hasNext()) {
Row row = rows.next();
list2.add(row.getString("PERSONID"));
};
System.out.println(list2);
String[] strArray = list2.toArray(new String[list2.size()]);
String strArrays = Arrays.toString(strArray) ;
String[] per = strArrays.split(",");
for (int i = 0; i < per.length; i++) {
list3.add("");
list3.add(per[i]);
list1.add(list3);
}
System.out.println(list3);
return list1;
};

复制代码

jishuang · 发表于 2018-8-13 17:25:32

http://bbs.wex5.com/forum.php?mo ... 4&pid=165004035把sql语句到出来，看看输出的sql中用这些值做条件查询的sql是什么

zyygod · 发表于 2018-8-14 08:42:39

jishuang 发表于 2018-8-13 17:25
http://bbs.wex5.com/forum.php?mod=redirect&goto=findpost&ptid=33524&pid=165004035把sql语句到出来，看 ...

两个问题。一、查人员的表是哪张表。二、我用的是findPersonMembersByIDList，控制台打印出来的结果是
[, [28099750D35A43358A7A2DE989191604, , 231A63A95724482F82051BBD5F6931F2, , EB0547E0C3B04CD882BDE3B47022000B]]。这样符合findPersonMembersByIDList的要求吗？

jishuang · 发表于 2018-8-14 08:55:53

1.这个不是一个简单的只查人员表的sql，是关联查询的，参考我前面发的输出sql就能看到

2.执行sql语句是打出来的这个？

zyygod · 发表于 2018-8-14 09:59:51

jishuang 发表于 2018-8-14 08:55
1.这个不是一个简单的只查人员表的sql，是关联查询的，参考我前面发的输出sql就能看到

2.执行sql语句是打 ...

Select a.PERSONID from SPQKB a where a.YWH ='201807310385'
2018-08-14 09:59:31 excute stream action, params:{"accept":"application/json","action":"externalAdvanceProcessQueryAction","actionFlag":"__action_0__","activity":"backleaveActivity","contentType":"application/json","executeContext":"","executor":"","parameters":{"task":"D958C429361A4EBD839277CD4EC096EB"},"process":"/app/business/oa/holidayManager/backleave/process/backleave/backleaveProcess"}
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 com.justep.micro.service.MicroServiceFilter.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: 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)
... 30 more
Caused by: com.justep.model.exception.ModelException: 编码: JUSTEP154064; 提示: 计算表达式findPersonMembersByIDList(personFn(relationValue('QXJJBXXB',null,'QXJJBXXB.YWH = :getProcessData2()',null,'XJYWH','/app/business/oa/holidayManager/backleave/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.noticeRuleToProcessControlItem(Unknown Source)
at com.justep.system.process.ProcessRuleEngine.processNoticeRuleToProcessControl(Unknown Source)
at com.justep.system.process.ProcessQueryEngine.makeProcessNotice(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)
... 41 more
Caused by: com.justep.model.exception.ModelException: 编码: JUSTEP154075; 提示: 调用函数findPersonMembersByIDList出错
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)
... 51 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)
... 60 more
Caused by: java.lang.IndexOutOfBoundsException: Index: 1, Size: 1
at java.util.ArrayList.rangeCheck(ArrayList.java:653)
at java.util.ArrayList.get(ArrayList.java:429)
at com.justep.system.opm.OrgUtils.doFindPersonMembersByID(Unknown Source)
at com.justep.system.opm.OrgUtils.findPersonMembersByIDList(Unknown Source)
at OrgFn.findPersonMembersByIDList(OrgFn.java:137)
... 64 more

复制代码

public static List<List<String>> personFn(String XJYWH) {
try {
String sql = "Select a.PERSONID from SPQKB a where a.YWH ='" + XJYWH + "' ";
System.out.println(sql);
Table table = SQL.select(sql, null, "/app/business/oa/holidayManager/backleave/data", null);
Iterator<Row> rows = table.iterator();
List<List<String>> list1 = new ArrayList<List<String>>();
while (rows.hasNext()) {
Row row = rows.next();
List<String> list2 = new ArrayList<String>();
list2.add(row.getString("PERSONID"));
list1.add(list2);
};
return list1;
} catch (Exception e) {
e.printStackTrace();
return null;
}

复制代码

这是什么错，怎么这么多unknowsource..上面是sql以及报的错，下面是java代码

jishuang · 发表于 2018-8-14 10:04:15

java.lang.IndexOutOfBoundsException: Index: 1, Size: 1
findPersonMembersByIDList传的参数不正确
往list找那个放的时候自己判断是否有值，没值就不要add加到list中

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

[处理中3] 规则里有多人时，表达式方式。