We have been using Docuware for many of our accounting, travel, and financial approvals through the use of Docuware workflows. During all of our financial audits last year, we were using 6.12 and it was very easy to create a SQL query that for each document would join over to the workflow details. With such a query, it was possible to give auditors information on the document, the date approved, who approved it, rejection reasons, and anything else they wanted to audit. We are a public company and auditors want to verify that the process conforms to what actually happened (e.g. someone cannot approve their own expense report).
Now, with 7.1, none of this information is available. I contacted our VAR and they contacted DW support and the only options given where to make screenshots through the UI or to submit a change request. We have thousands of documents that have gone through workflows, and taking thousands of screenshots (and for each step of the workflow history to expand the step), is nearly impossible.
I did find the cabinet's "AUD" table which seemed to have some information I could try to parse, but it only seemed to be present for some of the newer transactions created after we were on 7.1.
Does anyone know if it is possible to write such a query on the database? Something that pulls by document type, date range, and all the associated workflow data?
Regards,
