/

How to find CPs with custom JSON?

Got feedback or spotted a mistake?

Leave a comment at the end of this page or email contact@krishagni.com

How to find CPs with custom JSON?

Owned by Kaustubh Wadagavi

Last updated: about 7 hours ago

1 min read

The below query gives the list of CPs with custom JSON configured.

SELECT 
    cp.short_title
FROM 
    catissue_collection_protocol cp
JOIN 
    os_cp_workflows wf 
ON 
    cp.identifier = wf.cp_id
WHERE 
    wf.workflows IS NOT NULL
    AND cp.activity_status = 'Active';

Got feedback or spotted a mistake?

Leave a comment at the end of this page or email contact@krishagni.com