processChart不显示流程图

星辰

单独做了一个功能页面，展示列表和流程图，列表用的流程中的主表，切换到流程图是空白的，sql打印如下：
select sid from SA_Task t where t.sData1='E63340ACF97C4E2D8FAF8954983BC9B4' and t.sProcess='/PMS/Organization/process/CreateStaff/CreateStaffProcess'
  --> sql:SELECT  t.sID FROM SA_Task t  WHERE  (t.SDATA1 =  ? ) AND (t.SPROCESS =  ? )
--> binds:[E63340ACF97C4E2D8FAF8954983BC9B4, /PMS/Organization/process/CreateStaff/CreateStaffProcess]

SELECT  t.SFLOWID AS sFlowID FROM SA_Task t  WHERE  ( (t.SDATA1 = 'E63340ACF97C4E2D8FAF8954983BC9B4' ) OR (t.SDATA2 = 'E63340ACF97C4E2D8FAF8954983BC9B4' ) OR (t.SDATA3 = 'E63340ACF97C4E2D8FAF8954983BC9B4' ) OR (t.SDATA4 =  'E63340ACF97C4E2D8FAF8954983BC9B4' ) ) AND (t.SPROCESS = '/PMS/Organization/process/CreateStaff/CreateStaffProcess' )
--> binds:[E63340ACF97C4E2D8FAF8954983BC9B4, E63340ACF97C4E2D8FAF8954983BC9B4, E63340ACF97C4E2D8FAF8954983BC9B4, E63340ACF97C4E2D8FAF8954983BC9B4, /PMS/Organization/process/CreateStaff/CreateStaffProcess]


SELECT  t.sID, t.SCUSTOMERID AS sCustomerID, t.SWITHDRAW AS sWithdraw, t.SSTATUSID AS sStatusID, t.SACTUALFINISHTIME AS sActualFinishTime, t.SPLANNAME AS sPlanName, t.SVARIABLE AS sVariable, t.SPROCESSTEMPLATEITEMSEQUENCE AS sProcessTemplateItemSequence, t.SSUMMARY AS sSummary, t.SFLOWID AS sFlowID, t.SAISTATUSNAME AS sAIStatusName, t.SDISTRIBUTETIME AS sDistributeTime, t.SETFIELD32 AS sETField32, t.SEXECUTORPOSNAME AS sExecutorPosName, t.SSTATUSNAME AS sStatusName, t.SETFIELD31 AS sETField31, t.SCREATORFNAME AS sCreatorFName, t.SEDFIELD21 AS sEDField21, t.SCREATOROGNNAME AS sCreatorOgnName, t.SEDFIELD24 AS sEDField24, t.SEIFIELD41 AS sEIField41, t.SEIFIELD42 AS sEIField42, t.SEDFIELD22 AS sEDField22, t.SEIFIELD43 AS sEIField43, t.SEDFIELD23 AS sEDField23, t.SEIFIELD44 AS sEIField44, t.SETFIELD34 AS sETField34, t.VERSION AS version, t.SETFIELD33 AS sETField33, t.SEXPECTFINISHTIME AS sExpectFinishTime, t.SEXECUTORPERSONNAME AS sExecutorPersonName, t.SDATA2 AS sData2, t.STYPENAME AS sTypeName, t.SEXECUTOROGNNAME AS sExecutorOgnName, t.SDATA1 AS sData1, t.SDATA4 AS sData4, t.SCREATORDEPTNAME AS sCreatorDeptName, t.SDATA3 AS sData3, t.SACTIVITYNAMES AS sActivityNames, t.SCREATORPOSNAME AS sCreatorPosName, t.SAIID AS sAIID, t.SLOCK AS sLock, t.SACTIVITY AS sActivity, t.SEXPECTSTARTTIME AS sExpectStartTime, t.SPROCESSTEMPLATEID2 AS sProcessTemplateID2, t.SENFIELD13 AS sENField13, t.SENFIELD14 AS sENField14, t.SPLANID AS sPlanID, t.SACTIVE AS sActive, t.SACTIVITYINTEMPLATE AS sActivityInTemplate, t.SSEQUENCE AS sSequence, t.SKINDID AS sKindID, t.SPROCESSNAME AS sProcessName, t.SEXECUTOROGNID AS sExecutorOgnID, t.SIMPORTANCENAME AS sImportanceName, t.SCREATORPERSONID AS sCreatorPersonID, t.SCURL AS sCURL, t.SENFIELD11 AS sENField11, t.SENFIELD12 AS sENField12, t.SCODE AS sCode, t.SHINTS AS sHints, t.SCREATOROGNID AS sCreatorOgnID, t.SEXECUTORNAMES AS sExecutorNames, t.sParentID AS sParent, t.FBR_BD_TRAVELEXPENSEPRO AS fBR_BD_travelExpensePro, t.SEMERGENCYNAME AS sEmergencyName, t.SESFIELD03 AS sESField03, t.STYPEID AS sTypeID, t.SESFIELD04 AS sESField04, t.SESFIELD05 AS sESField05, t.SESFIELD06 AS sESField06, t.SESFIELD01 AS sESField01, t.SESFIELD02 AS sESField02, t.SCONTENT AS sContent, t.SPROCESS AS sProcess, t.SEXECUTEMODE AS sExecuteMode, t.SCREATORPERSONNAME AS sCreatorPersonName, t.SCREATETIME AS sCreateTime, t.SLIMITTIME AS sLimitTime, t.SWARNINGTIME AS sWarningTime, t.STEMPPERMISSIONID AS sTempPermissionID, t.SSOURCEID AS sSourceID, t.SEURL AS sEURL, t.SIMPORTANCEID AS sImportanceID, t.SCREATORPOSID AS sCreatorPosID, t.SLASTMODIFYTIME AS sLastModifyTime, t.SESFIELD07 AS sESField07, t.SESFIELD08 AS sESField08, t.SEXECUTORPOSID AS sExecutorPosID, t.SCREATORDEPTID AS sCreatorDeptID, t.SEXECUTORPERSONID AS sExecutorPersonID, t.SEXECUTETIME AS sExecuteTime, t.SEBFIELD51 AS sEBField51, t.SEBFIELD52 AS sEBField52, t.SEXECUTORFNAME AS sExecutorFName, t.SEBFIELD53 AS sEBField53, t.SEBFIELD54 AS sEBField54, t.SCREATORFID AS sCreatorFID, t.SEMERGENCYID AS sEmergencyID, t.SREMARK AS sRemark, t.SAISTATUSID AS sAIStatusID, t.SACTUALSTARTTIME AS sActualStartTime, t.SCUSTOMERNAME AS sCustomerName, t.SEXECUTORFID AS sExecutorFID, t.SPROJECTID AS sProjectID, t.SRESPONSIBLE AS sResponsible, t.SFRONTID AS sFrontID, t.SPREEMPTMODE AS sPreemptMode, t.SEXECUTORDEPTNAME AS sExecutorDeptName, t.SAIACTIVE AS sAIActive, t.SEXECUTEMODE2 AS sExecuteMode2, t.SNAME AS sName, t.SREMINDMODE AS sRemindMode, t.SPROCESSTEMPLATEID AS sProcessTemplateID, t.SEXECUTORDEPTID AS sExecutorDeptID, t.SCATALOGID AS sCatalogID, t.SSHORTCUT AS sShortcut, t.SACTIVITYNAME AS sActivityName, t.SPROJECTNAME AS sProjectName FROM SA_Task t  WHERE t.SFLOWID = 'B256A469067B495CAD872ED0A13F809B'
--> binds:[B256A469067B495CAD872ED0A13F809B]


