Changes between Version 49 and Version 50 of Onyx to CiviCRM


Ignore:
Timestamp:
01/27/14 15:09:23 (11 years ago)
Author:
Richard Bramley
Comment:

--

Legend:

Unmodified
Added
Removed
Modified

  • Onyx to CiviCRM

    v49 v50  
    9696    SELECT
    9797          qp.participant_id
     98        , u.first_name + ' ' + u.last_name [interviewer_name]
    9899        , GROUP_CONCAT(if(qa.question_name = 'consent_q1', category_name, NULL)) AS q1
    99100        , GROUP_CONCAT(if(qa.question_name = 'consent_q2', category_name, NULL)) AS q2
    … …  
    105106    JOIN questionnaire_participant qp ON qp.id = qa.questionnaire_participant_id
    106107         AND qp.questionnaire_name = 'ManualConsentQuestionnaire'
     108    JOIN user u ON u.id = qp.user_id
    107109    GROUP BY qp.participant_id
    108110    ) consent ON consent.participant_id = p.id