Wolfgang_Brueckler_75

Search for Conditions - SQL statement

Discussion created by Wolfgang_Brueckler_75 on Nov 6, 2015
Unfortunately there is no possibility in JAVA GUI or ECC to search for conditions in Workflows.

To get rid of this I wrote an SQL Statement which shows all Workflows which contain conditions (Pr- Postcondtioins or if its an IF Workflow)
This SQL works for Automation Engine V9 ... V11.1 (11.2 not tested so far)

MS SQL:
select distinct OH_NAME as 'Object Name', oh_otype as 'Type',jppo_jpp_lnr as 'Object No in WF', case JPPO_Location when 1 then 'PRE-Cond' when 2 then 'POST-Cond' when 3 then 'IF-JOBP' else 'Error in statement' end as 'Condition'
from OH with (nolock)
inner join JPPO ON OH_IDNR = JPPO_OH_IDNR
WHERE OH_client = 22

ORACLE:

select
  oh_name as "Object Name",
  oh_otype as "Type",
  jppo_jpp_lnr as "Object No in WF",
  case JPPO_Location
    when 1 then 'PRE-Cond'
    when 2 then 'POST-Cond'
    when 3 then 'IF-JOBP'
    else 'Error in statement'
    end as "Condition"
from OH
inner join JPPO ON OH_IDNR = JPPO_OH_IDNR
WHERE OH_client = 22

Please don`t forget to change client=22 to your client number....

Outcomes