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:

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:

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:

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

Error: Macro BackLinks(None) failed

'Environment' object has no attribute 'get_db_cnx'