xx30 analysis use cdm schema for vocabulary tables

[MaximMoinat]

The xx30 scripts use @cdmDatabaseSchema for vocabulary tables.

CatalogueExport/inst/sql/sql_server/analyses/430.sql

Line 9 in 066b8e7

JOIN @cdmDatabaseSchema.CONCEPT_ANCESTOR ca

These should be changed to @vocabDatabaseSchema.

[RomainTching]

Hello @MaximMoinat! I'm facing that issue right now, and having troubles fixing it even when trying to manually modify sqlOnly-produced files. Should I just reinstall the package from the dev branch where the fix was implemented, or would you suggest another approach?

[MaximMoinat]

Hi @RomainTching. Installing from dev is indeed the simplest solution (devtools::install_github("EHDEN/CatalogueExport", ref='dev'). Be aware this branch is not yet fully tested.

I will plan a new release, also including some other improvements.

[MaximMoinat]

Btw, another workaround is to create a view in your cdm schema:
CREATE VIEW @cdmDatabaseSchema.CONCEPT_ANCESTOR AS (SELECT * FROM @vocabDatabaseSchema.CONCEPT_ANCESTOR)