Changes between Version 8 and Version 9 of OpenSpecimen HowTo Use Expedited Entry for a Study

Timestamp:

09/17/18 11:33:36 (6 years ago)

Author:

Richard Bramley

Comment:

--

OpenSpecimen HowTo Use Expedited Entry for a Study

@@ -5 +5 @@
 == 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:
+1. Find the `cp_id` of the protocol 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. Alternatively, find the `cp_id` by ruuning the query:
+
+{{{
+#!sql
+SELECT IDENTIFIER AS cp_id, TITLE FROM catissue_collection_protocol;
+}}}
+
+3. Log into the database and select the record from the `os_cp_workflows` table:
 
 {{{
@@ -13 +21 @@
 }}}
 
-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:
+5. Take note of the `CP_ID` of a process that currently uses the expedited method.
+6. Duplicate the existing record with the new ID:
 
 {{{