= OpenSpecimen HowTo Use Expedited Entry for a Study

Tags: [[OpenSpecimen]] [[HowTo]]

== Procedure 1

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:

{{{
#!sql
SELECT * FROM os_cp_workflows;
}}}

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:

{{{
#!sql
INSERT INTO os_cp_workflows SELECT {new_cp_id}, WORKFLOWS FROM os_cp_workflows WHERE CP_ID = {old_cp_id};
}}}


[[BackLinks]]