Obtain previous values of SubWorkTask_DateReady and SubWorkTask_DateDone for a task that is involved

Wui Hong Ang

Hi,

Does anyone know how we can obtain the previous values of SubWorkTask_DateReady/SubWorkTask_DateDone if the workflow design involved a loopback in which the task can be run multiple times? WSubWorkTask seems to only capture the latest value. While we can see the history/audit from the workflow map, I would like to know if the value is kept in any table for reporting purposes.

Thanks.

Colin_Schmidt

WWORKAUDIT table will have this.  The attached LR is in Oracle and extensive.  It may help you to gather information on where this data and others can be found.

 

Colin J

 

 

From: eLink Entry: Content Server LiveReports Forum <livereportsdiscussion@elinkkc.opentext.com>
Sent: Thursday, October 25, 2018 3:24 AM
To: eLink Recipient <devnull@elinkkc.opentext.com>
Subject: Obtain previous values of SubWorkTask_DateReady and SubWorkTask_DateDone for a task that is involved in a loopback

 

Obtain previous values of SubWorkTask_DateReady and SubWorkTask_DateDone for a task that is involved in a loopback

Posted by****@opentext.com (Ang, Wui Hong) On 10/25/2018 05:20 AM

 

Hi, Does anyone know how we can obtain the previous values of SubWorkTask_DateReady/SubWorkTask_DateDone if the workflow design involved a loopback in which the task can be run multiple times? WSubWorkTask seems to only capture the latest value. While we can see the history/audit from the workflow map, I would like to know if the value is kept in any table for reporting purposes. Thanks.

---

[To post a comment, use the normal reply function]
Forum:	Content Server LiveReports Forum
Content Server:	My Support

 

LR-WF-StepAudit.txt