diff artifacts/src/main/java/org/dive4elements/river/artifacts/states/GaugeTimerangeState.java @ 5916:d6bf8353e0fc

Historical discharge curves: Do not add calculation relevant curve into list of available curves.
author Sascha L. Teichmann <teichmann@intevation.de>
date Tue, 07 May 2013 19:07:08 +0200
parents 1272d52e052e
children af13ceeba52a
line wrap: on
line diff
--- a/artifacts/src/main/java/org/dive4elements/river/artifacts/states/GaugeTimerangeState.java	Tue May 07 18:19:57 2013 +0200
+++ b/artifacts/src/main/java/org/dive4elements/river/artifacts/states/GaugeTimerangeState.java	Tue May 07 19:07:08 2013 +0200
@@ -47,7 +47,7 @@
                 "SELECT min(start_time) as min, max(stop_time) as max " +
                         "FROM time_intervals WHERE id in " +
                         "(SELECT time_interval_id FROM discharge_tables " +
-                "WHERE gauge_id =:gid)");
+                "WHERE kind <> 0 and gauge_id =:gid)");
 
         query.addScalar("min", StandardBasicTypes.CALENDAR);
         query.addScalar("max", StandardBasicTypes.CALENDAR);

http://dive4elements.wald.intevation.org