Question

1
Replies
780
Views
Close popover
Aashish ola (Aashisho)
Amazon

Amazon
IN
Aashisho Member since 2017 1 post
Amazon
Posted: September 8, 2017
Last activity: September 12, 2017
Closed

Completion date for a task from WORK_HISTORY table

Hi

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?

Thanks,
Aashish

Data Integration
Moderation Team has archived post,
Close popover This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.