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
Posted Tue, 15 Aug 2023 12:24:33 GMT by Tobias Rosini Entwickler
Whats happening with this issue? I'am interrested two.
Posted Tue, 15 Aug 2023 14:47:46 GMT by Brian Harris Director of IT
All of the workflow data in the database is encrypted and it was not possible to use our query to pull all the workflow data for auditors.

I also tried going through the Docuware API to pull all the information, but it was not possible either.

In the end, I modified all our workflows to append the action, user, and activity to a text field that could be queried in the cabinet.  It was the only way to get around the encryption and appease our auditors.
Posted Fri, 29 Sep 2023 07:53:37 GMT by Carolina Galeandro
Hi, would you please explain how you did it? thank you in advance

You must be signed in to post in this forum.