topic Re: Questions about history / audit / reporting on workflow in Alfresco Archive

Questions about history / audit / reporting on workflow

piski — Fri, 10 Dec 2010 10:03:33 GMT

Hi all,Please answer some questions about workflows history and reporting, it may help somebody !1) What's the best practice to get workflow / tasks history and reporting ? MySQL query(ies) ? (According to http://wiki.alfresco.com/wiki/Audit, definitely not against 3.4 because Audit trail archit

Re: Questions about history / audit / reporting on workflow

mehul1511 — Thu, 21 Apr 2011 01:07:02 GMT

Hey,

I see that you have not got any replies for this post. But I have exact the same question and have been breaking my head over it to get answers but nothing is working for me. I have read the audit wiki but as you have said even I was not able to find any solution. Since I have exact the same questions as you have over here, were you able to find answers to them. If so can you help me with your knowledge I have been working on this for days and have not got any results. Please help…………

Really appreciate it…

Re: Questions about history / audit / reporting on workflow

piski — Mon, 09 May 2011 10:15:49 GMT

Sorry but I'm still waiting a reply, even if it's "general".

We'll have a look on the last 3.4.e with Activiti preview to know if we can find a way to do this !

Re: Questions about history / audit / reporting on workflow

mehul1511 — Thu, 12 May 2011 20:44:30 GMT

Thank you for your reply. If you find answers to it please reply back to this post. Really appreciate it

Re: Questions about history / audit / reporting on workflow

mitpatoliya — Thu, 19 May 2011 07:12:42 GMT

Hi,

I can comment on your second point and hope this will be help you out.

After completion of workflow workflow history still persist in the database.
It does not get deleted.
When you look in to the properties of document for workflow history you will find information only about inflight workflows.
But with little customization you can get the information about completed workflows as well.

Re: Questions about history / audit / reporting on workflow

piski — Thu, 19 May 2011 14:29:36 GMT

Hi,

Could you share with us the main "keys" to make the custiomizations required ?

Thanks !

Re: Questions about history / audit / reporting on workflow

mrogers — Thu, 19 May 2011 14:49:31 GMT

Workflows are indeed deleted when they are cancelled, Its just the way JBPM is. I've just done some quick reading up on Activiti and it seems that history is stored so can be used for reports.

There's two ways of working around this that spring to mind.
1: is to store the information about workflow execution somewhere, for example you could have some properties on the document to which the workflow runs e.g. "approved by" or store a log as content of a node somewhere.
2: is to store details of the workflow execution via audit and then report against that.

Re: Questions about history / audit / reporting on workflow

mitpatoliya — Mon, 23 May 2011 10:13:29 GMT

For Getting History of Completed workflows you can directly use the API's of WorkflowService.
public List<WorkflowInstance> getWorkflowsForContent(NodeRef packageItem, boolean active)

where if you send active as false it will return you the List of workflow instances which are completed.
From which you can get the workflow task and history.

Re: Questions about history / audit / reporting on workflow

mehul1511 — Tue, 24 May 2011 12:26:09 GMT

Thank you very much for your reply!

@mitpatoliya are you available on yahoo im? I had some quick questions!!

Regards

Re: Questions about history / audit / reporting on workflow

krups — Mon, 17 Dec 2012 01:03:42 GMT

Hi,
I am also after to store workflow histories. I am using activiti. I don't know much about audit. Can you please share someidea how can I achieve this?
Thanks