Changes between Version 50 and Version 51 of Onyx to CiviCRM


Ignore:
Timestamp:
01/27/14 15:10:31 (10 years ago)
Author:
Richard Bramley
Comment:

--

Legend:

Unmodified
Added
Removed
Modified

  • Onyx to CiviCRM

    v50 v51  
    9696    SELECT
    9797          qp.participant_id
    98         , u.first_name + ' ' + u.last_name [interviewer_name]
     98        , u.first_name + ' ' + u.last_name AS interviewer_name
    9999        , GROUP_CONCAT(if(qa.question_name = 'consent_q1', category_name, NULL)) AS q1
    100100        , GROUP_CONCAT(if(qa.question_name = 'consent_q2', category_name, NULL)) AS q2