biocore / labadmin

Administration website for the Knight Lab
4 stars 16 forks source link

get_ag_barcode_details pulls the kit email, not the participant email #246

Open wasade opened 6 years ago

wasade commented 6 years ago

A more accurate base query can be formed with:

select * 
    from ag.source_barcodes_surveys 
        join ag.ag_login_surveys using (survey_id) 
        join ag.ag_consent using (ag_login_id, participant_name) 
where barcode='foo';

This query needs to be expanded to touch ag_kit and ag_login to recreate the type of result from get_ag_barcode_details