Got feedback or spotted a mistake?
Leave a comment at the end of this page or email contact@krishagni.com
How to configure workflows for multiple CPs at once?
Pre-requisite: User needs to have access to the database to execute the SQL query.
Steps:
- Import the workflow for at least one CP using UI as shown below.
Below SQL query is the workflow set for CP using UI (whose ID is 1) to other CPs (CP1, CP2, CP3, CP4).
insert into os_cp_workflows select cp.identifier, (select workflows from os_cp_workflows where cp_id = 1) from catissue_collection_protocol cp where cp.short_title in ('CP1', 'CP2', 'CP3', 'CP4') and cp.identifier != 1
Got feedback or spotted a mistake?
Leave a comment at the end of this page or email contact@krishagni.com