待办已办的修改导致撤销功能失效

ljdkzd

如果我提交一个流程给多个人，因为X5自带的已办会形成多条记录，所以我公司修改了已办，将原先的从SA_Task表取数据修改为从视图中取数据（视图语句见下方），现在导致撤销功能失效，请问有没有什么办法解决？



SA_SUBMIT:
SELECT
        SA_TASK. SID,
        SA_TASK.SNAME AS SNAME,
        SA_TASK.SCONTENT AS SCONTENT,
        SA_TASK.SREMARK AS SREMARK,
        SA_TASK.SFLOWID AS SFLOWID,
        SA_TASK.SSOURCEID AS SSOURCEID,
        SA_TASK.SFRONTID AS SFRONTID,
        SA_TASK.SCATALOGID AS SCATALOGID,
        SA_TASK.SKINDID AS SKINDID,
        SA_TASK.SRESPONSIBLE AS SRESPONSIBLE,
        SA_TASK.SEXECUTEMODE2 AS SEXECUTEMODE2,
        SA_TASK.SEXECUTEMODE AS SEXECUTEMODE,
        SA_TASK.SPREEMPTMODE AS SPREEMPTMODE,
        SA_TASK.SREMINDMODE AS SREMINDMODE,
        SA_TASK.STYPEID AS STYPEID,
        SA_TASK.STYPENAME AS STYPENAME,
        SA_TASK.SIMPORTANCEID AS SIMPORTANCEID,
        SA_TASK.SIMPORTANCENAME AS SIMPORTANCENAME,
        SA_TASK.SEMERGENCYID AS SEMERGENCYID,
        SA_TASK.SEMERGENCYNAME AS SEMERGENCYNAME,
        SA_TASK.SCURL AS SCURL,
        SA_TASK.SEURL AS SEURL,
        SA_TASK.SDISTRIBUTETIME AS SDISTRIBUTETIME,
        SA_TASK.SCREATETIME AS SCREATETIME,
        SA_TASK.SLASTMODIFYTIME AS SLASTMODIFYTIME,
        SA_TASK.SLIMITTIME AS SLIMITTIME,
        SA_TASK.SWARNINGTIME AS SWARNINGTIME,
        SA_TASK.SEXECUTETIME AS SEXECUTETIME,
        SA_TASK.SEXPECTSTARTTIME AS SEXPECTSTARTTIME,
        SA_TASK.SEXPECTFINISHTIME AS SEXPECTFINISHTIME,
        SA_TASK.SACTUALSTARTTIME AS SACTUALSTARTTIME,
        SA_TASK.SACTUALFINISHTIME AS SACTUALFINISHTIME,
        SA_TASK.SCREATORFID AS SCREATORFID,
        SA_TASK.SCREATORFNAME AS SCREATORFNAME,
        SA_TASK.SEXECUTORFID AS SEXECUTORFID,
        SA_TASK.SEXECUTORFNAME AS SEXECUTORFNAME,
        SA_TASK.SCREATORPERSONID AS SCREATORPERSONID,
        SA_TASK.SCREATORPERSONNAME AS SCREATORPERSONNAME,
        SA_TASK.SCREATORPOSID AS SCREATORPOSID,
        SA_TASK.SCREATORPOSNAME AS SCREATORPOSNAME,
        SA_TASK.SCREATORDEPTID AS SCREATORDEPTID,
        SA_TASK.SCREATORDEPTNAME AS SCREATORDEPTNAME,
        SA_TASK.SCREATOROGNID AS SCREATOROGNID,
        SA_TASK.SCREATOROGNNAME AS SCREATOROGNNAME,
        SA_TASK.SEXECUTORPERSONID AS SEXECUTORPERSONID,
        SA_TASK.SEXECUTORPERSONNAME AS SEXECUTORPERSONNAME,
        SA_TASK.SEXECUTORPOSID AS SEXECUTORPOSID,
        SA_TASK.SEXECUTORPOSNAME AS SEXECUTORPOSNAME,
        SA_TASK.SEXECUTORDEPTID AS SEXECUTORDEPTID,
        SA_TASK.SEXECUTORDEPTNAME AS SEXECUTORDEPTNAME,
        SA_TASK.SEXECUTOROGNID AS SEXECUTOROGNID,
        SA_TASK.SEXECUTOROGNNAME AS SEXECUTOROGNNAME,
        SA_TASK.SEXECUTORNAMES AS SEXECUTORNAMES,
        SA_TASK.SCUSTOMERID AS SCUSTOMERID,
        SA_TASK.SCUSTOMERNAME AS SCUSTOMERNAME,
        SA_TASK.SPROJECTID AS SPROJECTID,
        SA_TASK.SPROJECTNAME AS SPROJECTNAME,
        SA_TASK.SPLANID AS SPLANID,
        SA_TASK.SPLANNAME AS SPLANNAME,
        SA_TASK.SDATA1 AS SDATA1,
        SA_TASK.SDATA2 AS SDATA2,
        SA_TASK.SDATA3 AS SDATA3,
        SA_TASK.SDATA4 AS SDATA4,
        SA_TASK.SVARIABLE AS SVARIABLE,
        SA_TASK.SACTIVE AS SACTIVE,
        SA_TASK.SSTATUSID AS SSTATUSID,
        SA_TASK.SSTATUSNAME AS SSTATUSNAME,
        SA_TASK.SAIACTIVE AS SAIACTIVE,
        SA_TASK.SAIID AS SAIID,
        SA_TASK.SAISTATUSID AS SAISTATUSID,
        SA_TASK.SAISTATUSNAME AS SAISTATUSNAME,
        SA_TASK.SSEQUENCE AS SSEQUENCE,
        SA_TASK.SLOCK AS SLOCK,
        SA_TASK.SHINTS AS SHINTS,
        SA_TASK.SSHORTCUT AS SSHORTCUT,
        SA_TASK.SPROCESS AS SPROCESS,
        SA_TASK.SACTIVITY AS SACTIVITY,
        SA_TASK.SPROCESSNAME AS SPROCESSNAME,
        SA_TASK.SACTIVITYNAME AS SACTIVITYNAME,
        SA_TASK. VERSION AS VERSION,
        SA_TASK.SSUMMARY AS SSUMMARY,
        SA_TASK.SACTIVITYNAMES AS SACTIVITYNAMES,
        SA_TASK.SCODE AS SCODE,
        SA_TASK.SWITHDRAW AS SWITHDRAW,
        SA_FLOW.STYPENAME AS FLOWTYPENAME,
        SA_FLOW.SSTATUSNAME AS FLOWSTATUSNAME,
        SA_FLOW.SLASTMODIFYTIME AS FLOWLASTMODIFYTIME,
        SA_FLOW.SCREATORPERSONNAME AS FLOWCREATORPERSONNAME,
        SA_FLOW.SEXECUTORNAMES AS EXECUTORNAMES,
        SA_FLOW.SSTATUSID AS FLOWSTATUSID
FROM
        SA_Task SA_Task
LEFT JOIN SA_FLOW SA_Flow ON SA_Task.sFlowID = SA_Flow. SID
WHERE
        (
                SA_Task.sStatusID = 'tesFinished'
                OR SA_Task.sStatusID = 'tesReturned'
        )
AND SA_Task.sCatalogID = 'tsProcess'
AND (
        SA_Task.SKINDID = 'tkTask'
        OR SA_Task.SKINDID = 'tkExecutor'
)





SA_FLOW:
SELECT SA_FLOW.sid,
        SA_FLOW.STYPENAME,
        SA_FLOW.SSTATUSNAME,
        SA_FLOW.SLASTMODIFYTIME,
        SA_FLOW.SCREATORPERSONNAME,
        SA_FLOW.SEXECUTORNAMES,
        SA_FLOW.SSTATUSID
FROM
        SA_TASK SA_FLOW
WHERE
        SKINDID = 'tkProcessInstance'

jishuang

撤销是指的回收任务吗？
回收任务必须是A流转到B,如果B还没有处理，A可以在任务中心找到这条任务点击回收任务,可以遵循这个原则修改sql查找任务
已办的就是提交任务把，参考http://docs.wex5.com/bex5-process-question-list-10016/