AppWorx, Dollar Universe and Sysload Community

  • 1.  How to create abort documentation report?

    Posted Apr 05, 2019 06:56 PM

    Good Afternoon,

     

    I need to create a report of all the Abort Documentation for jobs/process flows.  How about I go about getting this information (AM v9.2.1)? I see the documentation text is in so_documentation but don't know how to link that back to the job/process flow.

     

    Thanks,

    Adriana 



  • 2.  Re: How to create abort documentation report?
    Best Answer

    Broadcom Employee
    Posted Apr 26, 2019 06:36 PM

    The Primary Key for the SO_DOCUMENTATION table is the SO_DOC_SEQ column.

     

    Jobs and Process Flows are stored in the SO_JOB_TABLE whose Primary Key is the SO_JOB_SEQ column.

     

    The SO_DOC_SEQ and SO_JOB_SEQ columns are directly related meaning an Abort documentation which has a SO_DOC_SEQ value of 9 belongs to the Job/Process Flow which has a SO_JOB_SEQ value of 9.



  • 3.  Re: How to create abort documentation report?

    Posted May 07, 2019 09:37 AM

    Thank you! That is exactly what I needed.

    -Adriana