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:

1. Import the workflow for at least one CP using UI as shown below.

2. 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