Hi there,

The SHK* tables in Joget track and handle the process definition states and shouldn't be directly referenced from within an app, if you ask me.

As for your question, yes, the shkassignmentstable.activityprocessid does change on deployment for Joget to track the running process instances' assignments (and this is dependent on the ActivityProcessDefName from the same record). You can have a look at the table shkprocesses which adds a record every time a process instance is deployed to handle process versions.

Thus I would say, please don't rely on these tables for your process instance data. Let Joget handle the data inside them (which it is supposed to and does quite well).

As for your use case, I'm sure there might be other ways around the problem. Take for instance the assignment hash variables.

Feel free to share more details about the actual problem. I'd see if I can help.

Thanks!

Thanks for your answer!

For clarity, I'm not directly modifying the shkassignments table (I think in case it is necessary for users to make , that can be through the API, right?), I'm just consulting it, exactly as in the example shown in: https: //dev.joget.org/community/display/KBv5/List+Pending+Activity+and+Assignees. The problem is this: For an expense management application, it is necessary to have a list of "process status" with more information than the one offered by Inbox. 

The fields are shown in the following image: Application (id generator field in the first application form), created on (date of registration), first traveler on request (the official who traveled), route (air), Travel date (recorded on the first form of the app), days for flight (difference in days between this moment and time of flight), applicant (administrative official in charge of legalization), current task (task being carried out at the time) and Current official (the official who is carrying out the current task).  

I must also include the information on when the current official is in charge of the task, but I have not been able to find out where to consult it, this for administrative control purposes and make the necessary "calls" for the process to flow.

Hi, did you try using the https://dev.joget.org/community/display/KBv5/Data+List+Inbox? That can be configured to display much more information than a normal Inbox.

Yes, as test. But all is gonna be developed only in community edition.