Versions Compared

Old Version 4

changes.mady.by.user Vinayak Pawar

Saved on

compared with

New Version 5

changes.mady.by.user Harshita Shivhare

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

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.Image Modified

  2. Below SQL sets the workflow set for CP using UI (whose ID is 1) to other CPs (CP1, CP2, CP3, CP4)

    Code Block
    languagesql
    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



...