Business Dashboards: This option is intended to give users access to the generic dashboard tooling either to compose new dashboards or just to consume existing ones.

Process & Task Dashboard: It opens up the Process Dashboard perspective which contains several performance indicators related to the jBPM execution engine.

jBPM Count Processes: Retrieves the total number of process instances per process and per process status.

        select processname,
          ifnull(instances,0) total,
          ifnull(instances_act,0) active,
          ifnull(instances_compl,0) completed,
          ifnull(instances_pend,0) pending,
          ifnull(instances_susp,0) suspended,
          ifnull(instances_abrt,0) aborted
        from
        (select processinstanceid, processname, count(*) as instances
        from processinstancelog
        where {sql_condition, optional, processname, processname}
          and {sql_condition, optional, user_identity, userid}
          and {sql_condition, optional, start_date, start_date}
          and {sql_condition, optional, end_date, end_date}
          and {sql_condition, optional, processversion, processversion}
        group by processinstanceid,processname) as total
        left outer join
        (select processinstanceid, count(*) as instances_act
        from processinstancelog
        where status=1
          and {sql_condition, optional, processname, processname}
          and {sql_condition, optional, user_identity, userid}
          and {sql_condition, optional, start_date, start_date}
          and {sql_condition, optional, end_date, end_date}
          and {sql_condition, optional, processversion, processversion}
        group by processinstanceid) as active
        on (total.processinstanceid=active.processinstanceid)
        left outer join
        (select processinstanceid, count(*) as instances_compl
        from processinstancelog
        where status=2
          and {sql_condition, optional, processname, processname}
          and {sql_condition, optional, user_identity, userid}
          and {sql_condition, optional, start_date, start_date}
          and {sql_condition, optional, end_date, end_date}
          and {sql_condition, optional, processversion, processversion}
        group by processinstanceid) as completed
        on (total.processinstanceid=completed.processinstanceid)
        left outer join
        (select processinstanceid, count(*) as instances_pend
        from processinstancelog
        where status=0
          and {sql_condition, optional, processname, processname}
          and {sql_condition, optional, user_identity, userid}
          and {sql_condition, optional, start_date, start_date}
          and {sql_condition, optional, end_date, end_date}
          and {sql_condition, optional, processversion, processversion}
        group by processinstanceid) as pending
        on (total.processinstanceid=pending.processinstanceid)
        left outer join
        (select processinstanceid, count(*) as instances_susp
        from processinstancelog
        where status=4
          and {sql_condition, optional, processname, processname}
          and {sql_condition, optional, user_identity, userid}
          and {sql_condition, optional, start_date, start_date}
          and {sql_condition, optional, end_date, end_date}
          and {sql_condition, optional, processversion, processversion}
        group by processinstanceid) as suspended
        on (total.processinstanceid=suspended.processinstanceid)
        left outer join
        (select processinstanceid, count(*) as instances_abrt
        from processinstancelog
        where status=3
          and {sql_condition, optional, processname, processname}
          and {sql_condition, optional, user_identity, userid}
          and {sql_condition, optional, start_date, start_date}
          and {sql_condition, optional, end_date, end_date}
          and {sql_condition, optional, processversion, processversion}
        group by processinstanceid) as aborted
        on (total.processinstanceid=aborted.processinstanceid)
        order by processname
      

jBPM Process By Status: Retrieves the number of process instances grouped by status.

        select status, count(processinstanceid)
        from processinstancelog
        where status is not null and {sql_condition, optional, processname, processname}
          and {sql_condition, optional, user_identity, userid}
          and {sql_condition, optional, status, status}
          and {sql_condition, optional, start_date, start_date}
          and {sql_condition, optional, end_date, end_date}
          and {sql_condition, optional, processversion, processversion}
        group by status
      

jBPM Process By Version: Retrieves the number of process instances grouped by version.

        select processVersion, count(processinstanceid)
        from processinstancelog
        where processVersion is not null
          and {sql_condition, optional, processname, processname}
          and {sql_condition, optional, user_identity, userid}
          and {sql_condition, optional, status, status}
          and {sql_condition, optional, start_date, start_date}
          and {sql_condition, optional, end_date, end_date}
          and {sql_condition, optional, processversion, processversion}
        group by processVersion
      

