I have a query built that integrates several tables in order to report on workflow items and document lifecycle: WTUser, WorkItem, PDMLinkProduct,EPMDocument, etc
I have a bunch of reportable information gathered, but I am missing one key piece - the date a workflow task was accepted. I have workflow created date, I have task completion date, I have the who and the what and the where, but I do not have workflow task accepted date.
We discovered that this information is stored in WfAssignmentEventAudit under .timestamp when .actionPerformed=Accepted, but I am unable to get this data table into my query successfully with a JOIN to WfAssignedActivity or or creating a subset, etc.
Any SQL experts out there willing to take a look at how to join up these related tables?