Methods in Use

Summary

Methods are attached directly to ItemRefs. Master Check report and Annotated CRF show Methods in the context of a study design. But if you want to get a report showing just Methods and where they are applied, this SQL is useful.

Note that it is of course possible to include any other fields available on these tables. Below are the key relationships joining Methods and their use all the way up through the study.

Also note that this query only shows Methods attached to locked forms. Please adjust the where clause as desired to filter by study or any other conditions appropriate to support your use case.

select method.name as method_name, item.name as item, ig.name as item_group, form.name as form, ap.name as activity_plan, study.name as study
from method
inner join item_ref ir on method.id = ir.method_id
inner join item on ir.item_id = item.id
inner join item_group ig on ir.item_group_id = ig.id
inner join item_group_ref igr on ig.id = igr.item_group_id
inner join form on igr.form_id = form.id
inner join study_meta_data on form.study_meta_data_id = study_meta_data.id
inner join study on study_meta_data.id = study.study_meta_data_id
left join scheduled_activity sa on form.id = sa.form_id
left join segment on sa.segment_id = segment.id
left join activity_plan ap on segment.activity_plan_id = ap.id
where form.locked = true and item.locked = true

Here is an example output: