执行人只能选择自己

叫我银垚就好了

我在执行规则里面的表达式中写findOrgUnitsHasCActivity，或者写findOrgUnitsHasCActivityInACDept('ALL',false)的情况下，有些人的流转确认框中选择信息只能选中他自己，但是有些人的流转确认框中又能选中我配置的的人员。

不知道怎么回事。

配置截图：

有问题的截图：

没问题的截图：


是不是数据库中的信息需要修改？修改那个？

叫我银垚就好了

有问题的是正式服代码，没问题的是测试服代码。两个服务器中的数据不太一样，所以我怀疑是不是数据库中记录了信息，导致只能选自己。

jishuang

http://bbs.wex5.com/forum.php?mo ... 4&pid=165641741

叫我银垚就好了

jishuang 发表于 2025-2-18 09:12
http://bbs.wex5.com/forum.php?mod=redirect&goto=findpost&ptid=214964&pid=165641741

1、测试服链接正式服的数据库尝试了一下
2、使用您在帖子中发的classes文件并重启了

以上这两种方式都不行，这个人员总是只能选择自己，而不能选择拥有权限的人。

叫我银垚就好了

叫我银垚就好了 发表于 2025-2-18 09:57
1、测试服链接正式服的数据库尝试了一下
2、使用您在帖子中发的classes文件并重启了

正式服版本3.7，测试服版本3.8。

叫我银垚就好了

2025-02-18 10:26:03 [SQL Time]sql 执行时间：21ms, exec KSQL: select customGroup as sID, customGroup.sName, customGroup.sTypeID, customGroup.sSequence         from SA_OPCustomGroup customGroup                 optional join SA_ResourceControl range1                         on range1.sTypeID = 'customGroup_range' and range1.sResourceID = customGroup         where ((customGroup.sTypeID = 'private' and customGroup.sCreatorID = :currentPersonID())                         or (customGroup.sTypeID = 'public' and (range1 is null or (((((range1.sOrgFID = '/XZIfeGZE1P1Y96hYX72.ogn/6wTkAiGKBS4sxcwrIm6.dpt/RRG11WqkeuG11sl6OpK.pos/uqQDhEtp13MDzhgmpKg@RRG11WqkeuG11sl6OpK.psm'))or(range1.sOrgFID = '/XZIfeGZE1P1Y96hYX72.ogn/6wTkAiGKBS4sxcwrIm6.dpt/RRG11WqkeuG11sl6OpK.pos'))or(range1.sOrgFID = '/XZIfeGZE1P1Y96hYX72.ogn/6wTkAiGKBS4sxcwrIm6.dpt'))or(range1.sOrgFID = '/XZIfeGZE1P1Y96hYX72.ogn')))))         group by customGroup, customGroup.sName, customGroup.sTypeID, customGroup.sSequence         order by customGroup.sTypeID, customGroup.sSequence
  --> sql:SELECT  customGroup.sID AS sID, customGroup.SNAME AS sName, customGroup.STYPEID AS sTypeID, customGroup.SSEQUENCE AS sSequence FROM SA_OPCustomGroup customGroup LEFT JOIN SA_ResourceControl range1 ON  (range1.STYPEID = ?) AND (range1.sResourceID = customGroup.sID)   WHERE  ( (customGroup.STYPEID = ?) AND (customGroup.SCREATORID =  ? ) ) OR ( (customGroup.STYPEID = ?) AND ( (range1.sID IS NULL) OR ( ( ( (range1.SORGFID = ?) OR (range1.SORGFID = ?) ) OR (range1.SORGFID = ?) ) OR (range1.SORGFID = ?) ) ) )    GROUP BY customGroup.sID, customGroup.SNAME, customGroup.STYPEID, customGroup.SSEQUENCE  ORDER BY customGroup.STYPEID ASC, customGroup.SSEQUENCE ASC
