流程任务标题设置

qweasdzxc

1. concat('流程审批：',currentActivityLabelOfProcessContext(),':',relationValue('HR_emp_TransferApply',getProcessData1(),null,null,'fOldDeptName','/HR/employeeInfo/data'),'[',relationValue('HR_emp_TransferApply',getProcessData1(),null,null,'fOldPostName','/HR/employeeInfo/data'),'-',relationValue('HR_emp_TransferApply',getProcessData1(),null,null,'fEmpName','/HR/employeeInfo/data'),']',relationValue('HR_emp_TransferApply',getProcessData1(),null,null,'fTransferTypeName','/HR/employeeInfo/data'))

复制代码

任务标题设置如上，出来的效果如图，查数据库里相应的字段有值

jishuang

什么时机设置的任务标题？

qweasdzxc

jishuang 发表于 2018-2-28 15:07
什么时机设置的任务标题？

该环节的执行规则

jishuang

确认在流转的时候字段的值都已经填写了？

函数执行的时候都会有对应的sql语句，把sql语句输出看看
http://bbs.wex5.com/forum.php?mo ... 4&pid=165004035

qweasdzxc

jishuang 发表于 2018-2-28 16:09
确认在流转的时候字段的值都已经填写了？

函数执行的时候都会有对应的sql语句，把sql语句输出看看

内容都填了，哪一个是标题的sql

1. 2018-02-28 16:50:28 开始-WINDOW生成中间文件: /UI2/SA/task/taskView/waitActivity.w
   
2. 2018-02-28 16:50:29 [SQL Time]sql 执行时间：4ms, exec KSQL: SELECT SA_Task.*  FROM SA_Task SA_Task WHERE ((SA_Task.sStatusID='tesReady' or SA_Task.sStatusID='tesExecuting')  and (:_efid0 like concat(SA_Task.sExecutorFID, '%')) and SA_Task.sExecutorFID like '/%' ) ORDER BY sCreateTime DESC LIMIT 0, 1
   
