流程流转选人的问题

zyygod

比如从上一个环节流传到财务审核，我用findOrgUnitsHasCActivity('',true)可以选到所有部门的财务，但是findOrgUnitsHasCActivity(currentOrgID(),true)不是应该选到本部门的财务么？但是却一个人都选不到？？

zyygod

2018-09-13 11:21:44 [SQL Time]sql 执行时间：3ms, exec KSQL: select permission.sPermissionRoleID from SA_OPPermission permission join SA_OPRole role1 on permission.sPermissionRoleID=role1 where role1.sValidState=1 and permission.sProcess='/app/business/oa/assetManager/reject/reject02/process/reject02/reject02Process' and (permission.sActivity='businessActivity4' or permission.sActivity='*')
  --> sql:SELECT  permission.sPermissionRoleID AS sPermissionRoleID FROM SA_OPPermission permission JOIN SA_OPRole role1 ON permission.sPermissionRoleID = role1.sID  WHERE  (role1.SVALIDSTATE = ?) AND (permission.SPROCESS = ?) AND ( (permission.SACTIVITY = ?) OR (permission.SACTIVITY = ?) )
--> binds:[1, /app/business/oa/assetManager/reject/reject02/process/reject02/reject02Process, businessActivity4, *]
2018-09-13 11:21:44 [SQL Time]sql 执行时间：2ms, exec KSQL: select role1 from SA_OPRole role1 where role1.sValidState=1 and role1.sParentRole='E26343A68CB544609863ADE12514A115'
  --> sql:SELECT  role1.sID FROM (SA_OPRole role1 LEFT JOIN SA_OPParentRole SA_OPParentRole__1 ON role1.sID = SA_OPParentRole__1.sRoleID  )  WHERE  (role1.SVALIDSTATE = ?) AND (SA_OPParentRole__1.sParentRoleID = ?)
--> binds:[1, E26343A68CB544609863ADE12514A115]
2018-09-13 11:21:44 [SQL Time]sql 执行时间：2ms, exec KSQL: select org.sFID, org.sFName from SA_OPOrg org where org.sValidState=1  and ((org='kXqN4gZTeLDPvMFaE9M') or (org.sPersonID='kXqN4gZTeLDPvMFaE9M')) order by org.sSequence
  --> sql:SELECT  org.sFID AS sFID, org.sFName AS sFName FROM SA_OPOrg org  WHERE  (org.SVALIDSTATE = ?) AND ( (org.sID = ?) OR (org.SPERSONID = ?) )   ORDER BY org.SSEQUENCE ASC
--> binds:[1, kXqN4gZTeLDPvMFaE9M, kXqN4gZTeLDPvMFaE9M]
2018-09-13 11:21:44 [SQL Time]sql 执行时间：3ms, exec KSQL: select org.sFID, org.sFName from SA_OPOrg org join SA_OPAuthorize auth on org.sFID like concat(auth.sOrgFID, '%') where org.sValidState=1  and ((auth.sAuthorizeRoleID='E26343A68CB544609863ADE12514A115')) order by org.sSequence
  --> sql:SELECT  org.sFID AS sFID, org.sFName AS sFName FROM SA_OPOrg org JOIN SA_OPAuthorize auth ON org.sFID LIKE auth.SORGFID || ?  WHERE  (org.SVALIDSTATE = ?) AND (auth.sAuthorizeRoleID = ?)   ORDER BY org.SSEQUENCE ASC
--> binds:[%, 1, E26343A68CB544609863ADE12514A115]
2018-09-13 11:21:44 [SQL Time]sql 执行时间：2ms, exec KSQL: select c.sContent from SA_ProcessControl c where c.sProcess='/app/business/oa/assetManager/reject/reject02/process/reject02/reject02Process' and c.sActivity='businessActivity3' and c.sOperatorID='EZ8BJRuFDFGZZe016O1' and c.sAction='advanceProcessAction' and (c.sProcessTemplateID2 IS NULL or c.sProcessTemplateID2 = '')
  --> sql:SELECT  c.SCONTENT AS sContent FROM SA_ProcessControl c  WHERE  (c.SPROCESS = ?) AND (c.SACTIVITY = ?) AND (c.SOPERATORID = ?) AND (c.SACTION = ?) AND ( (c.SPROCESSTEMPLATEID2 IS NULL) OR (c.SPROCESSTEMPLATEID2 = ?) )
--> binds:[/app/business/oa/assetManager/reject/reject02/process/reject02/reject02Process, businessActivity3, EZ8BJRuFDFGZZe016O1, advanceProcessAction, ]
2018-09-13 11:21:44 [SQL Time]sql 执行时间：2ms, exec KSQL: select org.sFID, org.sFName from SA_OPOrg org where org.sValidState=1  and (org.sFID='/r4vwdrAdXGeFyKBw0Fo.ogn/uFHLEVsm8ToozOaxmtQ.dpt/2oYZMgDFKRsO378CkzL@uFHLEVsm8ToozOaxmtQ.psm') order by org.sSequence
  --> sql:SELECT  org.sFID AS sFID, org.sFName AS sFName FROM SA_OPOrg org  WHERE  (org.SVALIDSTATE = ?) AND (org.sFID = ?)   ORDER BY org.SSEQUENCE ASC
--> binds:[1, /r4vwdrAdXGeFyKBw0Fo.ogn/uFHLEVsm8ToozOaxmtQ.dpt/2oYZMgDFKRsO378CkzL@uFHLEVsm8ToozOaxmtQ.psm]

zyygod

zyygod 发表于 2018-9-13 11:21
2018-09-13 11:21:44 [SQL Time]sql 执行时间：3ms, exec KSQL: select permission.sPermissionRoleID from ...

用了findOrgUnitsHasCActivityInACDept('START',true)，已解决，请结贴！

jishuang

到数据库执行
SELECT  org.sFID AS sFID, org.sFName AS sFName FROM SA_OPOrg org  WHERE  (org.SVALIDSTATE = 1) AND ( (org.sID = 'kXqN4gZTeLDPvMFaE9M') OR (org.SPERSONID = 'kXqN4gZTeLDPvMFaE9M') )   ORDER BY org.SSEQUENCE ASC

SELECT  org.sFID AS sFID, org.sFName AS sFName FROM SA_OPOrg org JOIN SA_OPAuthorize auth ON org.sFID LIKE auth.SORGFID || '%'  WHERE  (org.SVALIDSTATE = 1) AND (auth.sAuthorizeRoleID = 'E26343A68CB544609863ADE12514A115')   ORDER BY org.SSEQUENCE ASC

看执行结果是什么

zyygod

jishuang 发表于 2018-9-13 11:46
到数据库执行
SELECT  org.sFID AS sFID, org.sFName AS sFName FROM SA_OPOrg org  WHERE  (org.SVALIDSTA ...

已经解决了，麻烦了！请结贴。