Skip to content

v7.0.0-rc.8

v7.0.0-rc.8: Migrate legacy mappers to clinical_event_derived (#12039)
@alisman alisman tagged this 23 Mar 15:25 
* Rename clinical_event_derived table to clinical_event_data_derived

Update all ClickHouse mapper XML files and schema definition to
reference the renamed table.

Co-Authored-By: Claude Opus 4.6 <noreply@anthropic.com>

Migrate legacy mybatis mappers from clinical_event to clinical_event_derived

Legacy mapper files were still querying the base clinical_event table
directly. This migrates them to use clinical_event_derived which has
a proper primary key and includes denormalized patient_stable_id and
cancer_study_identifier columns for better query performance.

Also adds the missing INSERT INTO clinical_event_derived statement
in clickhouse.sql to populate the table with data from clinical_event
joined with patient and cancer_study.

Co-Authored-By: Claude Opus 4.6 <noreply@anthropic.com>

Fixes comment

Co-authored-by: Copilot Autofix powered by AI <175728472+Copilot@users.noreply.github.com>

Bump derived table schema version to 1.0.9

Co-Authored-By: Claude Opus 4.6 <noreply@anthropic.com>

Update clickhouse.sql (#12042)

adjust table aliases in mapper logic (#12043)

- use new derived table names
- fix a misnamed alias

* Fix incorrect column name in CancerStudyMapper treatment CTE

PR #12030 accidentally changed patient_unique_id to patient_stable_id
in the treatment count query against clinical_event_data_derived.
The table has always used patient_unique_id.

Co-Authored-By: Claude Opus 4.6 <noreply@anthropic.com>

---------

Co-authored-by: Claude Opus 4.6 <noreply@anthropic.com>
Assets 2
Loading