3.   --> sql:SELECT  SA_Task.sID AS SA_Task, SA_Task.SAIACTIVE AS sAIActive, SA_Task.SAIID AS sAIID, SA_Task.SAISTATUSID AS sAIStatusID, SA_Task.SAISTATUSNAME AS sAIStatusName, SA_Task.SACTIVE AS sActive, SA_Task.SACTIVITY AS sActivity, SA_Task.SACTIVITYINTEMPLATE AS sActivityInTemplate, SA_Task.SACTIVITYNAME AS sActivityName, SA_Task.SACTIVITYNAMES AS sActivityNames, SA_Task.SACTUALFINISHTIME AS sActualFinishTime, SA_Task.SACTUALSTARTTIME AS sActualStartTime, SA_Task.SCURL AS sCURL, SA_Task.SCATALOGID AS sCatalogID, SA_Task.SCODE AS sCode, SA_Task.SCONTENT AS sContent, SA_Task.SCREATETIME AS sCreateTime, SA_Task.SCREATORDEPTID AS sCreatorDeptID, SA_Task.SCREATORDEPTNAME AS sCreatorDeptName, SA_Task.SCREATORFID AS sCreatorFID, SA_Task.SCREATORFNAME AS sCreatorFName, SA_Task.SCREATOROGNID AS sCreatorOgnID, SA_Task.SCREATOROGNNAME AS sCreatorOgnName, SA_Task.SCREATORPERSONID AS sCreatorPersonID, SA_Task.SCREATORPERSONNAME AS sCreatorPersonName, SA_Task.SCREATORPOSID AS sCreatorPosID, SA_Task.SCREATORPOSNAME AS sCreatorPosName, SA_Task.SCUSTOMERID AS sCustomerID, SA_Task.SCUSTOMERNAME AS sCustomerName, SA_Task.SDATA1 AS sData1, SA_Task.SDATA2 AS sData2, SA_Task.SDATA3 AS sData3, SA_Task.SDATA4 AS sData4, SA_Task.SDISTRIBUTETIME AS sDistributeTime, SA_Task.SEBFIELD51 AS sEBField51, SA_Task.SEBFIELD52 AS sEBField52, SA_Task.SEBFIELD53 AS sEBField53, SA_Task.SEBFIELD54 AS sEBField54, SA_Task.SEDFIELD21 AS sEDField21, SA_Task.SEDFIELD22 AS sEDField22, SA_Task.SEDFIELD23 AS sEDField23, SA_Task.SEDFIELD24 AS sEDField24, SA_Task.SEIFIELD41 AS sEIField41, SA_Task.SEIFIELD42 AS sEIField42, SA_Task.SEIFIELD43 AS sEIField43, SA_Task.SEIFIELD44 AS sEIField44, SA_Task.SENFIELD11 AS sENField11, SA_Task.SENFIELD12 AS sENField12, SA_Task.SENFIELD13 AS sENField13, SA_Task.SENFIELD14 AS sENField14, SA_Task.SESFIELD01 AS sESField01, SA_Task.SESFIELD02 AS sESField02, SA_Task.SESFIELD03 AS sESField03, SA_Task.SESFIELD04 AS sESField04, SA_Task.SESFIELD05 AS sESField05, SA_Task.SESFIELD06 AS sESField06, SA_Task.SESFIELD07 AS sESField07, SA_Task.SESFIELD08 AS sESField08, SA_Task.SETFIELD31 AS sETField31, SA_Task.SETFIELD32 AS sETField32, SA_Task.SETFIELD33 AS sETField33, SA_Task.SETFIELD34 AS sETField34, SA_Task.SEURL AS sEURL, SA_Task.SEMERGENCYID AS sEmergencyID, SA_Task.SEMERGENCYNAME AS sEmergencyName, SA_Task.SEXECUTEMODE AS sExecuteMode, SA_Task.SEXECUTEMODE2 AS sExecuteMode2, SA_Task.SEXECUTETIME AS sExecuteTime, SA_Task.SEXECUTORDEPTID AS sExecutorDeptID, SA_Task.SEXECUTORDEPTNAME AS sExecutorDeptName, SA_Task.SEXECUTORFID AS sExecutorFID, SA_Task.SEXECUTORFNAME AS sExecutorFName, SA_Task.SEXECUTORNAMES AS sExecutorNames, SA_Task.SEXECUTOROGNID AS sExecutorOgnID, SA_Task.SEXECUTOROGNNAME AS sExecutorOgnName, SA_Task.SEXECUTORPERSONID AS sExecutorPersonID, SA_Task.SEXECUTORPERSONNAME AS sExecutorPersonName, SA_Task.SEXECUTORPOSID AS sExecutorPosID, SA_Task.SEXECUTORPOSNAME AS sExecutorPosName, SA_Task.SEXPECTFINISHTIME AS sExpectFinishTime, SA_Task.SEXPECTSTARTTIME AS sExpectStartTime, SA_Task.SFLOWID AS sFlowID, SA_Task.SFRONTID AS sFrontID, SA_Task.SHINTS AS sHints, SA_Task.SIMPORTANCEID AS sImportanceID, SA_Task.SIMPORTANCENAME AS sImportanceName, SA_Task.SKINDID AS sKindID, SA_Task.SLASTMODIFYTIME AS sLastModifyTime, SA_Task.SLIMITTIME AS sLimitTime, SA_Task.SLOCK AS sLock, SA_Task.SNAME AS sName, SA_Task.sParentID AS sParent, SA_Task.SPLANID AS sPlanID, SA_Task.SPLANNAME AS sPlanName, SA_Task.SPREEMPTMODE AS sPreemptMode, SA_Task.SPROCESS AS sProcess, SA_Task.SPROCESSNAME AS sProcessName, SA_Task.SPROCESSTEMPLATEID AS sProcessTemplateID, SA_Task.SPROCESSTEMPLATEID2 AS sProcessTemplateID2, SA_Task.SPROCESSTEMPLATEITEMSEQUENCE AS sProcessTemplateItemSequence, SA_Task.SPROJECTID AS sProjectID, SA_Task.SPROJECTNAME AS sProjectName, SA_Task.SREMARK AS sRemark, SA_Task.SREMINDMODE AS sRemindMode, SA_Task.SRESPONSIBLE AS sResponsible, SA_Task.SSEQUENCE AS sSequence, SA_Task.SSHORTCUT AS sShortcut, SA_Task.SSOURCEID AS sSourceID, SA_Task.SSTATUSID AS sStatusID, SA_Task.SSTATUSNAME AS sStatusName, SA_Task.SSUMMARY AS sSummary, SA_Task.STEMPPERMISSIONID AS sTempPermissionID, SA_Task.STYPEID AS sTypeID, SA_Task.STYPENAME AS sTypeName, SA_Task.SVARIABLE AS sVariable, SA_Task.SWARNINGTIME AS sWarningTime, SA_Task.SWITHDRAW AS sWithdraw, SA_Task.VERSION AS version FROM SA_Task SA_Task  WHERE  ( (SA_Task.SSTATUSID = ?) OR (SA_Task.SSTATUSID = ?) ) AND ( ?  LIKE SA_Task.SEXECUTORFID || ?) AND (SA_Task.SEXECUTORFID LIKE ?)   ORDER BY sCreateTime DESC
   
