Changes between Version 25 and Version 26 of Onyx to CiviCRM

Timestamp:

01/07/14 08:57:26 (11 years ago)

Author:

Richard Bramley

Comment:

--

Onyx to CiviCRM

@@ -84 +84 @@
     , pa.telephone
     , pa.workphone
+    , mra.most_recent_action
 FROM participant p
 JOIN interview i ON i.participant_id = p.id
@@ -117 +118 @@
     GROUP BY pa.participant_id
     ) pa ON pa.participant_id = p.id
+JOIN (
+    SELECT
+          interview_id
+        , MAX(date_time) most_recent_action
+    FROM action
+    GROUP BY interview_id
+    ) mra ON mra.interview_id = i.interview_id
 ;