I need to use the API (SOAP or REST) or an SQL query to retrieve the history of button clicks in Advanced Workflow. I recently added a "Closed Date" to an application and need to populate prior entries. I'd like to search for the most recent selected action where the action name is "Close" and extract the date of that action. Is that possible?
We're using version 6.11 P3 if that matters. TIA.
The problem is that we only keep one year of history and I'm trying to fill out the closed date for records that closed more than a year ago. The only place I can see the date is in the AWF details link at the top of the page. I'm hoping there's a way to pull that with a SQL statement or API call. I've been looking at the WorkPoint tables to try to find the data I'm looking for, but haven't had any luck yet. Thanks for the suggestion.
If three is on history log and retention was set as 1 year while your history is longer, then all DB traces gone as well unfortunately. And AWF closed records are removed after certain period of time from DB as well.
I'm not looking for the data in the history log, as it's not there. I want to pull the advanced workflow path details you see when you click the Details link at the top of the page. These exist until the record is removed from workflow. @JeffLetterman , do you know where this data lives? Thanks.