Changes between Version 52 and Version 53 of Onyx to CiviCRM


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

--

Legend:

Unmodified
Added
Removed
Modified

  • Onyx to CiviCRM

    v52 v53  
    9797    SELECT
    9898          qp.participant_id
    99         , u.first_name + ' ' + u.last_name AS interviewer_name
     99        , CONCAT(u.first_name, ' ', u.last_name) AS interviewer_name
    100100        , GROUP_CONCAT(if(qa.question_name = 'consent_q1', category_name, NULL)) AS q1
    101101        , GROUP_CONCAT(if(qa.question_name = 'consent_q2', category_name, NULL)) AS q2