Changes between Version 2 and Version 3 of OnyxDatabaseReporting

Timestamp:

06/21/11 16:19:18 (13 years ago)

Author:

Nick Holden

Comment:

--

OnyxDatabaseReporting

@@ -77 +77 @@
         GROUP BY category_name, barcode WITH ROLLUP;
 
+From the command line, to query for gender and birth date for specific diagnosis, into an outfile:#
+
+mysql -h briccsdb -u auditor -p briccs -e "
+SELECT category_name, birth_date, gender
+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' 
+AND category_answer.question_answer_id = question_answer.id 
+AND ( category_answer.category_name LIKE '%ACS%' OR category_answer.category_name = 'STEMI' OR category_answer.category_name = 'Stable Angina' )
+; 
+" > mysql-output.txt