Changes between Version 7 and Version 8 of Onyx to CiviCRM

Timestamp:

12/09/13 15:50:14 (10 years ago)

Author:

Richard Bramley

Comment:

--

Onyx to CiviCRM

@@ -56 +56 @@
 {{{#!sql
 
+SELECT
+      p.id AS ParticipantID
+    , p.barcode AS StudyID
+    , p.first_name
+    , p.last_name
+    , p.birth_date
+    , p.gender
+    , p.enrollment_id AS UhlSystemNumber
+    , consent_q1.value AS consent_q1
+FROM participant p
+LEFT JOIN (
+    SELECT
+          qp.participant_id
+        , ca.category_name AS value
+    FROM question_answer qa
+    JOIN category_answer ca ON ca.question_answer_id = qa.id
+    JOIN questionnaire_participant qp ON qp.id = qa.questionnaire_participant_id
+         AND qp.questionnaire_name = 'ManualConsentQuestionnaire'
+    WHERE qa.question_name = 'consent_q1'
+    ) consent_q1 ON consent_q1.participant_id = p.id
+;
+
 }}}