BAM Consoles typically aggregate several charts to inspect the state of the business process from various viewpoints. The chart that we produced earlier depicts the number of business process instances per business process.
The following charts are in demand:
Number of instances grouped by business process and state (states are: Active, Killed, Completed, etc.)
Number of instances grouped by business process and status (that is; the current step status)
The first one would graphically be like this:
The SQL for generating the chart is as follows:
select name,state,count(state) as quantity from OS_WFENTRY group by state,name;
It simply groups the instances into business process and state using only the OS_WFENTRY table.
The second one would graphically look like this:
The SQL for generating the chart is as follows:
select e.name,c.status as status,count(status) as quantity from OS_WFENTRY e, OS_CURRENTSTEP c where c.entry_id = e.id group by e.name,c.status;
This...