Clarity

Looking for any help on a NSQL that will monitored the status for processes.
-
Our processes have two owner (a) a business owner and (b) a technical owner.
-
While the techncial owner (lets call that the support group) can monitor the process via the Administration Side of the applciation. the Business Owner can not.
-
Any SQL or NSQL that can be shared would be appreciated as it would help "jump start" our effort to monitor the process tables.
-
Thanks in advance ...

Hi..

Run a sql trace on the administration side and take the same sql and build a portlet.

The query would be something like this

select * from bpm_run_processes where status_code = 'BPM_PIS_RUNNING' and process_engine_id is not null

Regards
Suman Pramanik