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)
Over 30 days
1.I want to stop users from deleting documents from document tray. Is that possible.
2. If not i can find the table in database which stores the documents in the tray but are removed when deleted. Are these deletions tracked
How can i run a report to get this information.