Very urgent: information registered in SHK tables

 
2
1
0

Hello, we usually took the information from the shkprocesses and shkactivities tables to monitor the times of the activities carried out in a particular process. However, for some of the processes executed, for some reason we did not find the trace in these tables, as if the process had never existed. However, if there is evidence of execution in the different data tables.

Is there any reason why this information is not recorded? Is there any parameter that causes this information to be deleted?

Your help please! Is there a way to contact an official Joget support to verify this issue?

    CommentAdd your comment...

    3 answers

    1.  
      2
      1
      0

      We found the partial answer: It is indeed an administration error that has to do with the "Delete Process On Completion" parameter. this parameter does not distinguish by process and applies to all those that are being completed. It was activated by a configuration error. It would be ideal if the processes for which it applies could be chosen!

        CommentAdd your comment...
      1.  
        2
        1
        0

        Hi, perhaps a user with administrator access deleted the process instance? You can check the Audit Trail to see if any processes are removed.

          CommentAdd your comment...
        1.  
          2
          1
          0

          Hi

          When you update your process diagram, all the ID's are updated in shkprocesses and shkactivities tables so if you want to link you old activities you can use wf_process_link table, 

          its a sample query

          SELECT d.*, 
       Group_concat(a.NAME) AS 'current_activities' 
FROM   app_fd_hr_tableName d
       LEFT JOIN wf_process_link pl 
              ON d.id = pl.originprocessid 
       LEFT JOIN shkactivities a 
              ON a.state IN ( 1000001, 1000003, 1000005 ) 
             AND ( a.processid = d.id 
              OR a.processid = pl.processid )

          hope it will help you

          Regards,

          Farhan

            CommentAdd your comment...