How to query the BPEL tree in the dehyderation database directly?
Tree finder using SQL query.
select
lpad(' ', (level - 1) * 2) || title as padded_name, process_id, modify_date-creation_date, creation_date, modify_date, state
from cube_instance ci1
connect by prior cikey = parent_id
start with cikey = :parent_process;
TreeFinder jsp is the most resource hungry webpage in the BPEL console. This query is an alternative to the Tree Finder jsp.
Cheers,
Prasanna
2 comments :
Hi, please I need your email address for something important, please contact me at 01walid at gmail dot com I was searching the whole internet for your emai but I couldn't find it!
For a SOA 11.1.1.6.0 version use below query
select cikey,
lpad(' ', (level - 1) * 2) || CI1.COMPONENT_NAME as padded_name, modify_date-creation_date, creation_date, modify_date, state
from cube_instance ci1
connect by prior ci1.cikey = to_number(substr(ci1.parent_ref_id, 0, instr(ci1.parent_ref_id, '-')-1))
start with cikey = :StartId;
Post a Comment