Hi Automic and Oracle database experts,
I have a workflow with the following precondition:
Now I would need a query that shows all workflows containing 'set object variable 1 to 1'.
Here's what I have so far:
JOIN uc4.oh ON oh_idnr = jpov_oh_idnr
inner join jppo on jppo_oh_idnr = oh_idnr
TO_CHAR(jpov_value) = '1'
and JPPO_CarName = 'SET VALUE'
COUNT(jpov_jppo_lnr) > 1;
The approach here is to look for more than one value '1' in the JPOV_JPPO_LNR, but this also shows other conditions like `return code = 1'.
Any help on getting this figure out is highly appreciated.