diff artifacts/src/main/java/org/dive4elements/river/artifacts/model/sq/MeasurementFactory.java @ 8539:84929f882fa2

(issue1753) Carry measurement date through SQ values
author Andre Heinecke <andre.heinecke@intevation.de>
date Fri, 13 Feb 2015 12:34:06 +0100
parents a8fd76b15d41
children fe7e9da6312a
line wrap: on
line diff
--- a/artifacts/src/main/java/org/dive4elements/river/artifacts/model/sq/MeasurementFactory.java	Fri Feb 13 12:31:59 2015 +0100
+++ b/artifacts/src/main/java/org/dive4elements/river/artifacts/model/sq/MeasurementFactory.java	Fri Feb 13 12:34:06 2015 +0100
@@ -46,7 +46,8 @@
         "SELECT " +
             "m.Q_BPEGEL AS Q_BPEGEL,"+
             "m.TSCHWEB  AS TSCHWEB," +
-            "m.TSAND    AS TSAND " +
+            "m.TSAND    AS TSAND, " +
+            "m.DATUM    AS DATUM " +
         "FROM MESSUNG m " +
             "JOIN STATION   s ON m.STATIONID   = s.STATIONID " +
             "JOIN GEWAESSER r ON s.GEWAESSERID = r.GEWAESSERID " +
@@ -281,7 +282,8 @@
         SQLQuery query = session.createSQLQuery(SQL_TOTALS)
             .addScalar("Q_BPEGEL", StandardBasicTypes.DOUBLE)
             .addScalar("TSCHWEB",  StandardBasicTypes.DOUBLE)
-            .addScalar("TSAND",    StandardBasicTypes.DOUBLE);
+            .addScalar("TSAND",    StandardBasicTypes.DOUBLE)
+            .addScalar("DATUM",    StandardBasicTypes.DATE);
 
         query.setString("river_name", river);
         query.setDouble("location", location);

http://dive4elements.wald.intevation.org