SELECT  tr.STASKID1 AS sTaskID1, tr.STASKID2 AS sTaskID2 FROM SA_TASKRELATION tr  WHERE  (tr.STASKID1 ='A977252186A14E929B82B93B59A0930B' ) OR (tr.STASKID1 = 'B256A469067B495CAD872ED0A13F809B')
--> binds:[A977252186A14E929B82B93B59A0930B, B256A469067B495CAD872ED0A13F809B]   ------null

SELECT  t.sID, t.SPROCESSTEMPLATEID2 AS sProcessTemplateID2, t.SPROCESS AS sProcess, t.SPROCESSINSTANCEID AS sProcessInstanceID, t.SPLACE AS sPlace, t.SFROMACTIVITY AS sFromActivity, t.SFROMACTIVITYINSTANCEID AS sFromActivityInstanceID, t.STOACTIVITY AS sToActivity, t.STOACTIVITYINSTANCEID AS sToActivityInstanceID, t.SVALUE AS sValue, t.SACTIVE AS sActive FROM SA_TokenInstance t  WHERE t.SPROCESSINSTANCEID =  'B256A469067B495CAD872ED0A13F809B'
--> binds:[B256A469067B495CAD872ED0A13F809B]                                     ------null


最后两结果为空

jishuang

展示列表和流程图
流程图怎么打开的？

星辰

jishuang 发表于 2018-12-4 16:55
展示列表和流程图
流程图怎么打开的？

放了列表页签和流程图页签，双击列表grid的行，然后调用的loadByData传进去process和当前行ID，调到流程图页签，我看论坛有的帖子说放到model的load，我也放进去了，还是不能加载出来

jishuang

select sid from SA_Task t where t.sData1='E63340ACF97C4E2D8FAF8954983BC9B4' and t.sProcess='/PMS/Organization/process/CreateStaff/CreateStaffProcess'
是这个数据吗？确认能查到数据吗？

星辰

jishuang 发表于 2018-12-5 08:59
select sid from SA_Task t where t.sData1='E63340ACF97C4E2D8FAF8954983BC9B4' and t.sProcess='/PMS/Org ...

确定能查到，一共两条数据，就是他下边bind的那两个id ： binds:[A977252186A14E929B82B93B59A0930B, B256A469067B495CAD872ED0A13F809B]  

jishuang

SELECT  tr.STASKID1 AS sTaskID1, tr.STASKID2 AS sTaskID2 FROM SA_TASKRELATION tr  WHERE  (tr.STASKID1 ='A977252186A14E929B82B93B59A0930B' ) OR (tr.STASKID1 = 'B256A469067B495CAD872ED0A13F809B')

这个没有数据，说明流程数据就已经不对了，从任务中心打开这个功能才开流程图没问题？

星辰

jishuang 发表于 2018-12-5 10:56
SELECT  tr.STASKID1 AS sTaskID1, tr.STASKID2 AS sTaskID2 FROM SA_TASKRELATION tr  WHERE  (tr.STASKID ...

任务中心打开这个流程没有问题，流程图也没有问题，后台执行的sql也是去查那两个ID ，搞不懂为什么了

jishuang

sql直接到数据库都查不出来？任务中心的语句能查出来？

星辰

jishuang 发表于 2018-12-5 11:30
sql直接到数据库都查不出来？任务中心的语句能查出来？

任务中心的语句和那个是一样的，去数据库都是查出空，但是任务中心进入任务，点击流程图，是能看到流程图的

jishuang

看其他的数据是否正确

如果是任务数据不是通知数据，SA_TaskRelation中肯定有，没有就不对