I can think of two way to do it. You can improvise on that.
1) Whenever workobject is opened, it calls pyDefault data transform. Every start may have the property to record the timestamp.
2) whenever the workobject is open, the lock is acquired, and this will be present in pr_sys_locks table. We can utilize this to get the time for what time the work object remained open. if the user dont close the case, then we have to handle the scenario of soft lock.
Posted: 5 years ago
Posted: 9 Aug 2018 2:48 EDT
Gursaheb Singh (Gursaheb)
I thought of the above scenario and wrote test declare triggers in System-Locks. I thought to write 2 triggers , one for instance creation(i.e. WO opened by user) and one for Delete(Lock Released) .
Based on the activity , I will make entries to say one new table i.e. open and close and calculate time.
But somehow trigger is never getting triggered , I have tried all the 5 dropdowns of trigger i.e saved, delete etc. Any idea ?