SQL to export fields with all comments from REDCap

export_fields_with_comments.sql

SELECT d.record, d.field_name, d.value, dqr.comment, dqr.ts as `Time Raised`, u.username as `User Assigned`, dqr.response
FROM `redcap_data` as d 

LEFT JOIN `redcap_data_quality_status` as dqs ON d.record = dqs.record AND d.field_name = dqs.field_name
LEFT JOIN `redcap_data_quality_resolutions` as dqr ON dqr.status_id = dqs.status_id
LEFT JOIN `redcap_user_information` as u ON dqs.assigned_user_id = u.ui_id

WHERE 
# exclude unneeded fields
d.field_name NOT LIKE "%_complete"
# define project
AND d.project_id = 49
AND dqr.comment IS NOT NULL

ORDER BY d.record