Skip to content
This repository has been archived by the owner on Jul 29, 2020. It is now read-only.

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

Open
wasade opened this issue Mar 1, 2018 · 0 comments
Open

Comments

@wasade
Copy link
Member

wasade commented Mar 1, 2018

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

Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant