For Functions in SubSelect, wrong DataType is returned
SELECT patient_num, concept_cd_sub, count(*) AS counts FROM ( SELECT patient_num, substring(concept_cd from 1 for 7) AS concept_cd_sub FROM i2b2demodata.observation_fact WHERE concept_cd IN ( SELECT concept_cd FROM i2b2demodata.concept_dimension WHERE (concept_path LIKE '\\\\ATC\\\\%' OR concept_path LIKE '\\\\ICD\\\\%')) AND (start_date >= '2007-01-01T00:00:00' AND start_date <= '2008-01-01T00:00:00') AND (TRUE = TRUE OR patient_num IN ( SELECT patient_num FROM i2b2demodata.qt_patient_set_collection WHERE result_instance_id = -1))) observations GROUP BY patient_num, concept_cd_sub
For Functions in SubSelect, wrong DataType is returned
concept_cd_sub should return STRING50