Clarity

  • Private Community

  • 1.  CA PPM 13.2 - TABLE PROCESS - COLUMN MODE

    Posted Nov 30, 2016 11:30 AM

    I look for the table of processes of processes that have the column MODE = ACTIVE, DRAFT, ON HOLD.

    Can somebody help me?

    Thanks in advance.



  • 2.  Re: CA PPM 13.2 - TABLE PROCESS - COLUMN MODE

    Posted Nov 30, 2016 11:41 AM

    Have you checked this ?

     

    Processes table to get status 

    https://communities.ca.com/message/241901376 

     

    NJ



  • 3.  Re: CA PPM 13.2 - TABLE PROCESS - COLUMN MODE

    Posted Nov 30, 2016 02:24 PM

    Thank you very much NJ, but I can not find the "MODE" field (active, draft, on hold)
    I need to make a report with the process id and the "mode" field but I do not know how to do it

     



  • 4.  Re: CA PPM 13.2 - TABLE PROCESS - COLUMN MODE
    Best Answer

    Broadcom Employee
    Posted Nov 30, 2016 02:44 PM

    Hi Ricardo,

     

    Take a look at the USER_STATUS_CODE column in the BPM_DEF_PROCESS_VERSIONS table.  I think you will find what you need there.

     

    Jeanne



  • 5.  Re: CA PPM 13.2 - TABLE PROCESS - COLUMN MODE

    Posted Nov 30, 2016 03:31 PM

    Hi Jeanne, thank you very much for your answer.
    This is I did looking for