revision-diff.txt (4.22 KB)
-
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