Posted Thu, 05 Dec 2019 13:51:09 GMT by Suraaj Vyas
I have to create an aging report which docuware does not produce out of the box. So i am looking into the database and i want to know how i can create a report which tell me at any time how many documents are assigned to each user in the workflow. Also tell me for each document type how many documents falls in categories like 0-5 days, 6-10 days, 11-15 days, 16-20 days, 21-25 days, 26-30 days and over 30 days.See below to see an example of how i need the data back.

Which tables should in database will have Assign To (System variable) information.
 

Assigned To (Workflow)

Document Type

0-5 Days

6-10 days

11-15 days

16-30 days

21-25 days

26-30 days

Over 30 days

A

abc

1

1

A

def

1

3

2

B

abc

C

abc

1

1

Posted Thu, 05 Dec 2019 13:52:09 GMT by Matthias Wieland DocuWare Europe GmbH Sr. Director Support EMEA
Dear Suraaj Vyas! It looks like the Community cannot answer your question. Thats why we have opened a Support Request with the Number SR-116338-R0J6Q 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.