Totalnum: c_operator issue in pcornet_enc table #1
Description
This issue affects the execution of totalnum script on pcornet_enc metadata table. We encountered this in PostgreSQL.
Value in c_operator in one of the rows is incompatible with the c_dimcode. For c_dimcode '\PCORI\ENCOUNTER\VERSION', the current c_operator is 'IN'. This creates the following erroneous sql during totalnum execution:
select count(distinct(patient_num)) from i2b2demodata.visit_dimension where patient_num in (select patient_num from i2b2demodata.visit_dimension where location_zip in (\PCORI\ENCOUNTER\VERSION));
ERROR: syntax error at or near ""
LINE 1: ...b2demodata.visit_dimension where location_zip in (\PCORI\ENC...
To correct this issue, c_operator should be 'LIKE' in the metadata table.