[Throwaway]

Does DEL_DELEGATE_DATE get updated when a task gets routed back on itself? Also, trying to see if it creates a separate record each time a task is done/completed so I can see how many tasks each user is doing.

[amosbatto]

The APP_DELEGATION.DEL_DELEGATE_DATE isn't updated. Instead, a new record is added to the APP_DELEGATION table (and the APP_CACHE_VIEW table which copies the data) each time the case is routed to a task. Each time the case is routed back to the same task, a new record is added to the table. A new record is also added when you manually reassign the case to another user.

[Throwaway]

The APP_DELEGATION.DEL_DELEGATE_DATE isn't updated. Instead, a new record is added to the APP_DELEGATION table (and the APP_CACHE_VIEW table which copies the data) each time the case is routed to a task. Each time the case is routed back to the same task, a new record is added to the table. A new record is also added when you manually reassign the case to another user.

Is the old record marked as done? does it set APP_DELEGATION.DEL_FINISH_DATE ? And for APP_DELEGATION.DEL_DELEGATE_DATE, when it creates the new record, does it use the current date or the date for the initial task?

Thanks!!

Edit: Also, what is it using as primary key in APP_DELEGATION (if it's using one at all)

[amosbatto]

When a task is completed (or it is manually reassigned to another user), APP_DELEGATION.DEL_THREAD_STATUS is changed from 'OPEN' to 'CLOSED' and APP_DELEGATION.DEL_FINISH_DATE is changed from NULL to the datetime. Then a new record is added to APP_DELEGATION table for the next task in the case and APP_DELEGATION.DEL_DELEGATE_DATE is set to the datetime when the case was routed to the task. If you want the datetime when the case was started, that information is stored in APPLICATION.APP_CREATE_DATE.

There is no primary key field in the APP_DELEGATION table, but the combination of APP_UID (case's ID) and DEL_INDEX (delegation index which starts counting from 1) are unique. You can figure these things out by running a case and watching the changes in the APP_DELEGATION table with phpMyAdmin (by searching for the case's ID).