#335: reduce DataBuilder dependencies to i2b2 platform: ant, JVM, JDBC, jboss --------------------------+------------------------ Reporter: dconnolly | Owner: Type: enhancement | Status: closed Priority: major | Milestone: gpc2sites Component: data-sharing | Resolution: fixed Keywords: | Blocked By: Blocking: | --------------------------+------------------------
Comment (by gkowalski): OMG , we're going to need a machine gun to shoot down all these herons : {{{ CTSI-iMac-gkowalski:seine-minibuilder-0.5-f08eb078cb97 gkowalsk$ cd sql- ora/ CTSI-iMac-gkowalski:sql-ora gkowalsk$ grep blue * concept_dimension_extract.sql: blueherondata.qt_query_result_instance v concept_dimension_extract.sql:join blueherondata.concept_dimension cd on cd.concept_path like (v.variable_path || '%') observation_fact_extract.sql:from blueherondata.qt_query_instance job observation_fact_extract.sql:blueherondata.qt_query_result_instance v, job observation_fact_extract.sql:join blueherondata.qt_patient_set_collection pset on pset.result_instance_id = job.patient_set observation_fact_extract.sql:join blueherondata.concept_dimension cd on cd.concept_path like (v.variable_path || '%') observation_fact_extract.sql:cross join blueherondata.observation_fact obs patient_dimension_extract.sql:from blueherondata.qt_query_instance job patient_dimension_extract.sql:join blueherondata.qt_patient_set_collection pset on pset.result_instance_id = job.patient_set patient_dimension_extract.sql:join blueherondata.patient_dimension pat on pat.patient_num = pset.patient_num variable_extract.sql:from blueherondata.qt_query_result_instance v CTSI-iMac-gkowalski:sql-ora gkowalsk$ }}} ok expunging the bird form these 4 scripts . -- Ticket URL: <http://informatics.gpcnetwork.org/trac/Project/ticket/335#comment:36> gpc-informatics <http://informatics.gpcnetwork.org/> Greater Plains Network - Informatics _______________________________________________ Gpc-dev mailing list Gpc-dev@listserv.kumc.edu http://listserv.kumc.edu/mailman/listinfo/gpc-dev