Changes between Version 12 and Version 13 of Onyx to CiviCRM

Timestamp:

12/13/13 08:52:36 (10 years ago)

Author:

Richard Bramley

Comment:

--

Onyx to CiviCRM

@@ -19 +19 @@
 - [x] Date and Time of Interview {Interview.start_date}
 - [x] Partiticant Number (Participant.barcode)
-- [ ] Interview Status (Interview.status) Values of
+- [x] Interview Status (Interview.status) Values of
  - IN_PROGRESS
  - CLOSED
@@ -60 +60 @@
     , i.start_date AS interviewDate
     , p.barcode AS StudyID
+    , i.status AS interviewStatus
+    , pa.title
     , p.first_name
     , p.last_name
@@ -86 +88 @@
     GROUP BY qp.participant_id
     ) consent ON consent.participant_id = p.id
+LEFT JOIN (
+    SELECT
+        pa.participant_id
+      , GROUP_CONCAT(if(pa.attribute_name = 'pat_title', pa.text_value, NULL)) AS title
+    FROM participant_attribute_value pa
+    GROUP BY pa.participant_id
+    ) pa ON pa.participant_id = p.id
 ;