The following query provides insight and additional information from the BPM worklist:
SELECT TASKNUMBER, COMPOSITEINSTANCEID, INSTANCEID, TASKID,
ASSIGNEES, ASSIGNEESDISPLAYNAME, CALLBACKID, PROCESSID,
PROCESSNAME, PROCESSVERSION, ASSIGNEDDATE, CREATEDDATE,TITLE, USERCOMMENT
FROM wftask
WHERE TASKNUMBER = <task_number>;
--- The <task_number> is the task number of BPM worklist. Using this you can easily locate the composite instance for a given task number.
This query provides the COMPOSITEINSTANCEID which is instance ID of PROCESSNAME and PROCESSVERSION. This information can be used to find the matching instance in EM console under soa-infra -> default -> PROCESSNAME[PROCESSVERSION]
In addition to this, the INSTANCEID can be used to track down the instance in right click on soa_infra -> Service Engines -> BPEL. In the screen click on “Instances” tab. Enter the value in this and you will get the instance and other details.
SELECT TASKNUMBER, COMPOSITEINSTANCEID, INSTANCEID, TASKID,
ASSIGNEES, ASSIGNEESDISPLAYNAME, CALLBACKID, PROCESSID,
PROCESSNAME, PROCESSVERSION, ASSIGNEDDATE, CREATEDDATE,TITLE, USERCOMMENT
FROM wftask
WHERE TASKNUMBER = <task_number>;
--- The <task_number> is the task number of BPM worklist. Using this you can easily locate the composite instance for a given task number.
This query provides the COMPOSITEINSTANCEID which is instance ID of PROCESSNAME and PROCESSVERSION. This information can be used to find the matching instance in EM console under soa-infra -> default -> PROCESSNAME[PROCESSVERSION]
In addition to this, the INSTANCEID can be used to track down the instance in right click on soa_infra -> Service Engines -> BPEL. In the screen click on “Instances” tab. Enter the value in this and you will get the instance and other details.
No comments:
Post a Comment