I'm writting a report for the users here, displaying a simplified audit trail in a simplified format.
The problem is that the workflow can loop and the WFDisposition table doesn't keep track of the disposition the user entered each time (only the latest). The WFComments works, that table has a field that tracks the task iteration/sequence.
So it ends up reporting only the last disposition entered for that task, with no historical accuracy.
>Running the report at time = 900 I get:
Time | Taskname | DISPO | COMMENT | (Real DISPO user entered at that time)
900 | Task1 | REJECT | comment1 | REJECT
>Running the report at time = 1100 I get:
Time | Taskname | DISPO | COMMENT | (Real DISPO user entered at that time)
900 | Task1 | ACCEPT | comment1 | REJECT
1000 | Task2 | ACCEPT | comment1 | ACCEPT
1100 | Task1 | ACCEPT | comment1 | ACCEPT
Am I missing another table or concept that might track this?
Using LL v9.7.1
Thanks.
