Changes between Version 4 and Version 5 of OnyxDatabaseReporting

Timestamp:

01/16/12 15:10:40 (14 years ago)

Author:

Nick Holden

Comment:

--

OnyxDatabaseReporting

@@ -89 +89 @@
 ; 
 " > mysql-output.txt
+
+
+Single diagnosis, count:
+
+SELECT count(participant.id) as 'Number of Participants' 
+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';
+
+
+Complex query, using two references to the same tables, to derive those of a certain diagnosis (primary or secondary) where the recruitment context is not 'Study specific':
+
+SELECT count(participant.id) as 'AS not study recruited' 
+FROM participant, questionnaire_participant as diag_questionnaire, questionnaire_participant as context_questionnaire, question_answer as diag_question, category_answer as diag_answer, question_answer as context_question, category_answer as context_answer
+WHERE participant.id = diag_questionnaire.participant_id  
+AND participant.id = context_questionnaire.participant_id  
+AND diag_questionnaire.id = diag_question.questionnaire_participant_id
+AND ( diag_question.question_name = 'epi_pridiag' OR diag_question.question_name = 'epi_secdiag' )
+AND diag_answer.question_answer_id = diag_question.id 
+AND diag_answer.category_name = 'Aortic_Stenosis'
+AND context_questionnaire.id = context_question.questionnaire_participant_id
+AND context_question.question_name = 'epi_type'
+AND context_answer.question_answer_id = context_question.id 
+AND context_answer.category_name <> 'Study_specific' 
+;
+