Changes between Version 13 and Version 14 of OnyxDatabaseReporting

Timestamp:

10/03/13 14:11:29 (11 years ago)

Author:

Nick Holden

Comment:

--

OnyxDatabaseReporting

@@ -223 +223 @@
 AND ptone.id = interview.participant_id order by start_date;"
 
+=== AS study monitoring ===
+
+To extract all relevant (study specific and by diagnosis) recruits with their recruitment dates, for compiling into a spreadsheet, use:
+
+
+
+mysql -h briccsdb -u auditor -p briccs_northampton -e " SELECT barcode as 'Participant', birth_date as 'DOB', start_date as 'Questionnaire Date' FROM participant, questionnaire_participant, interview, question_answer, category_answer WHERE participant.id = questionnaire_participant.participant_id AND participant.id = interview.participant_id AND question_answer.questionnaire_participant_id = questionnaire_participant.id AND ( question_answer.question_name = 'epi_pridiag' OR question_answer.question_name = 'epi_secdiag' ) AND category_answer.question_answer_id = question_answer.id AND category_answer.category_name = 'Aortic_Stenosis' UNION SELECT barcode as 'Participant', birth_date as 'DOB',start_date as 'Questionnaire Date' FROM participant, interview, questionnaire_participant, question_answer, category_answer WHERE participant.id = questionnaire_participant.participant_id AND participant.id = interview.participant_id AND question_answer.questionnaire_participant_id = questionnaire_participant.id AND question_answer.question_name = 'epi_type' AND category_answer.question_answer_id = question_answer.id AND category_answer.category_name = 'Study_specific' ; " > northampton-output.txt 
+
+AND
+
+
+mysql -h briccsdb -u auditor -p briccs -e " SELECT barcode as 'Participant', birth_date as 'DOB', start_date as 'Questionnaire Date' FROM participant, questionnaire_participant, interview, question_answer, category_answer WHERE participant.id = questionnaire_participant.participant_id AND participant.id = interview.participant_id AND question_answer.questionnaire_participant_id = questionnaire_participant.id AND ( question_answer.question_name = 'epi_pridiag' OR question_answer.question_name = 'epi_secdiag' ) AND category_answer.question_answer_id = question_answer.id AND category_answer.category_name = 'Aortic_Stenosis' UNION SELECT barcode as 'Participant', birth_date as 'DOB',start_date as 'Questionnaire Date' FROM participant, interview, questionnaire_participant, question_answer, category_answer WHERE participant.id = questionnaire_participant.participant_id AND participant.id = interview.participant_id AND question_answer.questionnaire_participant_id = questionnaire_participant.id AND question_answer.question_name = 'epi_type' AND category_answer.question_answer_id = question_answer.id AND category_answer.category_name = 'Study_specific' ; " > leicester-output.txt 
+