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

Document created by MaryGreening on Jul 8, 2014
Version 1Show Document
  • View in full screen mode
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

 

This document was generated from the following discussion: Nolio Official KB: How do I query The database for all published Processes?

Attachments

    Outcomes