Posted Sun, 27 Oct 2019 16:36:28 GMT by Brian Harris Director of IT
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?

Posted Sun, 27 Oct 2019 16:37:28 GMT by Matthias Wieland DocuWare Europe GmbH Sr. Director Support EMEA
Dear Brian Harris! It looks like the Community cannot answer your question. Thats why we have opened a Support Request with the Number SR-113071-F7F7B for you. A Software Support Specialist will contact you directly to follow up. We will update this thread with the solution as soon as we have solved the Support Request. With Best Regards, DocuWare Support Team

You must be signed in to post in this forum.