4. --> binds:[tesReady, tesExecuting, /9D586884BAAC483292AD4E9EDF616AB8.ogn/AF62FD259D8B4A5E87DC265CA05D53DA.dpt/PSN01@AF62FD259D8B4A5E87DC265CA05D53DA.psm, %, /%]
   
5. 2018-02-28 16:50:29 [SQL Time]sql 执行时间：2ms, exec KSQL:
   
6.   --> sql:SELECT count(*) FROM SA_Task SA_Task  WHERE  ( (SA_Task.SSTATUSID = ?) OR (SA_Task.SSTATUSID = ?) ) AND ( ?  LIKE SA_Task.SEXECUTORFID || ?) AND (SA_Task.SEXECUTORFID LIKE ?)
   
7. --> binds:[tesReady, tesExecuting, /9D586884BAAC483292AD4E9EDF616AB8.ogn/AF62FD259D8B4A5E87DC265CA05D53DA.dpt/PSN01@AF62FD259D8B4A5E87DC265CA05D53DA.psm, %, /%]
   
8. 2018-02-28 16:50:29 结束-WINDOW生成中间文件: /UI2/SA/task/taskView/waitActivity.w
   
9. 2018-02-28 16:50:29 开始-中间文件生成缓存文件: /UI2/SA/task/taskView/waitActivity.w
   
10. 2018-02-28 16:50:29 结束-中间文件生成缓存文件: /UI2/SA/task/taskView/waitActivity.w
    
11. 2018-02-28 16:50:29 开始-WINDOW生成中间文件: /UI2/SA/task/taskView/submitActivity.w
    
12. 2018-02-28 16:50:30 [SQL Time]sql 执行时间：2ms, exec KSQL: SELECT SA_Task.*  FROM SA_Task SA_Task WHERE ((SA_Task.sStatusID='tesReady' or SA_Task.sStatusID='tesExecuting')  and (:_efid0 like concat(SA_Task.sExecutorFID, '%')) and SA_Task.sExecutorFID like '/%' ) ORDER BY sCreateTime DESC LIMIT 0, 5
    
13.   --> sql:SELECT  SA_Task.sID AS SA_Task, SA_Task.SACTIVITY AS sActivity, SA_Task.SCREATETIME AS sCreateTime, SA_Task.SCREATORFNAME AS sCreatorFName, SA_Task.SDATA1 AS sData1, SA_Task.SDATA2 AS sData2, SA_Task.SDATA3 AS sData3, SA_Task.SDATA4 AS sData4, SA_Task.SEURL AS sEURL, SA_Task.SEXECUTORFID AS sExecutorFID, SA_Task.SEXECUTORFNAME AS sExecutorFName, SA_Task.SEXECUTORNAMES AS sExecutorNames, SA_Task.SKINDID AS sKindID, SA_Task.SNAME AS sName, SA_Task.SPROCESS AS sProcess, SA_Task.SSTATUSID AS sStatusID FROM SA_Task SA_Task  WHERE  ( (SA_Task.SSTATUSID = ?) OR (SA_Task.SSTATUSID = ?) ) AND ( ?  LIKE SA_Task.SEXECUTORFID || ?) AND (SA_Task.SEXECUTORFID LIKE ?)   ORDER BY sCreateTime DESC
    
14. --> binds:[tesReady, tesExecuting, /9D586884BAAC483292AD4E9EDF616AB8.ogn/AF62FD259D8B4A5E87DC265CA05D53DA.dpt/PSN01@AF62FD259D8B4A5E87DC265CA05D53DA.psm, %, /%]
    
15. 2018-02-28 16:50:30 结束-WINDOW生成中间文件: /UI2/SA/task/taskView/submitActivity.w
    
16. 2018-02-28 16:50:30 开始-中间文件生成缓存文件: /UI2/SA/task/taskView/submitActivity.w
    
17. 2018-02-28 16:50:31 结束-中间文件生成缓存文件: /UI2/SA/task/taskView/submitActivity.w
    
18. 2018-02-28 16:50:31 [SQL Time]sql 执行时间：2ms, exec KSQL: SELECT SA_Task.*  FROM SA_Task SA_Task WHERE ((SA_Task.sStatusID='tesReady' or SA_Task.sStatusID='tesExecuting')  and SA_Task.sExecutorFID like '/%' and (SA_Task.sCreatorPersonID=:_cpid)) ORDER BY sCreateTime DESC LIMIT 0, 5
    
