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