workflow history

[mythox]

Hi, how may I check the workflow history when the task is ended?   Thankyou

[johnnyv]

Open this link at your local alfresco.

http://localhost:8082/alfresco/faces/jsp/admin/workflow-console.jsp

You will see a list of commands.
I think the command - "show my completed" is appropriate for your requirement.


Hope this helps,
Thanks

Sanket - thanks for this reply, was looking for an answer for quite some time, worked effortlessly.

Cheers!

[lucille_arkenst]

I got this to work (hoorah).  But then (long story short), I undeployed the workflow and lost all their comments and everything.   :shock:  Folks… what is the best way to put the information back?  (Note: my backup failed).  But I have emails with workflow comments so I can go off that.  Should I be inserting records into certain mysql tables?

[bassackwards]

I think you're on the right track with that idea.
Also: praying and hoping like hell it never happens again.
0.o

[sgartner]

1. Workflow information is not deleted from the jBPM tables.
2. After a few thousand workflows you are going to want to start deleting that information in order to maintain database performance.

What is the proper way to do this kind of housekeeping inside Alfresco?

Are there already actions in place, which just need to configured to be run at some time intervals or should one write straight JDBC code that deletes unnecessary data from the tables?

I know this is thread is a little old, but I thought I would try to clarify the situation here.  There is no reason to worry about the database's performance with a few thousand workflows in it unless a large number of those workflows are for a single document and then only if it is slowing down the UI.  The database design will not be effected by having thousands of defunct workflows as everything is accessed by document ID, workflow ID, and task ID which will effortlessly pull out the records for a given document.  If, however, a single document has so many old workflows and tasks that it effects the UI, then you have a problem to solve (and most likely I would solve it on the UI side, not by pruning the database).

There are potential legal requirements, however, that might cause you to want to prune the database (like e-mail there could be legal requirements for removing old task comments on legal documents), but that's a whole different problem.

I hope this helps.

[randy_taylor]

We are developing a custom application using Alfresco 4.1.6. As part of that effort I need to write a java class that will retrieve information on all completed workflows.  I can get a list of completed WorkflowInstances with workflowService.getCompltedWorkflows(wfdId); but when I use that list in turn to get the paths for each workflow instance via workflowService.getWorkflowPaths(wfId); I get an empty list back.  This seems wrong.  Is this interface supposed to work with completed workflows? 
I need to access the properties that were stored off of the workflowPaths. Is there any way to do this for completed workflows?

[bernardoroumié]

I've to display the completed workflows too, so i want know if you provide the code, or if you can help me.

—
Bernardo Roumié
+55(91)8822-2407