Workflow status reports

[mehul1511]

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 the database.

1) Where does the metadata gets stored in the database.

2) is there some encoding to read it (data dictionary). I did not understand the data dictionary on the alfresco website.

Please help, If only i could find the column names where each and every workflow status gets saved will be a big achievement for me.

Thanks in advance, Mehul

[mrogers]

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".

[mehul1511]

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.

[mehul1511]

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

[vinaxwater]

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.

[mehul1511]

Hi,

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

Thank you..