-
Create Aging report based on Task Assign date for each Assign To(system variable) Workflow
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
-
Can I stop users from deleting documents from Document Tray, If not can I track from database
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.