wiki:OpenSpecimen HowTo Use Expedited Entry for a Study

Version 8 (modified by Richard Bramley, 6 years ago) ( diff )

--

OpenSpecimen HowTo Use Expedited Entry for a Study

Tags: OpenSpecimen HowTo

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
  1. Log into the database and select the record from the os_cp_workflows table: 
SELECT * FROM os_cp_workflows;
  1. Take note of the CP_ID of a process that currently uses the expedited method.
  2. 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'

Note: See TracWiki for help on using the wiki.