Automic Workload Automation

  • Private Community

  • 1.  SQL query to list all workflows that contain a certain task

    Posted Oct 18, 2016 07:40 AM
    I’m looking for an SQL (Oracle) query to list all workflows that contain a certain task. Does anyone have such a query handy?


  • 2.  SQL query to list all workflows that contain a certain task



  • 3.  SQL query to list all workflows that contain a certain task

    Posted Oct 18, 2016 09:54 AM

    This returns parent workflow & lnr for a given object plus the type to differenciate between common task and external task:

    select JPP_Lnr, OH_Name, JPP_OType
    from UC4.JPP
    join UC4.OH on JPP_OH_Idnr = OH_IDNR
    where JPP_Object = 'OBJECT'
    and OH_DeleteFlag = 0
    and OH_Client = 2020

    JPPA would hold the attributes.



  • 4.  SQL query to list all workflows that contain a certain task

    Posted Oct 18, 2016 10:22 AM
    Joel Wiesmann wrote:
    This returns parent workflow & lnr for a given object plus the type to differenciate between common task and external task:
    ...
    That’s exactly what I needed. Thanks, joel_wiesmann_automic !


  • 5.  SQL query to list all workflows that contain a certain task

    Posted Oct 18, 2016 02:12 PM
    You're welcome! Looking forward to meet you at the ERFA in Lichtenstein ;-).