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 below.
Below SQL sets 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