Completion date for a task from WORK_HISTORY table
To uniquely identifying a task, I am using combination of PXREFOBJECTKEY and PXFLOWINSKEY from PC_ASSIGN_WORKLIST table. Now, I want to get creation date and completion date for each task. How to get the same?
My understanding is
Task Creation Date - Get PXTIMECREATED of first record from WORK_HISTORY table with PYHISTORYTYPE='A'
Task Completion Date - Get PXTIMECREATED of last record from WORK_HISTORY table with PYHISTORYTYPE='F'
If I look into work_history table then there are multiple records (>100) for one task with PYHISTORYTYPE='F'. Does that mean this task was reopened and completed multiple times?
PYHISTORYTYPE type purpose is a single letter indicating the event that caused this history instance to be created. For example, F indicates that a connector flow action was completed, and M indicates that a memo was added.