19.   --> sql:SELECT  SA_Task.sID AS SA_Task, SA_Task.SACTIVITY AS sActivity, SA_Task.SCURL AS sCURL, SA_Task.SCREATETIME AS sCreateTime, SA_Task.SCREATORFNAME AS sCreatorFName, SA_Task.SDATA1 AS sData1, SA_Task.SDATA2 AS sData2, SA_Task.SDATA3 AS sData3, SA_Task.SDATA4 AS sData4, SA_Task.SEXECUTORFID AS sExecutorFID, SA_Task.SEXECUTORFNAME AS sExecutorFName, SA_Task.SEXECUTORNAMES AS sExecutorNames, SA_Task.SNAME AS sName, SA_Task.SPROCESS AS sProcess FROM SA_Task SA_Task  WHERE  ( (SA_Task.SSTATUSID = ?) OR (SA_Task.SSTATUSID = ?) ) AND (SA_Task.SEXECUTORFID LIKE ?) AND (SA_Task.SCREATORPERSONID =  ? )   ORDER BY sCreateTime DESC
    
20. --> binds:[tesReady, tesExecuting, /%, PSN01]

复制代码

jishuang

看查自己业务数据表的select语句

qweasdzxc

1. 2018-03-01 09:16:53 [SQL Time]sql 执行时间：1ms, exec KSQL: select HR_emp_TransferApply.fOldDeptName from HR_emp_TransferApply HR_emp_TransferApply  where HR_emp_TransferApply='844EECF24FF84E03AC67194966B33F25' limit 0,1
   
2.   --> sql:SELECT  HR_emp_TransferApply.FOLDDEPTNAME AS fOldDeptName FROM HR_EMP_TRANSFERAPPLY HR_emp_TransferApply  WHERE HR_emp_TransferApply.fID = ?
   
3. --> binds:[844EECF24FF84E03AC67194966B33F25]
   
4. 2018-03-01 09:16:53 [SQL Time]sql 执行时间：2ms, exec KSQL: select HR_emp_TransferApply.fOldPostName from HR_emp_TransferApply HR_emp_TransferApply  where HR_emp_TransferApply='844EECF24FF84E03AC67194966B33F25' limit 0,1
   
5.   --> sql:SELECT  HR_emp_TransferApply.FOLDPOSTNAME AS fOldPostName FROM HR_EMP_TRANSFERAPPLY HR_emp_TransferApply  WHERE HR_emp_TransferApply.fID = ?
   
6. --> binds:[844EECF24FF84E03AC67194966B33F25]
   
7. 2018-03-01 09:16:53 [SQL Time]sql 执行时间：1ms, exec KSQL: select HR_emp_TransferApply.fEmpName from HR_emp_TransferApply HR_emp_TransferApply  where HR_emp_TransferApply='844EECF24FF84E03AC67194966B33F25' limit 0,1
   
8.   --> sql:SELECT  HR_emp_TransferApply.FEMPNAME AS fEmpName FROM HR_EMP_TRANSFERAPPLY HR_emp_TransferApply  WHERE HR_emp_TransferApply.fID = ?
   
9. --> binds:[844EECF24FF84E03AC67194966B33F25]
   
10. 2018-03-01 09:16:53 [SQL Time]sql 执行时间：1ms, exec KSQL: select HR_emp_TransferApply.fTransferTypeName from HR_emp_TransferApply HR_emp_TransferApply  where HR_emp_TransferApply='844EECF24FF84E03AC67194966B33F25' limit 0,1
    
11.   --> sql:SELECT  HR_emp_TransferApply.FTRANSFERTYPENAME AS fTransferTypeName FROM HR_EMP_TRANSFERAPPLY HR_emp_TransferApply  WHERE HR_emp_TransferApply.fID = ?
    
12. --> binds:[844EECF24FF84E03AC67194966B33F25]

复制代码

这个查询是应该在上一个环节提交处理的时候执行的吧？ 上面代码就是
where后面的条件不应该是HR_emp_TransferApply=''，而是HR_emp_TransferApply.fMainID='',这个要怎么修改执行规则里的表达式?HR_emp_TransferApply这个表示业务从表

jishuang

上一个环节点击流转，弹出流转对话框的时候就生成了

qweasdzxc

jishuang 发表于 2018-3-1 09:31
上一个环节点击流转，弹出流转对话框的时候就生成了

恩恩 楼上那个就是
where后面的条件不对，这个要怎么修改执行规则的表达式

jishuang

查从表的数据，没有提供获取从表主键的，需要自己定义一个函数，传主表的id（getProcessData1()），然后自己写ksql或sql语句查从表需要的信息返回