Changes between Version 5 and Version 6 of OnyxDatabaseReporting

Timestamp:

01/18/12 12:49:41 (14 years ago)

Author:

Nick Holden

Comment:

--

OnyxDatabaseReporting

@@ -118 +118 @@
 ;
 
+Using UNION to produce a list of S numbers and DOBs for participants who are either study specific recruits or have a specific primary or secondary diagnosis:
+
+mysql -h briccsdb -u auditor -p briccs -e " 
+SELECT barcode as 'Participant', birth_date as 'DOB'
+FROM participant, questionnaire_participant, question_answer, category_answer 
+WHERE participant.id = questionnaire_participant.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'
+FROM participant, questionnaire_participant, question_answer, category_answer 
+WHERE participant.id = questionnaire_participant.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'
+; 
+ " > mysql-output.txt