-
1. Re: Sql query to fetch activevos process Id and its corresponding rowid object from mdm base object table
Check the aeb4ptaskparameter table for the berowid id. The data corresponding to this ID will be present in aeb4ptaskparametervalue table.
-
2. Re: Sql query to fetch activevos process Id and its corresponding rowid object from mdm base object table
Hi Asim,
you can use following query:
select pt.processid, pv.STRINGVALUE as rowid_object, ptp.paprocessid as parent_process
from avos.aeb4ptask pt
inner join avos.aeb4ptaskparametervalue pv
on pt.processid = pv.processid and pv.parameterid = 27
inner join avos.aeb4ptaskpa ptp on ptp.processid = pt.processid;
P.S: parent_process is the processid that you see on AVOS admin console under monitoring menu.
Hope this helps.