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 one CP from the user interface. 
2. Query for collection protocol identifiers for which the workflow is to be set from the database table catissue_collection_protocol.
   get_CP_ID

   select IDENTIFIER from catissue_collection_protocol where SHORT_TITLE in ('CP1', 'CP2', 'CP3', 'CP4');
   >>31
   32
   34
   37

3. Use the output of the above SQL for the below SQL

4. Below SQL sets the workflow set for 'AB Lung Cancer Trial' CP to the CPs with identifiers 31, 32, 34 and 37

   cp_workflow_update

   update os_cp_workflows a inner join os_cp_workflows b on b.cp_id = 1 set a.workflows = b.workflows where a.CP_ID in (31,32,34,37);