jBPM Process Completed By Date: Retrieves the number of process instances completed grouped by date.

        select end_date, count(processinstanceid)
        from processinstancelog
        where end_date is not null
          and {sql_condition, optional, processname, processname}
          and {sql_condition, optional, user_identity, userid}
          and {sql_condition, optional, status, status}
          and {sql_condition, optional, start_date, start_date}
          and {sql_condition, optional, end_date, end_date}
          and {sql_condition, optional, processversion, processversion}
        group by end_date
        order by end_date asc
      

jBPM Process Duration: Retrieves the number of instances and duration stats per process.

        select processname, count(processinstanceid), min(duration), avg(duration), max(duration)
        from processinstancelog
        where {sql_condition, optional, processname, processname}
          and {sql_condition, optional, user_identity, userid}
          and {sql_condition, optional, status, status}
          and {sql_condition, optional, start_date, start_date}
          and {sql_condition, optional, end_date, end_date}
          and {sql_condition, optional, processversion, processversion}
        group by processname
        order by processname asc
      

jBPM Process Instances: Retrieves the number of instances per process.

        select processname, count(processinstanceid)
        from processinstancelog
        where {sql_condition, optional, processname, processname}
          and {sql_condition, optional, user_identity, userid}
          and {sql_condition, optional, status, status}
          and {sql_condition, optional, start_date, start_date}
          and {sql_condition, optional, end_date, end_date}
          and {sql_condition, optional, processversion, processversion}
        group by processname
        order by processname asc
      

jBPM Process Instances By User: Retrieves the number of process instances grouped by the user who initiates.

        select user_identity userid, count(processinstanceid)
        from processinstancelog
        where user_identity is not null
          and {sql_condition, optional, processname, processname}
          and {sql_condition, optional, user_identity, userid}
          and {sql_condition, optional, status, status}
          and {sql_condition, optional, start_date, start_date}
          and {sql_condition, optional, end_date, end_date}
          and {sql_condition, optional, processversion, processversion}
        group by user_identity
      

jBPM Process Started By Date: Retrieves the number of process instances started on given date periods.

        select start_date, count(processinstanceid)
        from processinstancelog
        where start_date is not null
          and {sql_condition, optional, processname, processname}
          and {sql_condition, optional, user_identity, userid}
          and {sql_condition, optional, status, status}
          and {sql_condition, optional, start_date, start_date}
          and {sql_condition, optional, end_date, end_date}
          and {sql_condition, optional, processversion, processversion}
        group by start_date
        order by start_date asc
      

jBPM Task Instances: Retrieves the number of task instances per process.

        select ts.taskname, count(ts.taskid) taskid
        from bamtasksummary ts left join processinstancelog ps on (ts.processinstanceid=ps.processinstanceid)
        where {sql_condition, optional, ps.processname, processname}
          and {sql_condition, optional, ps.status, status}
          and {sql_condition, optional, ps.start_date, start_date}
          and {sql_condition, optional, ps.end_date, end_date}
          and {sql_condition, optional, ps.processversion, processversion}
          and {sql_condition, optional, ts.userid, userid}
          and {sql_condition, optional, ts.taskname, taskname}
          and {sql_condition, optional, ts.createddate, createddate}
          and {sql_condition, optional, ts.enddate, enddate}
          and {sql_condition, optional, ts.status, status}
        group by ts.taskname
      

jBPM Tasks By Status: Retrieves the number of task instances grouped by status.

        select ts.status as taskstatus, count(ts.taskid)
        from bamtasksummary ts left join processinstancelog ps on (ts.processinstanceid=ps.processinstanceid)
        where {sql_condition, optional, ps.processname, processname}
          and {sql_condition, optional, ps.status, status}
          and {sql_condition, optional, ps.start_date, start_date}
          and {sql_condition, optional, ps.end_date, end_date}
          and {sql_condition, optional, ps.processversion, processversion}
          and {sql_condition, optional, ts.userid, userid}
          and {sql_condition, optional, ts.taskname, taskname}
          and {sql_condition, optional, ts.createddate, createddate}
          and {sql_condition, optional, ts.enddate, enddate}
          and {sql_condition, optional, ts.status, taskstatus}
        group by ts.status
      

