Clarity

  • Private Community

  • 1.  schema - SQL to update Process status

    Posted Dec 17, 2018 05:42 PM

    Hello

     

    May I know the table name that stores the status of the processes?

     

    We have a large number of custom processes that I need to change status to 'On Hold' before an upgrade activity.

     

    An Update statement will be a lot quicker compared to XOG or manual changes from the Admin menu.

     

    Please advise.

     

    Thank you.

    MJ



  • 2.  Re: schema - SQL to update Process status

    Posted Dec 17, 2018 06:11 PM

    Process status should be in BPM_ tables. I doubt if its stored just in one table. I know there is status_code in BPM_RUN_PROCESSES. For more information on BPM tables, refer to the below threads:

     

    https://communities.ca.com/blogs/georgy/2016/12/29/ca-ppm-process-tables-bpm-tables

    https://communities.ca.com/thread/18324634

     

    Regards,

    Praneeth



  • 3.  Re: schema - SQL to update Process status

    Posted Dec 17, 2018 09:53 PM

    We recently undertook an upgrade which had to place-on-hold around 160 processes.  This was undertaken manually.

     

    Not aware of a way to script this.