[Branch ~dhis2-devs-core/dhis2/trunk] Rev 9257: Analytics table, bool data

Support - Assistance technique
#1

revision-diff.txt (4.22 KB)

#2 
  •    select +=
··· 
  •        "cast(dv.value as double precision) " +

  •    select += valueExpression + " " +

       "from datavalue dv " +

       "left join _organisationunitgroupsetstructure ougs on dv.sourceid=ougs.organisationunitid " +

       "left join _orgunitstructure ous on dv.sourceid=ous.organisationunitid " +

       "left join _period_no_disaggregation_structure ps on dv.periodid=ps.periodid " +

       "left join dataelement de on dv.dataelementid=de.dataelementid " +

       "left join period pe on dv.periodid=pe.periodid " +

  •        "where de.valuetype='int' and pe.startdate >= '2011-10-01'";

  •        "where de.valuetype='" + valueType + "' and pe.startdate >= '2011-10-01'";

Hvis dette er noe du gjør for hver datavalue… så kan det være noe å vinne om du bruker en StringBuilder…

final String sql = insert + select;

     [log.info](http://log.info)( "Populate SQL: "+ sql );



     jdbcTemplate.execute( sql );

  •    [log.info](http://log.info)( "Populated analytics table" );

    }

    public List<String[]> getDimensionColumns()

Mailing list: https://launchpad.net/~dhis2-devs

Post to : dhis2-devs@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-devs

More help : https://help.launchpad.net/ListHelp