Release Automation

Nolio Official KB: How do I query The database for all published Processes?

  • 1.  Nolio Official KB: How do I query The database for all published Processes?

    Posted Dec 18, 2013 04:16 PM
    The following SQL query will generate a list of all published process:
     
    SELECT id,process_name FROM process_container p where EXISTS ( 
     
    SELECT 1 
     
    FROM published_process e 
     
    WHERE e.originalProcessId = p.id 
     
    ) and p.parent_category_id is not null