Changes between Version 3 and Version 4 of BRICCS Study


Ignore:
Timestamp:
04/11/13 16:57:59 (12 years ago)
Author:
Nick Holden
Comment:

--

Legend:

Unmodified
Added
Removed
Modified

  • BRICCS Study

    v3 v4  
    2222After that first report, each month the report should be re-populated with a specific month's recruitment
    2323
    24 * mysql -h briccsdb -u auditor -p briccs -e "SELECT barcode, start_date, status FROM participant ptone, interview WHERE NOT EXISTS (SELECT 1 FROM participant pttwo WHERE pttwo.enrollment_id = ptone.enrollment_id LIMIT 1, 1 ) AND barcode is not null AND status <> 'CANCELLED' AND start_date > '01/02/2013 00:00' AND start_date < '01/03/2013 00:00' AND ptone.id = interview.participant_id order by start_date;" > briccs_enrollment_this_month.txt
     24* mysql -h briccsdb -u auditor -p briccs -e "SELECT barcode, start_date, status FROM participant ptone, interview WHERE NOT EXISTS (SELECT 1 FROM participant pttwo WHERE pttwo.enrollment_id = ptone.enrollment_id LIMIT 1, 1 ) AND barcode is not null AND status <> 'CANCELLED' AND start_date > '2013-03-01 00:00:00' AND start_date < '2013-04-01 00:00:00' AND ptone.id = interview.participant_id order by start_date;" > briccs_enrollment_this_month.txt
    2525
    2626Reports are generated and sent to Angel Christian at angel.christian@uhl-tr.nhs.uk