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 sets query is the workflow set for CP using UI (whose ID is 1) to other CPs (CP1, CP2, CP3, CP4).
Code Block language sql 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
...