Generate a workflow report

[buurd]

Hi!

Is there a way to produce a report about a workflow, ie what tasks the workflow has passed and what the properties of each task was after each task.

MyWorkflow
– Task 1, 2010-01-01 10:00 - 2010-01-01 17:00, employee1
– Task 2, 2010-01-02, employee2
—- Property 1 = value1
—- Property 2 = value2
etc… 
‍‍‍‍‍‍‍

Thanks in advance
Roland Heimdahl

[buurd]

Hi…
In page 297 in the "Alfresco 3" book from Packt they mentions that the process created there logs information. Anyone got more information about that? Is it a viable approch?

//Roland

[hsohaib]

connecte to Alfresco using admin, then open the workflow console :

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

You can list all active/inactive workflows, definitions, tasks , paths etc…

[buurd]

The problem is that workflows dissaper when they are finished. Therefore isn't' the workflow console good enough. I'd really prefer if there was a "standard" way of persisting the workflow-history.

When workflow is up for deletion, iterate though all tasks performed and dump into a table in the database togheter with the references to the documents used and intial data.

[lucille_arkenst]

Page 297 of the Alfresco book seems like a nice option.  But there is a bunch of JavaScript code that needs to go into your workflow.  And it's pretty complicated; imagine doing that for every action inside a custom workflow.  I am wondering if there is an easier way.  I am surprised a workflow is provided in Alfresco but then there is no history mechanism for the end-user.  To the average user, when the workflow is complete, it just goes "poof" into thin air.  ops:

[alejandrosl]

And what about using the Workflow JavaScript API http://wiki.alfresco.com/wiki/Workflow_JavaScript_API to append the desired parameters of the workflow to a file in every step?

[buurd]

Yes, it is very much possible to use the javascript api to write to a file. But it is a bad approch. The nunber of lines you duplicate to perform the same stuff over and over again is messy at best.

But right now we don't have a lot of choise to javascript in every task it is. It errorprone and not very safe if two tasks are performed at the same time.

//Roland

[bookworm2113]

I don't think workflows vanish when they're completed. The instance of that workflow (instanceID) should give you access to that workflow even when its complete. Check out the WorkflowTaskQuery class in the org.alfresco.service.cmr.workflow package. It provides some methods for querying tasks. I hope this helps.

[zaizi]

See similar discussion: http://forums.alfresco.com/en/viewtopic.php?f=35&t=26795#p91930

Ainga