Changes between Version 7 and Version 8 of OnyxDatabaseReporting

Timestamp:

01/18/12 12:51:36 (13 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:
+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 (UNION combines two SELECTs with duplicates removed):
 
 mysql -h briccsdb -u auditor -p briccs -e " 
-SELECT barcode as 'Participant', birth_date as 'DOB'
+SELECT enrollment_id as 'Participant', birth_date as 'DOB'
 FROM participant, questionnaire_participant, question_answer, category_answer 
 WHERE participant.id = questionnaire_participant.participant_id 
@@ -129 +129 @@
 AND category_answer.category_name = 'Aortic_Stenosis'
 UNION
-SELECT barcode as 'Participant', birth_date as 'DOB'
+SELECT enrollment_id as 'Participant', birth_date as 'DOB'
 FROM participant, questionnaire_participant, question_answer, category_answer 
 WHERE participant.id = questionnaire_participant.participant_id