--> binds:[customGroup_range, private, uqQDhEtp13MDzhgmpKg, public, /XZIfeGZE1P1Y96hYX72.ogn/6wTkAiGKBS4sxcwrIm6.dpt/RRG11WqkeuG11sl6OpK.pos/uqQDhEtp13MDzhgmpKg@RRG11WqkeuG11sl6OpK.psm, /XZIfeGZE1P1Y96hYX72.ogn/6wTkAiGKBS4sxcwrIm6.dpt/RRG11WqkeuG11sl6OpK.pos, /XZIfeGZE1P1Y96hYX72.ogn/6wTkAiGKBS4sxcwrIm6.dpt, /XZIfeGZE1P1Y96hYX72.ogn]
2025-02-18 10:26:03 [SQL Time]sql 执行时间：26ms, exec KSQL: SELECT SA_OPOrg.*, member1.sResourceID as groupID, member1 as memberID   FROM SA_OPOrg SA_OPOrg join SA_ResourceControl member1 on SA_OPOrg.sFID = member1.sOrgFID  and member1.sTypeID = 'customGroup_member'         and member1.sResourceID in ('') WHERE (SA_OPOrg.sValidState >= 0) AND ((SA_OPOrg.sValidState=1)) ORDER BY SA_OPOrg.sSequence asc LIMIT 0, -1
  --> sql:SELECT  SA_OPOrg.sID AS SA_OPOrg, SA_OPOrg.SNAME AS sName, SA_OPOrg.SCODE AS sCode, SA_OPOrg.SLONGNAME AS sLongName, SA_OPOrg.sFName AS sFName, SA_OPOrg.SFCODE AS sFCode, SA_OPOrg.sFID AS sFID, SA_OPOrg.SORGKINDID AS sOrgKindID, SA_OPOrg.SSEQUENCE AS sSequence, SA_OPOrg.SVALIDSTATE AS sValidState, SA_OPOrg.sParent AS sParent, SA_OPOrg.SLEVEL AS sLevel, SA_OPOrg.SPHONE AS sPhone, SA_OPOrg.SFAX AS sFax, SA_OPOrg.SADDRESS AS sAddress, SA_OPOrg.SZIP AS sZip, SA_OPOrg.SDESCRIPTION AS sDescription, SA_OPOrg.SPERSONID AS sPersonID, SA_OPOrg.SNODEKIND AS sNodeKind, SA_OPOrg.SWXDEPTID AS sWxDeptID, SA_OPOrg.VERSION AS version, member1.sResourceID AS groupID, member1.sID AS memberID FROM SA_OPOrg SA_OPOrg JOIN SA_ResourceControl member1 ON  (SA_OPOrg.sFID = member1.SORGFID) AND (member1.STYPEID = ?) AND ( member1.sResourceID IN (?) )   WHERE  (SA_OPOrg.SVALIDSTATE >= ?) AND (SA_OPOrg.SVALIDSTATE = ?)   ORDER BY SA_OPOrg.SSEQUENCE ASC
--> binds:[customGroup_member, , 0, 1]

这是执行的查询sql，好像是只查了一个人的信息。

jishuang

如果测试环境连正式的数据库都没问题，那说明是可能是版本差异，把正式的升级到3.8或者3.9版本

可以把两个环境的sql语句打出来看看http://bbs.wex5.com/forum.php?mo ... 4&pid=165004035

叫我银垚就好了

应该不是版本的问题，换了版本也是一样的问题。
这是正式服的查询语句：
SELECT  customGroup.sID AS sID, customGroup.SNAME AS sName, customGroup.STYPEID AS sTypeID, customGroup.SSEQUENCE AS sSequence
FROM SA_OPCustomGroup customGroup
LEFT JOIN SA_ResourceControl range1 ON  (range1.STYPEID = ?)
AND (range1.sResourceID = customGroup.sID)WHERE  ( (customGroup.STYPEID = ?)
        AND (customGroup.SCREATORID =  ? ) )OR ( (customGroup.STYPEID = ?)
        AND ( (range1.sID IS NULL) OR ( ( ( (range1.SORGFID = ?) OR (range1.SORGFID = ?) ) OR (range1.SORGFID = ?) ) OR (range1.SORGFID = ?) ) ) )   
        GROUP BY customGroup.sID, customGroup.SNAME, customGroup.STYPEID, customGroup.SSEQUENCE  ORDER BY customGroup.STYPEID ASC, customGroup.SSEQUENCE ASC
--> binds:[customGroup_range, private, uqQDhEtp13MDzhgmpKg, public, /XZIfeGZE1P1Y96hYX72.ogn/6wTkAiGKBS4sxcwrIm6.dpt/RRG11WqkeuG11sl6OpK.pos/uqQDhEtp13MDzhgmpKg@RRG11WqkeuG11sl6OpK.psm, /XZIfeGZE1P1Y96hYX72.ogn/6wTkAiGKBS4sxcwrIm6.dpt/RRG11WqkeuG11sl6OpK.pos, /XZIfeGZE1P1Y96hYX72.ogn/6wTkAiGKBS4sxcwrIm6.dpt, /XZIfeGZE1P1Y96hYX72.ogn]
SELECT  SA_OPOrg.sID AS SA_OPOrg, SA_OPOrg.SNAME AS sName, SA_OPOrg.SCODE AS sCode, SA_OPOrg.SLONGNAME AS sLongName, SA_OPOrg.sFName AS sFName, SA_OPOrg.SFCODE AS sFCode, SA_OPOrg.sFID AS sFID, SA_OPOrg.SORGKINDID AS sOrgKindID, SA_OPOrg.SSEQUENCE AS sSequence, SA_OPOrg.SVALIDSTATE AS sValidState, SA_OPOrg.sParent AS sParent, SA_OPOrg.SLEVEL AS sLevel, SA_OPOrg.SPHONE AS sPhone, SA_OPOrg.SFAX AS sFax, SA_OPOrg.SADDRESS AS sAddress, SA_OPOrg.SZIP AS sZip, SA_OPOrg.SDESCRIPTION AS sDescription, SA_OPOrg.SPERSONID AS sPersonID, SA_OPOrg.SNODEKIND AS sNodeKind, SA_OPOrg.SWXDEPTID AS sWxDeptID, SA_OPOrg.VERSION AS version, member1.sResourceID AS groupID, member1.sID AS memberID
FROM SA_OPOrg SA_OPOrg
JOIN SA_ResourceControl member1 ON  (SA_OPOrg.sFID = member1.SORGFID) AND (member1.STYPEID = ?) AND ( member1.sResourceID IN (?) )   
WHERE  (SA_OPOrg.SVALIDSTATE >= ?) AND (SA_OPOrg.SVALIDSTATE = ?)   ORDER BY SA_OPOrg.SSEQUENCE ASC
--> binds:[customGroup_member, , 0, 1]