jBPM Tasks By User: Retrieves the number of task instances grouped by the user who holds it.

        select ts.userid, count(ts.taskid)
        from bamtasksummary ts left join processinstancelog ps on (ts.processinstanceid=ps.processinstanceid)
        where ts.userid is not null
          and {sql_condition, optional, ps.processname, processname}
          and {sql_condition, optional, ps.status, status}
          and {sql_condition, optional, ps.start_date, start_date}
          and {sql_condition, optional, ps.end_date, end_date}
          and {sql_condition, optional, ps.processversion, processversion}
          and {sql_condition, optional, ts.userid, userid}
          and {sql_condition, optional, ts.taskname, taskname}
          and {sql_condition, optional, ts.createddate, createddate}
          and {sql_condition, optional, ts.enddate, enddate}
          and {sql_condition, optional, ts.status, taskstatus}
        group by ts.userid
      

jBPM Tasks Completed By Date: Retrieves the number of task instances completed grouped by date.

        select ts.enddate, count(ts.taskid)
        from bamtasksummary ts left join processinstancelog ps on (ts.processinstanceid=ps.processinstanceid)
        where ts.enddate is not null
          and {sql_condition, optional, ps.processname, processname}
          and {sql_condition, optional, ps.status, status}
          and {sql_condition, optional, ps.start_date, start_date}
          and {sql_condition, optional, ps.end_date, end_date}
          and {sql_condition, optional, ps.processversion, processversion}
          and {sql_condition, optional, ts.userid, userid}
          and {sql_condition, optional, ts.taskname, taskname}
          and {sql_condition, optional, ts.createddate, createddate}
          and {sql_condition, optional, ts.enddate, enddate}
          and {sql_condition, optional, ts.status, taskstatus}
        group by ts.enddate
        order by ts.enddate asc
      

jBPM Tasks Duration: Retrieves the number of instances and duration stats per task.

        select ts.taskname, count(ts.taskid), min(ts.duration), avg(ts.duration), max(ts.duration)
        from bamtasksummary ts left join processinstancelog ps on (ts.processinstanceid=ps.processinstanceid)
        where ts.duration is not null
          and {sql_condition, optional, ps.processname, processname}
          and {sql_condition, optional, ps.status, status}
          and {sql_condition, optional, ps.start_date, start_date}
          and {sql_condition, optional, ps.end_date, end_date}
          and {sql_condition, optional, ps.processversion, processversion}
          and {sql_condition, optional, ts.userid, userid}
          and {sql_condition, optional, ts.taskname, taskname}
          and {sql_condition, optional, ts.createddate, createddate}
          and {sql_condition, optional, ts.enddate, enddate}
          and {sql_condition, optional, ts.status, taskstatus}
        group by ts.taskname
        order by ts.taskname asc
      

jBPM Tasks Started By Date: Retrieves the number of task instances started on given date periods.

        select ts.createddate, count(ts.taskid)
        from bamtasksummary ts left join processinstancelog ps on (ts.processinstanceid=ps.processinstanceid)
        where ts.createddate is not null
          and {sql_condition, optional, ps.processname, processname}
          and {sql_condition, optional, ts.userid, userid}
          and {sql_condition, optional, ps.status, status}
          and {sql_condition, optional, ps.start_date, start_date}
          and {sql_condition, optional, ps.end_date, end_date}
          and {sql_condition, optional, ps.processversion, processversion}
          and {sql_condition, optional, ts.userid, userid}
          and {sql_condition, optional, ts.taskname, taskname}
          and {sql_condition, optional, ts.createddate, createddate}
          and {sql_condition, optional, ts.enddate, enddate}
          and {sql_condition, optional, ts.status, taskstatus}
        group by ts.createddate
        order by ts.createddate asc