Changes between Version 4 and Version 5 of OpenSpecimen HowTo Use Expedited Entry for a Study

Timestamp:

03/21/16 14:32:20 (10 years ago)

Author:

Richard Bramley

Comment:

--

OpenSpecimen HowTo Use Expedited Entry for a Study

@@ -3 +3 @@
 Tags: [[OpenSpecimen]] [[HowTo]]
 
-== Procedure
+== Procedure 1
+
+- Find the `cp_id` of the protocal to use the expedited method.  This can be obtained from the URL when viewing the protocol or its participants.  For example `https://www15.lamp.le.ac.uk/openspecimen/#/cp-view/12/participants`
+2. Log into the database and select the record from the `os_cp_workflows` table:
+
+{{{
+#!sql
+SELECT * FROM os_cp_workflows;
+}}}
+
+3. Take note of the `CP_ID` of a process that currently uses the expedited method.
+4. Duplicate the existing record with the new ID:
+
+{{{
+#!sql
+INSERT INTO os_cp_workflows SELECT {new_cp_id}, WORKFLOW FROM os_cp_workflows WHERE CP_ID = {old_cp_id};
+}}}
+
+== Procedure 2
 
 The settings are set using the REST API. See [[https://openspecimen.atlassian.net/wiki/display/CAT/UK+configuration;jsessionid=DAE0BD2C084248321CE32F05F0966221|OpenSpecimen REST API Documentation]].