Wolfgang_Brueckler_1288

SQL Request: Find ALL Parents (Workflows) of an JOBS in OH and JPP Table

Discussion created by Wolfgang_Brueckler_1288 on Dec 6, 2017
Latest reply on Dec 8, 2017 by MatthiasSchelp
Hi All,

hope you can help me, I am searching for a SQL Script (AE: V11.2, ORA) that identifies ALL JOBP Parents of a Job in a workflow in Object definition (OH).

Structure:

JOBP.TOP
JOBP.A
JOBP.B
JOBP.C
JOBS

If I have the name  (or a Part of it) the SQL should return all JOBP- Parents.

Unfortunately I do not habe the SQL knowledge for loops :-(

what I do have is a select for the first parent of the JOBS:select oh_name, OH_IDNR from OH
select oh_name, OH_IDNR from OH
where oh_idnr in (
select JPP_OH_IDNR from OH,JPP
where oh_client =1
and oh_deleteflag = 0
and JPP_OBJECT like 'JOBS.WIN.WORKFLOWCONSTRUCT.WIN%'
and OH_NAME = JPP_OBJECT
)

would be very thankful for any help.....



cheers, Wolfgang




Outcomes