/
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?

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';

Related content

How to configure workflows for multiple CPs at once?
How to configure workflows for multiple CPs at once?
More like this
Comprehensive List of JSON Properties and Values
Comprehensive List of JSON Properties and Values
More like this
Collection Protocol Groups (CPGs) (v6.2)
Collection Protocol Groups (CPGs) (v6.2)
More like this
Configuring Field Values per CP
Configuring Field Values per CP
More like this
Query across multiple CPs
Query across multiple CPs
More like this
Query for participants registered to multiple CPs
Query for participants registered to multiple CPs
More like this
Got feedback or spotted a mistake?

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