topic Re: Workflow status reports in Alfresco Archive

Workflow status reports

mehul1511 — Wed, 20 Apr 2011 12:03:10 GMT

Hi,I am a newbie at alfresco and want to create certain reports. One of them is the workflow status reports. I have been breaking my head on this topic since many days now but not able to find an specific plan to create it.If possible, Can someone tell me the following things or how it is saved in t

Re: Workflow status reports

mrogers — Wed, 20 Apr 2011 12:14:16 GMT

You should probably start by looking at the workflow admin console.

If you trying to report from the database level then you will need to understand JBPMs and Alfresco's Schema, neither of which are "simple".

Re: Workflow status reports

mehul1511 — Wed, 20 Apr 2011 12:23:17 GMT

Really appreciate your reply…

I am not sure of what workflow admin console is, but will you be able to give me some steps or a plan to accomplish the workflow status report.

I am trying to create report which will need metadata like date created, completed, date ended, pending, approved, overdue, denied.

Please let me know, Thank you very much.

Re: Workflow status reports

mehul1511 — Wed, 20 Apr 2011 20:46:10 GMT

does anyone has any idea on how to extract metadata of a workflow?? please help

Re: Workflow status reports

vinaxwater — Thu, 21 Apr 2011 02:06:46 GMT

Dear friend,

Workflow Task:


select * from JBPM_TASKINSTANCE
‍‍‍

Workflow Parameter:


select * from JBPM_VARIABLEINSTANCE
‍‍‍

User Info:


select * from ALF_NODE_PROPERTIES
where QNAME like '%firstName%'
‍‍‍‍

Goodluck.

Re: Workflow status reports

mehul1511 — Thu, 21 Apr 2011 02:29:48 GMT

Hi,

The first two queries were a lot of helpful things. Really really appreciate it..

Thank you..