I found two Cohort Characterization SQLs that do not use @vocabulary_database_schema, for example in distributionRetrieving.sql line 29:
left join @cdm_database_schema.concept c on c.concept_id = fr.concept_id;
If rewritten as:
left join @vocabulary_database_schema.concept c on c.concept_id = fr.concept_id;
it could fetch concepts from the vocabulary daimon.
The same goes with prevalenceRetrieving.sql.
PS: I was trying to fix this on current WebAPI release, but maybe it's better fix here and wait for 2.8?
I found two Cohort Characterization SQLs that do not use
@vocabulary_database_schema
, for example in distributionRetrieving.sql line 29:left join @cdm_database_schema.concept c on c.concept_id = fr.concept_id;
If rewritten as:
left join @vocabulary_database_schema.concept c on c.concept_id = fr.concept_id;
it could fetch concepts from the vocabulary daimon.The same goes with
prevalenceRetrieving.sql
.PS: I was trying to fix this on current WebAPI release, but maybe it's better fix here and wait for 2.8?