Got feedback or spotted a mistake?

Leave a comment at the end of this page or email contact@krishagni.com

Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 5 Current »

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


  • No labels