Pre-requisite: User needs to have access to the database to execute the SQL query.
Steps:
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 |