New Features
- Cohort Characterization (#495, #588) - thanks @pavgra, @chrisknoll, @wivern, @gowthamrao, @davekern
- Cohort Pathways (#522, #608) - thanks @chrisknoll, @wivern, @pavgra, @anthonysena, @pbr6cornell
- New editors for Population Level Effect Estimation & Patient Level Prediction to support large scale study design (#568, #620, #643) - thanks @anthonysena, @schuemie, @jreps, @PRijnbeek, @ericaVoss, @pbr6cornell, @pavgra, @chrisknoll
- Support for CAS authenication (#589) - thanks @chen-regen, @pavgra
Fixes
- Normalize user references in the database to use IDs (#582) - thanks @wivern, @pavgra
- Renamed migration script names to follow conventions (#586) - thanks @chrisknoll, @pavgra
- Fixed hibernate proxy initialization error in coverters (#596) - thanks @wivern, @pavgra
- Fixed AD User Import (#602, #614) - thanks @mpozhidaeva, @pavgra
- Added logging of security-related events (#591) - thanks @aklochkova, @pavgra
- Fixed application.properties (#635) - thanks @aklochkova, @pavgra
- Get cohort definition list leads to N+1 read problem (#625) - thanks @chrisknoll
... and many others which are here: https://github.com/OHDSI/WebAPI/milestone/17?closed=1
Migration Notes
Use SqlRender to translate the following SQL for your specific environment and run on all CDM results schemas:
CREATE TABLE @results_schema.cc_results
(
type VARCHAR(255) NOT NULL,
fa_type VARCHAR(255) NOT NULL,
cc_generation_id BIGINT NOT NULL,
analysis_id INTEGER,
analysis_name VARCHAR(1000),
covariate_id BIGINT,
covariate_name VARCHAR(1000),
time_window VARCHAR(255),
concept_id INTEGER,
count_value BIGINT,
avg_value DOUBLE PRECISION,
stdev_value DOUBLE PRECISION,
min_value DOUBLE PRECISION,
p10_value DOUBLE PRECISION,
p25_value DOUBLE PRECISION,
median_value DOUBLE PRECISION,
p75_value DOUBLE PRECISION,
p90_value DOUBLE PRECISION,
max_value DOUBLE PRECISION,
cohort_definition_id BIGINT
);
IF OBJECT_ID('@results_schema.pathway_analysis_events', 'U') IS NULL
CREATE TABLE @results_schema.pathway_analysis_events
(
pathway_analysis_generation_id BIGINT NOT NULL,
target_cohort_id INTEGER NOT NULL,
combo_id BIGINT NOT NULL,
subject_id BIGINT NOT NULL,
ordinal INTEGER,
cohort_start_date DATETIME NOT NULL,
cohort_end_date DATETIME NOT NULL
);
CREATE TABLE @results_schema.pathway_analysis_stats
(
pathway_analysis_generation_id BIGINT NOT NULL,
target_cohort_id INTEGER NOT NULL,
target_cohort_count INTEGER NOT NULL,
pathways_count INTEGER NOT NULL
);
CREATE INDEX idx_pathway_analysis_events_combo_id ON @results_schema.pathway_analysis_events (combo_id);