The below query gives the list of CPs with custom JSON configured.
| Code Block |
|---|
selectSELECT cp.short_title, FROM wf.workflows from catissue_collection_protocol cp JOIN os_cp_workflows wf ON cp.identifier = wf.cp_id whereWHERE wf.workflows isIS notNOT nullNULL and AND cp.activity_status = 'Active' and wf.workflows <> ''; |