这是测试服的查询语句：
SELECT  customGroup.sID AS sID, customGroup.SNAME AS sName, customGroup.STYPEID AS sTypeID, customGroup.SSEQUENCE AS sSequence
FROM SA_OPCustomGroup customGroup
LEFT JOIN SA_ResourceControl range1 ON  (range1.STYPEID = ?)
AND (range1.sResourceID = customGroup.sID)   WHERE  ( (customGroup.STYPEID = ?)
        AND (customGroup.SCREATORID =  ? ) ) OR ( (customGroup.STYPEID = ?)
        AND ( (range1.sID IS NULL) OR ( ( ( (range1.SORGFID = ?) OR (range1.SORGFID = ?) ) OR (range1.SORGFID = ?) ) OR (range1.SORGFID = ?) ) ) )   
        GROUP BY customGroup.sID, customGroup.SNAME, customGroup.STYPEID, customGroup.SSEQUENCE  ORDER BY customGroup.STYPEID ASC, customGroup.SSEQUENCE ASC
--> binds:[customGroup_range, private, uqQDhEtp13MDzhgmpKg, public, /XZIfeGZE1P1Y96hYX72.ogn/6wTkAiGKBS4sxcwrIm6.dpt/RRG11WqkeuG11sl6OpK.pos/uqQDhEtp13MDzhgmpKg@RRG11WqkeuG11sl6OpK.psm, /XZIfeGZE1P1Y96hYX72.ogn/6wTkAiGKBS4sxcwrIm6.dpt/RRG11WqkeuG11sl6OpK.pos, /XZIfeGZE1P1Y96hYX72.ogn/6wTkAiGKBS4sxcwrIm6.dpt, /XZIfeGZE1P1Y96hYX72.ogn]
SELECT  SA_OPOrg.sID AS SA_OPOrg, SA_OPOrg.SNAME AS sName, SA_OPOrg.SCODE AS sCode, SA_OPOrg.SLONGNAME AS sLongName, SA_OPOrg.sFName AS sFName, SA_OPOrg.SFCODE AS sFCode, SA_OPOrg.sFID AS sFID, SA_OPOrg.SORGKINDID AS sOrgKindID, SA_OPOrg.SSEQUENCE AS sSequence, SA_OPOrg.SVALIDSTATE AS sValidState, SA_OPOrg.sParent AS sParent, SA_OPOrg.SLEVEL AS sLevel, SA_OPOrg.SPHONE AS sPhone, SA_OPOrg.SFAX AS sFax, SA_OPOrg.SADDRESS AS sAddress, SA_OPOrg.SZIP AS sZip, SA_OPOrg.SDESCRIPTION AS sDescription, SA_OPOrg.SPERSONID AS sPersonID, SA_OPOrg.SNODEKIND AS sNodeKind, SA_OPOrg.SWXDEPTID AS sWxDeptID, SA_OPOrg.VERSION AS version, member1.sResourceID AS groupID, member1.sID AS memberID
FROM SA_OPOrg SA_OPOrg
JOIN SA_ResourceControl member1 ON  (SA_OPOrg.sFID = member1.SORGFID) AND (member1.STYPEID = ?) AND ( member1.sResourceID IN (?) )   
WHERE  (SA_OPOrg.SVALIDSTATE >= ?) AND (SA_OPOrg.SVALIDSTATE = ?)   ORDER BY SA_OPOrg.SSEQUENCE ASC
--> binds:[customGroup_member, , 0, 1]

叫我银垚就好了

问题已解决，原因是该条数据是回退任务，然后回退之前记录了执行人，所以只能选择自己。